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)

Reply via email to