[
https://issues.apache.org/jira/browse/FLINK-24914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17444239#comment-17444239
]
Jing Zhang edited comment on FLINK-24914 at 11/16/21, 2:53 AM:
---------------------------------------------------------------
[~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]?
was (Author: qingru zhang):
[~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)
