[
https://issues.apache.org/jira/browse/FLINK-24914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17444469#comment-17444469
]
Martijn Visser commented on FLINK-24914:
----------------------------------------
Please make sure that the FLIP-154 is first brought up for discussion again,
because it hasn't been discussed thoroughly (the template is also not 100%
correct) and also hasn't been voted on. Only after a positive vote, work on
this topic can be started.
> 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)
