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)