[jira] [Created] (IMPALA-15122) Incorrect results when correlated query contains a rollup with an empty group set

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

Steve Carlin created IMPALA-15122:
-------------------------------------

             Summary: Incorrect results when correlated query contains a rollup with an empty group set
                 Key: IMPALA-15122
                 URL: https://issues.apache.org/jira/browse/IMPALA-15122
             Project: IMPALA
          Issue Type: Bug
            Reporter: Steve Carlin


The following query exists in grouping-sets.test:

select id
from functional.alltypesagg a
where exists
  (select id
   from functional.alltypestiny b
   where a.tinyint_col = b.tinyint_col and a.string_col = b.string_col
   group by rollup(id, int_col, bool_col))
  and tinyint_col < 10
order by id
limit 15;

The rollup contains an empty group which always has a row.
The inner query should return NULL (1 result), not 0 results, and the exists clause
should always be true.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org