diff options
| author | Jeff Davis <jdavis@postgresql.org> | 2020-12-27 12:09:00 -0800 |
|---|---|---|
| committer | Jeff Davis <jdavis@postgresql.org> | 2020-12-27 12:11:58 -0800 |
| commit | cd7d8cde75063a85ee8c5fd27713061e56a8684d (patch) | |
| tree | 5d8240622ee5078b9bc74b056b46ccf1edb9ec4e | |
| parent | 6669cc769c44b691510c14be12acd9148c74d4d1 (diff) | |
| download | postgresql-cd7d8cde75063a85ee8c5fd27713061e56a8684d.tar.gz postgresql-cd7d8cde75063a85ee8c5fd27713061e56a8684d.zip | |
Second attempt to stabilize 05c02589.
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.
| -rw-r--r-- | src/test/regress/expected/groupingsets.out | 19 | ||||
| -rw-r--r-- | src/test/regress/sql/groupingsets.sql | 5 |
2 files changed, 0 insertions, 24 deletions
diff --git a/src/test/regress/expected/groupingsets.out b/src/test/regress/expected/groupingsets.out index 9e25f103458..7c844c6e09e 100644 --- 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 index 6bd2bb10e36..18ae803e9de 100644 --- 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 |