[jira] [Created] (IMPALA-15124) Decorrelated query producing incorrect results with NOT IN clause and left join

["Steve Carlin (Jira)" <ji...@apache.org>]

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)