[FLINK-21566] Improve error message for "Unsupported casting"

• Type: Sub-task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.12.1
• Component/s: Table SQL / API
• Labels: stale-major usability
• Assignee: Unassigned
• Reporter: Nico Kruber
• Created: 02/Mar/21 16:36
• Updated: 29/Sep/21 14:39

Description

In a situation like from FLINK-21565, neither the error message Unsupported casting from TINYINT to INTERVAL SECOND(3), nor the exception trace (see FLINK-21565) gives you a good hint on where the error is, especially if you have many statements with TINYINTs or operations on these.

The query parser could highlight the location of the error inside the SQL statement that the user provided.