postgres.git / summary / log / commit / refs

commit    3ba2cdaa45416196fadc7163998cda7b4e07e7d7
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Fri Apr 04 15:57:26 2025 +0000

    Stabilize regression test from c0962a113.
    
    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


 src/test/regress/expected/subselect.out | 37 +++++++++++++++++----------------
 src/test/regress/sql/subselect.sql      |  8 +++----
 2 files changed, 23 insertions(+), 22 deletions(-)

diff --git a/src/test/regress/expected/subselect.out b/src/test/regress/expected/subselect.out
index 288d139cfdd..40d8056fcea 100644
--- a/src/test/regress/expected/subselect.out
+++ b/src/test/regress/expected/subselect.out
@@ -2755,28 +2755,29 @@ SELECT * from onek WHERE unique1 in (VALUES(1200::bigint), (1));
 
 -- VtA shouldn't depend on the side of the join probing with the VALUES expression.
 EXPLAIN (COSTS OFF)
-SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
-WHERE a.oid IN (VALUES (1), (2));
-                       QUERY PLAN                        
----------------------------------------------------------
- Nested Loop
-   ->  Seq Scan on pg_am a
-         Filter: (oid = ANY ('{1,2}'::oid[]))
-   ->  Index Scan using pg_class_oid_index on pg_class c
-         Index Cond: (oid = a.oid)
-(5 rows)
+SELECT c.unique1,c.ten FROM tenk1 c JOIN onek a USING (ten)
+WHERE a.ten IN (VALUES (1), (2));
+                    QUERY PLAN                    
+--------------------------------------------------
+ Hash Join
+   Hash Cond: (a.ten = c.ten)
+   ->  Seq Scan on onek a
+         Filter: (ten = ANY ('{1,2}'::integer[]))
+   ->  Hash
+         ->  Seq Scan on tenk1 c
+(6 rows)
 
 EXPLAIN (COSTS OFF)
-SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
-WHERE c.oid IN (VALUES (1), (2));
-                          QUERY PLAN                           
----------------------------------------------------------------
+SELECT c.unique1,c.ten FROM tenk1 c JOIN onek a USING (ten)
+WHERE c.ten IN (VALUES (1), (2));
+                    QUERY PLAN                    
+--------------------------------------------------
  Hash Join
-   Hash Cond: (a.oid = c.oid)
-   ->  Seq Scan on pg_am a
+   Hash Cond: (c.ten = a.ten)
+   ->  Seq Scan on tenk1 c
+         Filter: (ten = ANY ('{1,2}'::integer[]))
    ->  Hash
-         ->  Index Scan using pg_class_oid_index on pg_class c
-               Index Cond: (oid = ANY ('{1,2}'::oid[]))
+         ->  Seq Scan on onek a
 (6 rows)
 
 -- Constant expressions are simplified
diff --git a/src/test/regress/sql/subselect.sql b/src/test/regress/sql/subselect.sql
index 101167de810..fec38ef85a6 100644
--- a/src/test/regress/sql/subselect.sql
+++ b/src/test/regress/sql/subselect.sql
@@ -1243,11 +1243,11 @@ SELECT * from onek WHERE unique1 in (VALUES(1200::bigint), (1));
 
 -- VtA shouldn't depend on the side of the join probing with the VALUES expression.
 EXPLAIN (COSTS OFF)
-SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
-WHERE a.oid IN (VALUES (1), (2));
+SELECT c.unique1,c.ten FROM tenk1 c JOIN onek a USING (ten)
+WHERE a.ten IN (VALUES (1), (2));
 EXPLAIN (COSTS OFF)
-SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
-WHERE c.oid IN (VALUES (1), (2));
+SELECT c.unique1,c.ten FROM tenk1 c JOIN onek a USING (ten)
+WHERE c.ten IN (VALUES (1), (2));
 
 -- Constant expressions are simplified
 EXPLAIN (COSTS OFF)


[parent: 64e7fa43a948]