[jira] [Created] (FLINK-21425) Incorrect implicit conversions in equals and notEquals filter predicates lead to not correctly evaluated by Table API

["Suxing Lee (Jira)" <ji...@apache.org>]

Suxing Lee created FLINK-21425:
----------------------------------

             Summary: Incorrect implicit conversions in equals and notEquals filter predicates lead to not correctly evaluated by Table API
                 Key: FLINK-21425
                 URL: https://issues.apache.org/jira/browse/FLINK-21425
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
    Affects Versions: 1.12.1
            Reporter: Suxing Lee


Equality and NotEquality filter predicates do not work on Tables when leftTerm and rightTerm type is mismatch(one is string ,another is integer)

column : a,b,c
the test data is as follows :
1,1L,"Hi"
2,2L,"Hello"
3,2L,"Hello world"

for query : SELECT a,b,c FROM table WHERE a <> '1'

The correct implicit conversion expected from the query result is: 
2,2L,"Hello"
3,2L,"Hello world"

But in fact the current query result is:
1,1L,"Hi"
2,2L,"Hello"
3,2L,"Hello world"



--
This message was sent by Atlassian Jira
(v8.3.4#803005)