[
https://issues.apache.org/jira/browse/FLINK-21425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suxing Lee closed FLINK-21425.
------------------------------
Resolution: Later
> 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)
