[FLINK-21698] Disable problematic cast conversion between NUMERIC type and TIMESTAMP type

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available

Release Note

The CAST operation between NUMERIC type and TIMESTAMP type is problematic and is disabled now, e.g. CAST(numeric AS TIMESTAMP(3)) is disabled and should use TO_TIMESTAMP(FROM_UNIXTIME(numeric)) instead.

• Assignee: Leonard Xu
• Reporter: Leonard Xu
• Created: 10/Mar/21 04:20
• Updated: 26/Mar/21 07:30
• Resolved: 26/Mar/21 07:30

Description

The cast conversion  between NUMERIC type and TIMESTAMP type is problematic , we should disable it, NUMERIC type and TIMESTAMP_LTZ type cast conversion is valid.

Issue Links

• links to: GitHub Pull Request #15132