Second attempt to stabilize 05c02589.

jeff-davis · jeff-davis · commit cd7d8cde7506 · 2020-12-27T12:11:58.000-08:00
Removing the EXPLAIN test to stabilize the buildfarm. The execution
test should still be effective to catch the bug even if the plan is
slightly different on different platforms.
diff --git a/src/test/regress/expected/groupingsets.out b/src/test/regress/expected/groupingsets.out
@@ -1673,25 +1673,6 @@ update pg_class set reltuples = 10 where relname='bug_16784';
 insert into bug_16784 select g/10, g from generate_series(1,40) g;
 set work_mem='64kB';
 set enable_sort = false;
-explain (costs off) select * from
-  (values (1),(2)) v(a),
-  lateral (select v.a, i, j, count(*) from
-             bug_16784 group by cube(i,j)) s
-  order by v.a, i, j;
-                        QUERY PLAN                        
-----------------------------------------------------------
- Sort
-   Sort Key: "*VALUES*".column1, bug_16784.i, bug_16784.j
-   ->  Nested Loop
-         ->  Values Scan on "*VALUES*"
-         ->  MixedAggregate
-               Hash Key: bug_16784.i, bug_16784.j
-               Hash Key: bug_16784.i
-               Hash Key: bug_16784.j
-               Group Key: ()
-               ->  Seq Scan on bug_16784
-(10 rows)
-
 select * from
   (values (1),(2)) v(a),
   lateral (select a, i, j, count(*) from
diff --git a/src/test/regress/sql/groupingsets.sql b/src/test/regress/sql/groupingsets.sql
@@ -468,11 +468,6 @@ insert into bug_16784 select g/10, g from generate_series(1,40) g;
 set work_mem='64kB';
 set enable_sort = false;
 
-explain (costs off) select * from
-  (values (1),(2)) v(a),
-  lateral (select v.a, i, j, count(*) from
-             bug_16784 group by cube(i,j)) s
-  order by v.a, i, j;
 select * from
   (values (1),(2)) v(a),
   lateral (select a, i, j, count(*) from
