[FLINK-24914] Support implicit type conversion in SQL like "select int_field = varchar_field"

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: xuyang
• Created: 16/Nov/21 02:26
• Updated: 16/Jun/23 06:47
• Resolved: 16/Jun/23 06:45

Description

Before, "select int_field = varchar_field" will be converted to "BinaryStringData.equals (int xxx)", so we always get FALSE.

Currently, we temporarily forbid "=" and "<>" between numeric and (var)char fields in SQL API, just like what have been done in Table API.

In future, we can support the implicit type conversion in Flink SQL and let this kind of SQL have the correct result.

Issue Links

• duplicates: FLINK-17484 [FLIP-154] Enable type coercion