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: [email protected]
For additional commands, e-mail: [email protected]
