[
https://issues.apache.org/jira/browse/FLINK-36642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated FLINK-36642:
-----------------------------------
Labels: pull-request-available (was: )
> 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: 2.0.0, 1.20.0, 1.19.1
> Reporter: Fabian Hueske
> Assignee: Fabian Hueske
> Priority: Major
> Labels: pull-request-available
>
> 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)
