iwanttobepowerful commented on PR #5404:
URL: https://github.com/apache/calcite/pull/5404#issuecomment-6829343118
add case:
```sql
# ROLLUP mixes a constant key and a non-constant key. The sub-query is
# uncorrelated, so the constant key must stay; dropping it made the
# grouping sets invalid. PostgreSQL ran it with ROLLUP('a'::text, job).
select deptno,
(select count(*) from (select job from emp
group by rollup('a', job)) t) as c,
exists (select 1 from emp where emp.deptno = dept.deptno) as ec
from dept;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
