diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/groupingsets.out | 16 | ||||
| -rw-r--r-- | src/test/regress/sql/groupingsets.sql | 16 |
2 files changed, 18 insertions, 14 deletions
diff --git a/src/test/regress/expected/groupingsets.out b/src/test/regress/expected/groupingsets.out index c00b2dd6488..9e25f103458 100644 --- a/src/test/regress/expected/groupingsets.out +++ b/src/test/regress/expected/groupingsets.out @@ -1666,12 +1666,13 @@ select v||'a', case when grouping(v||'a') = 1 then 1 else 0 end, count(*) (4 rows) -- Bug #16784 -CREATE TABLE bug_16784(i INT, j INT); -ANALYZE bug_16784; -ALTER TABLE bug_16784 SET (autovacuum_enabled = 'false'); -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'; +create table bug_16784(i int, j int); +analyze bug_16784; +alter table bug_16784 set (autovacuum_enabled = 'false'); +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 @@ -1883,8 +1884,9 @@ select g%1000 as g1000, g%100 as g100, g%10 as g10, g analyze gs_data_1; alter table gs_data_1 set (autovacuum_enabled = 'false'); update pg_class set reltuples = 10 where relname='gs_data_1'; -SET work_mem='64kB'; +set work_mem='64kB'; -- Produce results with sorting. +set enable_sort = true; set enable_hashagg = false; set jit_above_cost = 0; explain (costs off) diff --git a/src/test/regress/sql/groupingsets.sql b/src/test/regress/sql/groupingsets.sql index 93b33c65d17..6bd2bb10e36 100644 --- a/src/test/regress/sql/groupingsets.sql +++ b/src/test/regress/sql/groupingsets.sql @@ -458,14 +458,15 @@ select v||'a', case when grouping(v||'a') = 1 then 1 else 0 end, count(*) group by rollup(i, v||'a') order by 1,3; -- Bug #16784 -CREATE TABLE bug_16784(i INT, j INT); -ANALYZE bug_16784; -ALTER TABLE bug_16784 SET (autovacuum_enabled = 'false'); -UPDATE pg_class SET reltuples = 10 WHERE relname='bug_16784'; +create table bug_16784(i int, j int); +analyze bug_16784; +alter table bug_16784 set (autovacuum_enabled = 'false'); +update pg_class set reltuples = 10 where relname='bug_16784'; -INSERT INTO bug_16784 SELECT g/10, g FROM generate_series(1,40) g; +insert into bug_16784 select g/10, g from generate_series(1,40) g; -SET work_mem='64kB'; +set work_mem='64kB'; +set enable_sort = false; explain (costs off) select * from (values (1),(2)) v(a), @@ -492,10 +493,11 @@ analyze gs_data_1; alter table gs_data_1 set (autovacuum_enabled = 'false'); update pg_class set reltuples = 10 where relname='gs_data_1'; -SET work_mem='64kB'; +set work_mem='64kB'; -- Produce results with sorting. +set enable_sort = true; set enable_hashagg = false; set jit_above_cost = 0; |