[ https://issues.apache.org/jira/browse/FLINK-24492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17426562#comment-17426562 ]
xuyangzhong commented on FLINK-24492: ------------------------------------- link https://issues.apache.org/jira/browse/FLINK-18234 > incorrect implicit type conversion between numeric and (var)char > ---------------------------------------------------------------- > > Key: FLINK-24492 > URL: https://issues.apache.org/jira/browse/FLINK-24492 > Project: Flink > Issue Type: Bug > Reporter: xuyangzhong > Priority: Minor > > The result of the sql "select 1 = '1'" is false. This is caused by the > CodeGen. CodeGenĀ incorrectly transform this "=" to "BinaryStringData.equals > (int 1)". And "<>" has the same wrong result. > In my opinion, "=" should have the same behavior with ">" and "<", which have > the correct results. So before calcite solves this bug, we'd better > temporarily forbidding this implicit type conversion in "=" and "<>". -- This message was sent by Atlassian Jira (v8.3.4#803005)