Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitfa0fdf0

Browse files
committed
Stabilize test introduced in05c0258, per buildfarm.
In passing, make the capitalization match the rest of the file.Reported-by: Tom Lane
1 parent05c0258 commitfa0fdf0

File tree

2 files changed

+18
-14
lines changed

2 files changed

+18
-14
lines changed

‎src/test/regress/expected/groupingsets.out

Lines changed: 9 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1666,12 +1666,13 @@ select v||'a', case when grouping(v||'a') = 1 then 1 else 0 end, count(*)
16661666
(4 rows)
16671667

16681668
-- Bug #16784
1669-
CREATE TABLE bug_16784(i INT, j INT);
1670-
ANALYZE bug_16784;
1671-
ALTER TABLE bug_16784 SET (autovacuum_enabled = 'false');
1672-
UPDATE pg_class SET reltuples = 10 WHERE relname='bug_16784';
1673-
INSERT INTO bug_16784 SELECT g/10, g FROM generate_series(1,40) g;
1674-
SET work_mem='64kB';
1669+
create table bug_16784(i int, j int);
1670+
analyze bug_16784;
1671+
alter table bug_16784 set (autovacuum_enabled = 'false');
1672+
update pg_class set reltuples = 10 where relname='bug_16784';
1673+
insert into bug_16784 select g/10, g from generate_series(1,40) g;
1674+
set work_mem='64kB';
1675+
set enable_sort = false;
16751676
explain (costs off) select * from
16761677
(values (1),(2)) v(a),
16771678
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
18831884
analyze gs_data_1;
18841885
alter table gs_data_1 set (autovacuum_enabled = 'false');
18851886
update pg_class set reltuples = 10 where relname='gs_data_1';
1886-
SET work_mem='64kB';
1887+
set work_mem='64kB';
18871888
-- Produce results with sorting.
1889+
set enable_sort = true;
18881890
set enable_hashagg = false;
18891891
set jit_above_cost = 0;
18901892
explain (costs off)

‎src/test/regress/sql/groupingsets.sql

Lines changed: 9 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -458,14 +458,15 @@ select v||'a', case when grouping(v||'a') = 1 then 1 else 0 end, count(*)
458458
group by rollup(i, v||'a')order by1,3;
459459

460460
-- Bug #16784
461-
CREATETABLEbug_16784(iINT, jINT);
462-
ANALYZE bug_16784;
463-
ALTERTABLE bug_16784SET (autovacuum_enabled='false');
464-
UPDATE pg_classSET reltuples=10WHERE relname='bug_16784';
461+
createtablebug_16784(iint, jint);
462+
analyze bug_16784;
463+
altertable bug_16784set (autovacuum_enabled='false');
464+
update pg_classset reltuples=10where relname='bug_16784';
465465

466-
INSERT INTO bug_16784SELECT g/10, gFROM generate_series(1,40) g;
466+
insert into bug_16784select g/10, gfrom generate_series(1,40) g;
467467

468-
SET work_mem='64kB';
468+
set work_mem='64kB';
469+
set enable_sort= false;
469470

470471
explain (costs off)select*from
471472
(values (1),(2)) v(a),
@@ -492,10 +493,11 @@ analyze gs_data_1;
492493
altertable gs_data_1set (autovacuum_enabled='false');
493494
update pg_classset reltuples=10where relname='gs_data_1';
494495

495-
SET work_mem='64kB';
496+
set work_mem='64kB';
496497

497498
-- Produce results with sorting.
498499

500+
set enable_sort= true;
499501
set enable_hashagg= false;
500502
set jit_above_cost=0;
501503

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp