You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "xuyang (Jira)" <ji...@apache.org> on 2021/11/16 02:27:00 UTC

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

xuyang created FLINK-24914:
------------------------------

             Summary: 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


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)