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

["Jing Zhang (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-24914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17444239#comment-17444239 ] 

Jing Zhang commented on FLINK-24914:
------------------------------------

[~xuyangzhong] Thanks for create this jira. +1 on this improvement. Does this Jira propose to finish [FLIP-154](https://cwiki.apache.org/confluence/display/FLINK/FLIP-154%3A+SQL+Implicit+Type+Coercion|http://example.com)?

> 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
>            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)