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

Commitd2ccc70

Browse files
committed
Original coding of 'returning' regression test inadvertently chose a
nonunique join value, leading to plan-choice-dependent results ... andit seems some platforms will choose a different plan. Tweak the testso that it has well-defined results. Per report from Olivier Prenant.
1 parent12cf0fd commitd2ccc70

File tree

2 files changed

+10
-10
lines changed

2 files changed

+10
-10
lines changed

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

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -152,11 +152,11 @@ SELECT * FROM foochild;
152152

153153
UPDATE foo SET f3 = f3*2
154154
FROM int8_tbl i
155-
WHERE foo.f1 = i.q1
155+
WHERE foo.f1 = i.q2
156156
RETURNING *;
157-
f1 | f2 | f3 | f4 |q1 | q2
158-
-----+-------+------+------+-----+-----
159-
123 | child | 1998 | 1098 |123 |456
157+
f1 | f2 | f3 | f4 | q1 | q2
158+
-----+-------+------+------+------------------+-----
159+
123 | child | 1998 | 1098 |4567890123456789 |123
160160
(1 row)
161161

162162
SELECT * FROM foo;
@@ -174,11 +174,11 @@ SELECT * FROM foochild;
174174

175175
DELETE FROM foo
176176
USING int8_tbl i
177-
WHERE foo.f1 = i.q1
177+
WHERE foo.f1 = i.q2
178178
RETURNING *;
179-
f1 | f2 | f3 | f4 |q1 | q2
180-
-----+-------+------+------+-----+-----
181-
123 | child | 1998 | 1098 |123 |456
179+
f1 | f2 | f3 | f4 | q1 | q2
180+
-----+-------+------+------+------------------+-----
181+
123 | child | 1998 | 1098 |4567890123456789 |123
182182
(1 row)
183183

184184
SELECT * FROM foo;

‎src/test/regress/sql/returning.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -70,15 +70,15 @@ SELECT * FROM foochild;
7070

7171
UPDATE fooSET f3= f3*2
7272
FROM int8_tbl i
73-
WHEREfoo.f1=i.q1
73+
WHEREfoo.f1=i.q2
7474
RETURNING*;
7575

7676
SELECT*FROM foo;
7777
SELECT*FROM foochild;
7878

7979
DELETEFROM foo
8080
USING int8_tbl i
81-
WHEREfoo.f1=i.q1
81+
WHEREfoo.f1=i.q2
8282
RETURNING*;
8383

8484
SELECT*FROM foo;

0 commit comments

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