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)
