[ https://issues.apache.org/jira/browse/FLINK-24492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
xuyangzhong updated FLINK-24492: -------------------------------- Description: 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 or flink supports this kind of implicit type conversion, we'd better temporarily forbidding this implicit type conversion in "=" and "<>". was: 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 or flink support this kind of implicit type conversion, we'd better temporarily forbidding this implicit type conversion in "=" and "<>". > 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 or flink supports this > kind of implicit type conversion, we'd better temporarily forbidding this > implicit type conversion in "=" and "<>". -- This message was sent by Atlassian Jira (v8.3.4#803005)