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

Commit4b14e18

Browse files
committed
Attempt to stabilize postgres_fdw tests
cac169d adjusted DEFAULT_FDW_TUPLE_COST and that seems to have causeda test to become unstable on 32-bit machines. Try to make it stableagain.Reported-by: Michael PaquierDiscussion:https://postgr.es/m/ZUM2IhA8X2lrG50K@paquier.xyz
1 parenta02b37f commit4b14e18

File tree

2 files changed

+4
-0
lines changed

2 files changed

+4
-0
lines changed

‎contrib/postgres_fdw/expected/postgres_fdw.out

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -4018,6 +4018,7 @@ EXECUTE st1(101, 101);
40184018
00101 | 00101
40194019
(1 row)
40204020

4021+
SET enable_hashjoin TO off;
40214022
-- subquery using stable function (can't be sent to remote)
40224023
PREPARE st2(int) AS SELECT * FROM ft1 t1 WHERE t1.c1 < $2 AND t1.c3 IN (SELECT c3 FROM ft2 t2 WHERE c1 > $1 AND date(c4) = '1970-01-17'::date) ORDER BY c1;
40234024
EXPLAIN (VERBOSE, COSTS OFF) EXECUTE st2(10, 20);
@@ -4052,6 +4053,7 @@ EXECUTE st2(101, 121);
40524053
116 | 6 | 00116 | Sat Jan 17 00:00:00 1970 PST | Sat Jan 17 00:00:00 1970 | 6 | 6 | foo
40534054
(1 row)
40544055

4056+
RESET enable_hashjoin;
40554057
-- subquery using immutable function (can be sent to remote)
40564058
PREPARE st3(int) AS SELECT * FROM ft1 t1 WHERE t1.c1 < $2 AND t1.c3 IN (SELECT c3 FROM ft2 t2 WHERE c1 > $1 AND date(c5) = '1970-01-17'::date) ORDER BY c1;
40574059
EXPLAIN (VERBOSE, COSTS OFF) EXECUTE st3(10, 20);

‎contrib/postgres_fdw/sql/postgres_fdw.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1122,11 +1122,13 @@ PREPARE st1(int, int) AS SELECT t1.c3, t2.c3 FROM ft1 t1, ft2 t2 WHERE t1.c1 = $
11221122
EXPLAIN (VERBOSE, COSTS OFF) EXECUTE st1(1,2);
11231123
EXECUTE st1(1,1);
11241124
EXECUTE st1(101,101);
1125+
SET enable_hashjoin TO off;
11251126
-- subquery using stable function (can't be sent to remote)
11261127
PREPARE st2(int)ASSELECT*FROM ft1 t1WHEREt1.c1< $2ANDt1.c3IN (SELECT c3FROM ft2 t2WHERE c1> $1ANDdate(c4)='1970-01-17'::date)ORDER BY c1;
11271128
EXPLAIN (VERBOSE, COSTS OFF) EXECUTE st2(10,20);
11281129
EXECUTE st2(10,20);
11291130
EXECUTE st2(101,121);
1131+
RESET enable_hashjoin;
11301132
-- subquery using immutable function (can be sent to remote)
11311133
PREPARE st3(int)ASSELECT*FROM ft1 t1WHEREt1.c1< $2ANDt1.c3IN (SELECT c3FROM ft2 t2WHERE c1> $1ANDdate(c5)='1970-01-17'::date)ORDER BY c1;
11321134
EXPLAIN (VERBOSE, COSTS OFF) EXECUTE st3(10,20);

0 commit comments

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