[IMPALA-1810] Incorrect number of rows returned when this type of predicate is present: int IN (decimal, int)

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.2
• Fix Version/s: Impala 2.2
• Labels: correctness
• Assignee: Skye Wanderman-Milne
• Reporter: Taras Bobrovytsky
• Created: 24/Feb/15 21:01
• Updated: 18/Mar/15 19:48
• Resolved: 18/Mar/15 19:48

Description

Query:

SELECT
t1.month
FROM alltypestiny t1
WHERE
(t1.tinyint_col) IN (154.58, t1.id)

DB: Functional
Expected Number of rows returned: 2
Actual Number of rows returned: 0

There are many queries that are affected by this bug. Another query:

SELECT
t1.tinyint_col
FROM alltypestiny t1
WHERE
(t1.month) NOT IN (355.8, t1.tinyint_col)

Expected Number of rows returned: 7
Actual Number of rows returned: 8