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)
