Fabian Hueske created FLINK-36642: ------------------------------------- Summary: Table API expressions with several built-in functions are not correctly serialized to SQL Key: FLINK-36642 URL: https://issues.apache.org/jira/browse/FLINK-36642 Project: Flink Issue Type: Bug Components: Table SQL / API Affects Versions: 1.19.1, 1.20.0, 2.0.0 Reporter: Fabian Hueske Assignee: Fabian Hueske
There are several built-in functions in Table API that are not correctly translated into SQL expressions: {{toTimestamp($("fld"), "yyyy-MM-dd hh:mm:ss")}} translates to {{TOTIMESTAMP(fld, 'yyyy-MM-dd hh:mm:ss')}} however, the SQL function is called {{{}TO_TIMESTAMP{}}}. There are several functions for which the SQL translation misses the {{_}} character. Incomplete list: * {{dateFormat()}} → {{DATE_FORMAT()}} * {{convertTz()}} → {{CONVERT_TZ()}} * {{fromUnixtime()}} → {{FROM_UNIXTIME()}} * {{unixTimestamp()}} → {{UNIX_TIMESTAMP()}} * {{toTimestampLtz()}} → {{TO_TIMESTAMP_LTZ()}} * {{toTimestamp()}} → {{TO_TIMESTAMP()}} * {{toDate()}} → {{TO_DATE()}} * {{charLength()}} → {{CHAR_LENGTH()}} -- This message was sent by Atlassian Jira (v8.20.10#820010)