[ https://issues.apache.org/jira/browse/FLINK-21425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated FLINK-21425: ----------------------------------- Labels: pull-request-available (was: ) > 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 > Priority: Major > Labels: pull-request-available > > 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)