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

Commitfa39617

Browse files
committed
Fix unstable regression test added by commits59b71c6 et al.
The query didn't really have a preferred index, leading to platform-specific choices of which one to use. Adjust it to make sure tenk1_hundredis always chosen.Per buildfarm.
1 parent1695ce0 commitfa39617

File tree

2 files changed

+6
-6
lines changed

2 files changed

+6
-6
lines changed

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

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1994,7 +1994,7 @@ CREATE AGGREGATE balk(
19941994
STYPE = int8,
19951995
"PARALLEL" = SAFE,
19961996
INITCOND = '0');
1997-
SELECT balk(1) FROM tenk1;
1997+
SELECT balk(hundred) FROM tenk1;
19981998
balk
19991999
------
20002000

@@ -2030,7 +2030,7 @@ SET LOCAL parallel_setup_cost=0;
20302030
SET LOCAL max_parallel_workers_per_gather=4;
20312031
SET LOCAL enable_indexscan = off;
20322032
SET LOCAL enable_bitmapscan = off;
2033-
EXPLAIN (COSTS OFF) SELECT balk(1) FROM tenk1;
2033+
EXPLAIN (COSTS OFF) SELECT balk(hundred) FROM tenk1;
20342034
QUERY PLAN
20352035
----------------------------------------------
20362036
Finalize Aggregate
@@ -2040,7 +2040,7 @@ EXPLAIN (COSTS OFF) SELECT balk(1) FROM tenk1;
20402040
-> Parallel Seq Scan on tenk1
20412041
(5 rows)
20422042

2043-
SELECT balk(1) FROM tenk1;
2043+
SELECT balk(hundred) FROM tenk1;
20442044
balk
20452045
------
20462046

‎src/test/regress/sql/aggregates.sql

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -860,7 +860,7 @@ CREATE AGGREGATE balk(
860860
"PARALLEL"= SAFE,
861861
INITCOND='0');
862862

863-
SELECT balk(1)FROM tenk1;
863+
SELECT balk(hundred)FROM tenk1;
864864

865865
ROLLBACK;
866866

@@ -896,7 +896,7 @@ SET LOCAL max_parallel_workers_per_gather=4;
896896
SET LOCAL enable_indexscan= off;
897897
SET LOCAL enable_bitmapscan= off;
898898

899-
EXPLAIN (COSTS OFF)SELECT balk(1)FROM tenk1;
900-
SELECT balk(1)FROM tenk1;
899+
EXPLAIN (COSTS OFF)SELECT balk(hundred)FROM tenk1;
900+
SELECT balk(hundred)FROM tenk1;
901901

902902
ROLLBACK;

0 commit comments

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