[jira] [Created] (CALCITE-4239) RelMdUniqueKeys returns wrong unique keys for Aggregate with grouping sets

["Chunwei Lei (Jira)" <ji...@apache.org>]

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)