Steve Carlin created IMPALA-15124:
-------------------------------------
Summary: Decorrelated query producing incorrect results with NOT
IN clause and left join
Key: IMPALA-15124
URL: https://issues.apache.org/jira/browse/IMPALA-15124
Project: IMPALA
Issue Type: Bug
Reporter: Steve Carlin
The following query is producing incorrect results (the Calcite planner is
producing correct results):
select count(*)
FROM alltypesagg t1
WHERE day IS NOT NULL
AND t1.int_col NOT IN
(SELECT tt1.month AS tinyint_col_1
FROM alltypesagg tt1
LEFT JOIN alltypestiny tt2 ON tt2.year = tt1.id
AND t1.bigint_col = tt2.smallint_col)
The alltypesagg table
on the left side of the left join should produce all rows from
the table even with the decorrelated column. So any row where
alltypesagg.int_col is the same as alltypesagg.month should not
be included in the count.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
