[
https://issues.apache.org/jira/browse/FLINK-32711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17748626#comment-17748626
]
Aitozi commented on FLINK-32711:
--------------------------------
It's caused by the hard coded nullable result type of PROCTIME_MATERIALIZE
codegen.
> Type mismatch when proctime function used as parameter
> ------------------------------------------------------
>
> Key: FLINK-32711
> URL: https://issues.apache.org/jira/browse/FLINK-32711
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Affects Versions: 1.18.0
> Reporter: Aitozi
> Priority: Major
>
> reproduce case:
> {code:sql}
> SELECT TYPEOF(PROCTIME())
> {code}
> this query will fail with
> org.apache.flink.table.planner.codegen.CodeGenException: Mismatch of
> function's argument data type 'TIMESTAMP_LTZ(3) NOT NULL' and actual argument
> type 'TIMESTAMP_LTZ(3)'.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
