[FLINK-32699] select typeof(proctime()); throw exception in sql-client

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.18.0
• Fix Version/s: 1.20.0
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: Jacky Lau
• Created: 27/Jul/23 05:11
• Updated: 11/Mar/24 12:43

Description

Flink SQL> select typeof(proctime()); 
 
[ERROR] Could not execute SQL statement. Reason: 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)'