Chunwei Lei created CALCITE-4239:
------------------------------------
Summary: RelMdUniqueKeys returns wrong unique keys for Aggregate
with grouping sets
Key: CALCITE-4239
URL: https://issues.apache.org/jira/browse/CALCITE-4239
Project: Calcite
Issue Type: Improvement
Components: core
Reporter: Chunwei Lei
For Aggregate with grouping sets, group by keys might not form a unique key.
For example:
{code:java}
//PostgreSQL
create table test2(key bigint, value bigint);
insert into test2 values
(1, null),
(null, 1);
select key, value, count(*) from test2
group by GROUPING SETS (key,value)
;
postgres=# select key, value, count(*) from test2
postgres-# group by GROUPING SETS (key,value)
postgres-# ;
key | value | count
-----+-------+-------
| | 1
1 | | 1
| | 1
| 1 | 1
(4 rows)
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
