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)