[FLINK-32711] Type mismatch when proctime function used as parameter

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available stale-major
• Assignee: Unassigned
• Reporter: WenJun Min
• Created: 28/Jul/23 14:02
• Updated: 28/Mar/24 12:10

Description

reproduce case:

SELECT TYPEOF(PROCTIME())

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)'.

Issue Links

• links to: GitHub Pull Request #23107