[IMPALA-1547] Row Count Mismatch: Subquery

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.1
• Fix Version/s: Product Backlog
• Labels: query_generator
• Assignee: Dimitris Tsirogiannis
• Reporter: Taras Bobrovytsky
• Created: 26/Nov/14 00:19
• Updated: 02/Apr/15 23:37
• Resolved: 02/Apr/15 23:37

Description

Impala Query:

SELECT DISTINCT
(t1.int_col) - (t1.tinyint_col) AS int_col,
t1.bigint_col
FROM alltypestiny t1
WHERE
EXISTS (SELECT
ABS(MIN(bigint_col)) AS int_col
FROM alltypestiny
WHERE
(t1.int_col) = (year))

Postgres Query:

SELECT DISTINCT
(t1.int_col) - (t1.tinyint_col) AS int_col,
t1.bigint_col
FROM alltypestiny t1
WHERE
EXISTS (SELECT
ABS(MIN(bigint_col)) AS int_col
FROM alltypestiny
WHERE
(t1.int_col) = (year))

Number of rows returned by Impala: 0
Number of rows returned by Postgres: 2
DB: Functional
File Format: Text/None
git Hash: c295948