postgres
diff --git a/‎src/test/regress/expected/select.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/select.out
+3-3Lines changed: 3 additions & 3 deletions b/‎src/test/regress/expected/select.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/select.out
+3-3Lines changed: 3 additions & 3 deletions
diff --git a/‎src/test/regress/expected/select_parallel.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/select_parallel.out
+7-8Lines changed: 7 additions & 8 deletions b/‎src/test/regress/expected/select_parallel.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/select_parallel.out
+7-8Lines changed: 7 additions & 8 deletions
diff --git a/‎src/test/regress/sql/select.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/select.sql
+3-3Lines changed: 3 additions & 3 deletions b/‎src/test/regress/sql/select.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/select.sql
+3-3Lines changed: 3 additions & 3 deletions
diff --git a/‎src/test/regress/sql/select_parallel.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/select_parallel.sql
+2-2Lines changed: 2 additions & 2 deletions b/‎src/test/regress/sql/select_parallel.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/select_parallel.sql
+2-2Lines changed: 2 additions & 2 deletions
@@ -438,19 +438,19 @@ SELECT p.name, p.age FROM person* p ORDER BY age using >, name;
 --
 -- Test some cases involving whole-row Var referencing a subquery
 --
-select foo from (select 1) as foo;
+select foo from (select 1 offset 0) as foo;
  foo 
 -----
  (1)
 (1 row)
 
-select foo from (select null) as foo;
+select foo from (select null offset 0) as foo;
  foo 
 -----
  ()
 (1 row)
 
-select foo from (select 'xyzzy',1,null) as foo;
+select foo from (select 'xyzzy',1,null offset 0) as foo;
     foo     
 ------------
  (xyzzy,1,)
 
@@ -1116,22 +1116,21 @@ EXECUTE pstmt('1', make_some_array(1,2));
 
 DEALLOCATE pstmt;
 -- test interaction between subquery and partial_paths
-SET LOCAL min_parallel_table_scan_size TO 0;
 CREATE VIEW tenk1_vw_sec WITH (security_barrier) AS SELECT * FROM tenk1;
 EXPLAIN (COSTS OFF)
-SELECT 1 FROM tenk1_vw_sec WHERE EXISTS (SELECT 1 WHERE unique1 = 0);
+SELECT 1 FROM tenk1_vw_sec
+  WHERE (SELECT sum(f1) FROM int4_tbl WHERE f1 < unique1) < 100;
                             QUERY PLAN                             
 -------------------------------------------------------------------
  Subquery Scan on tenk1_vw_sec
-   Filter: (alternatives: SubPlan 1 or hashed SubPlan 2)
+   Filter: ((SubPlan 1) < 100)
    ->  Gather
          Workers Planned: 4
          ->  Parallel Index Only Scan using tenk1_unique1 on tenk1
    SubPlan 1
-     ->  Result
-           One-Time Filter: (tenk1_vw_sec.unique1 = 0)
-   SubPlan 2
-     ->  Result
-(10 rows)
+     ->  Aggregate
+           ->  Seq Scan on int4_tbl
+                 Filter: (f1 < tenk1_vw_sec.unique1)
+(9 rows)
 
 rollback;
@@ -116,9 +116,9 @@ SELECT p.name, p.age FROM person* p ORDER BY age using >, name;
 --
 -- Test some cases involving whole-row Var referencing a subquery
 --
-select foo from (select 1) as foo;
-select foo from (select null) as foo;
-select foo from (select 'xyzzy',1,null) as foo;
+select foo from (select 1 offset 0) as foo;
+select foo from (select null offset 0) as foo;
+select foo from (select 'xyzzy',1,null offset 0) as foo;
 
 --
 -- Test VALUES lists
 
@@ -427,9 +427,9 @@ EXECUTE pstmt('1', make_some_array(1,2));
 DEALLOCATE pstmt;
 
 -- test interaction between subquery and partial_paths
-SET LOCAL min_parallel_table_scan_size TO 0;
 CREATE VIEW tenk1_vw_sec WITH (security_barrier) AS SELECT * FROM tenk1;
 EXPLAIN (COSTS OFF)
-SELECT 1 FROM tenk1_vw_sec WHERE EXISTS (SELECT 1 WHERE unique1 = 0);
+SELECT 1 FROM tenk1_vw_sec
+  WHERE (SELECT sum(f1) FROM int4_tbl WHERE f1 < unique1) < 100;
 
 rollback;