diff options
Diffstat (limited to 'src/test/regress/sql/select_parallel.sql')
| -rw-r--r-- | src/test/regress/sql/select_parallel.sql | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/src/test/regress/sql/select_parallel.sql b/src/test/regress/sql/select_parallel.sql index 9b019d31ed7..c7df8f775ce 100644 --- a/src/test/regress/sql/select_parallel.sql +++ b/src/test/regress/sql/select_parallel.sql @@ -269,11 +269,16 @@ reset enable_nestloop; -- test parallel nestloop join path with materialization of the inner path alter table tenk2 set (parallel_workers = 0); explain (costs off) - select * from tenk1 t1, tenk2 t2 where t1.two > t2.two; +select * from tenk1 t1, tenk2 t2 where t1.two > t2.two; --- the joinrel is not parallel-safe due to the OFFSET clause in the subquery +-- test that parallel nestloop join is not generated if the inner path is +-- not parallel-safe explain (costs off) - select * from tenk1 t1, (select * from tenk2 t2 offset 0) t2 where t1.two > t2.two; +select * from tenk1 t1 + left join lateral + (select t1.unique1 as x, * from tenk2 t2 order by 1) t2 + on true +where t1.two > t2.two; alter table tenk2 reset (parallel_workers); -- test gather merge |