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

Commit3ba2cda

Browse files
tglsfdcAlena Rybakina
and
Alena Rybakina
committed
Stabilize regression test fromc0962a1.
Per buildfarm.Co-authored-by: Alena Rybakina <a.rybakina@postgrespro.ru>Co-authored-by: Tom Lane <tgl@sss.pgh.pa.us>Discussion:https://postgr.es/m/srnuqlttuimzmvoulhsrbgvj4vnul6b65osswvua7sfkqsvmuy@yg7apybpxp34
1 parent64e7fa4 commit3ba2cda

File tree

2 files changed

+23
-22
lines changed

2 files changed

+23
-22
lines changed

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

Lines changed: 19 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -2755,28 +2755,29 @@ SELECT * from onek WHERE unique1 in (VALUES(1200::bigint), (1));
27552755

27562756
-- VtA shouldn't depend on the side of the join probing with the VALUES expression.
27572757
EXPLAIN (COSTS OFF)
2758-
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
2759-
WHERE a.oid IN (VALUES (1), (2));
2760-
QUERY PLAN
2761-
---------------------------------------------------------
2762-
Nested Loop
2763-
-> Seq Scan on pg_am a
2764-
Filter: (oid = ANY ('{1,2}'::oid[]))
2765-
-> Index Scan using pg_class_oid_index on pg_class c
2766-
Index Cond: (oid = a.oid)
2767-
(5 rows)
2758+
SELECT c.unique1,c.ten FROM tenk1 c JOIN onek a USING (ten)
2759+
WHERE a.ten IN (VALUES (1), (2));
2760+
QUERY PLAN
2761+
--------------------------------------------------
2762+
Hash Join
2763+
Hash Cond: (a.ten = c.ten)
2764+
-> Seq Scan on onek a
2765+
Filter: (ten = ANY ('{1,2}'::integer[]))
2766+
-> Hash
2767+
-> Seq Scan on tenk1 c
2768+
(6 rows)
27682769

27692770
EXPLAIN (COSTS OFF)
2770-
SELECT c.oid,c.relname FROMpg_class c JOINpg_am a USING (oid)
2771-
WHERE c.oid IN (VALUES (1), (2));
2772-
QUERY PLAN
2773-
---------------------------------------------------------------
2771+
SELECT c.unique1,c.ten FROMtenk1 c JOINonek a USING (ten)
2772+
WHERE c.ten IN (VALUES (1), (2));
2773+
QUERY PLAN
2774+
--------------------------------------------------
27742775
Hash Join
2775-
Hash Cond: (a.oid = c.oid)
2776-
-> Seq Scan on pg_am a
2776+
Hash Cond: (c.ten = a.ten)
2777+
-> Seq Scan on tenk1 c
2778+
Filter: (ten = ANY ('{1,2}'::integer[]))
27772779
-> Hash
2778-
-> Index Scan using pg_class_oid_index on pg_class c
2779-
Index Cond: (oid = ANY ('{1,2}'::oid[]))
2780+
-> Seq Scan on onek a
27802781
(6 rows)
27812782

27822783
-- Constant expressions are simplified

‎src/test/regress/sql/subselect.sql‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1243,11 +1243,11 @@ SELECT * from onek WHERE unique1 in (VALUES(1200::bigint), (1));
12431243

12441244
-- VtA shouldn't depend on the side of the join probing with the VALUES expression.
12451245
EXPLAIN (COSTS OFF)
1246-
SELECTc.oid,c.relnameFROMpg_class cJOINpg_am a USING (oid)
1247-
WHEREa.oidIN (VALUES (1), (2));
1246+
SELECTc.unique1,c.tenFROMtenk1 cJOINonek a USING (ten)
1247+
WHEREa.tenIN (VALUES (1), (2));
12481248
EXPLAIN (COSTS OFF)
1249-
SELECTc.oid,c.relnameFROMpg_class cJOINpg_am a USING (oid)
1250-
WHEREc.oidIN (VALUES (1), (2));
1249+
SELECTc.unique1,c.tenFROMtenk1 cJOINonek a USING (ten)
1250+
WHEREc.tenIN (VALUES (1), (2));
12511251

12521252
-- Constant expressions are simplified
12531253
EXPLAIN (COSTS OFF)

0 commit comments

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