[
https://issues.apache.org/jira/browse/FLINK-24914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Martijn Visser updated FLINK-24914:
-----------------------------------
Component/s: Table SQL / Planner
> Support implicit type conversion in SQL like "select int_field =
> varchar_field"
> -------------------------------------------------------------------------------
>
> Key: FLINK-24914
> URL: https://issues.apache.org/jira/browse/FLINK-24914
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Reporter: xuyang
> Priority: Minor
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
