[jira] [Created] (FLINK-21978) Disable cast conversion between Numeric type and TIMESTAMP_LTZ type

[Shang Yuanchun (Jira)]

Leonard Xu created FLINK-21978:
----------------------------------

             Summary: Disable cast conversion between Numeric type and TIMESTAMP_LTZ type
                 Key: FLINK-21978
                 URL: https://issues.apache.org/jira/browse/FLINK-21978
             Project: Flink
          Issue Type: Task
          Components: Table SQL / Planner
    Affects Versions: 1.13.0
            Reporter: Leonard Xu


Currently we has supported the cast conversion between Numeric type and TIMESTAMP_LTZ type, we suppose the numeric value e.g `Long type 1000L` as epoch seconds and then cast  to TIMESTAMP_LTZ, but the java.lang.Long is a conversion class of `LocalZonedTimestampType`  and treats as milliseconds.

To avoid the inconsistency, we should disable it and encourage user to use `TO_TIMESTAMP_LTZ(numeric, precisoon)` function.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)