[PGRPO-5375] Add GROUPING SETS test into unsupported.sql

Damir Belyalov · Andrey Lepikhov · commit f6d9b06d9329 · 2021-08-03T12:14:24.000+05:00
diff --git a/expected/unsupported.out b/expected/unsupported.out
@@ -126,6 +126,34 @@ WHERE q2.x > 1;
  JOINS: 0
 (13 rows)
 
+--
+-- Doesn't support GROUPING SETS clause
+--
+SELECT count(*) FROM (SELECT x, y FROM t1 GROUP BY GROUPING SETS ((x,y), (x), (y), ())) AS q1;
+ count 
+-------
+    31
+(1 row)
+
+EXPLAIN (COSTS OFF)
+	SELECT count(*) FROM (SELECT x, y FROM t1 GROUP BY GROUPING SETS ((x,y), (x), (y), ())) AS q1;
+          QUERY PLAN          
+------------------------------
+ Aggregate
+   AQO not used
+   ->  MixedAggregate
+         AQO not used
+         Hash Key: t1.x, t1.y
+         Hash Key: t1.x
+         Hash Key: t1.y
+         Group Key: ()
+         ->  Seq Scan on t1
+               AQO: rows=1000
+ Using aqo: true
+ AQO mode: LEARN
+ JOINS: 0
+(13 rows)
+
 --
 -- The subplans issue
 --
diff --git a/sql/unsupported.sql b/sql/unsupported.sql
@@ -50,6 +50,13 @@ SELECT count(*) FROM (
 ) AS q2
 WHERE q2.x > 1;
 
+--
+-- Doesn't support GROUPING SETS clause
+--
+SELECT count(*) FROM (SELECT x, y FROM t1 GROUP BY GROUPING SETS ((x,y), (x), (y), ())) AS q1;
+EXPLAIN (COSTS OFF)
+	SELECT count(*) FROM (SELECT x, y FROM t1 GROUP BY GROUPING SETS ((x,y), (x), (y), ())) AS q1;
+
 --
 -- The subplans issue
 --
