[IMPALA-2926] Incorrect results - a predicate causes the number of rows to increase

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.5.0
• Fix Version/s: Impala 2.5.0, Impala 2.3.4
• Component/s: Backend
• Labels: correctness query_generator
• Environment: DB: functional
• Target Version: Impala 2.5.0, Impala 2.3.4
• Assignee: Alexander Behm
• Reporter: Taras Bobrovytsky
• Created: 03/Feb/16 02:59
• Updated: 19/Apr/16 07:01
• Resolved: 05/Feb/16 19:50

Description

The following two queries return a different number of rows, which should not be the case:

SELECT
1 AS int_col
FROM (
SELECT
COALESCE(-783, -258, LEAD(893, 82) OVER (ORDER BY a1.string_col, a1.smallint_col DESC)) AS int_col,
COALESCE(-784, 17, LEAD(320, 11) OVER (ORDER BY a1.bigint_col ASC, a1.bool_col ASC)) AS int_col_1
FROM alltypes a1
) a2
WHERE
(-902.60962819) < (a2.int_col_1)

SELECT
COALESCE(-783, -258, LEAD(893, 82) OVER (ORDER BY a1.string_col, a1.smallint_col DESC)) AS int_col,
COALESCE(-784, 17, LEAD(320, 11) OVER (ORDER BY a1.bigint_col ASC, a1.bool_col ASC)) AS int_col_1
FROM alltypes a1