[CALCITE-4239] RelMdUniqueKeys returns wrong unique keys for Aggregate with grouping sets

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.26.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Chunwei Lei
• Reporter: Chunwei Lei
• Created: 09/Sep/20 08:00
• Updated: 06/Oct/20 17:16
• Resolved: 14/Sep/20 02:17

Description

For Aggregate with grouping sets, group by keys might not form a unique key. For example: 

//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)

 

Issue Links

• links to: GitHub Pull Request #2145