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)
