[FLINK-24403] Improve behaviour of CAST

• Type: Improvement
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: Table SQL / API, Table SQL / Planner
• Assignee: Marios Trivyzas
• Reporter: Marios Trivyzas
• Created: 29/Sep/21 13:49
• Updated: 11/Aug/23 08:13

Description

Meta issue to include or relevant bugs and improvements around the functionality of CAST.

 

Issue Links

• is related to: FLINK-21456 TableResult#print() should correctly stringify values

Sub-Tasks

• Support cast from BINARY/VARBINARY/BYTES to of RAW(<clazz>): In Progress
• Refactor timestamp<->number validation messages: In Progress
• Decide the overflows behaviour: Open
• Casting to a "narrower" type doesn't throw exception but follows Java overflow: Open
• Improve error message for "Unsupported casting": Open
• User defined functions refuse to accept multi-set arguments without type hints: Open
• When creating a TIMESTAMP_LTZ only allow Instant: Open
• Cast from TIME to TIMESTAMP currently uses Epoch Date: Open
• Add support for casting from a single type to the corresponding array: Open
• Add support for cast from a string to an INTERVAL: Open
• Fix casting between interval types: Open
• Drop support for casting decimal numerics to boolean for SQL: Open
• Optimisation of chained cast calls can lead to unexpected behaviour: Open
• Casting of Multisets to Multisets: Open
• Remove identity casting from ScalarOperatorGens: Open
• Support cast from BYTES to NUMBER: Open
• Support cast from NUMBER to BYTES: Open
• Avoid scientific notation for DOUBLE to STRING: Open