Steve Carlin created HIVE-24817:
-----------------------------------
Summary: "not in" clause returns incorrect data when there is
coercion
Key: HIVE-24817
URL: https://issues.apache.org/jira/browse/HIVE-24817
Project: Hive
Issue Type: Bug
Components: CBO
Reporter: Steve Carlin
When the query has a where clause that has an integer column checking against
being "not in" a decimal column, the decimal column is being changed to null,
causing incorrect results.
This is a sample query of a failure:
select count(*) from my_tbl where int_col not in (355.8);
Since the int_col can never be 355.8, one would expect all the rows to be
returned, but it is changing the 355.8 into a null value causing no rows to be
returned.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
