diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2018-10-14 14:02:59 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2018-10-14 14:02:59 -0400 |
| commit | b403ea43e40aae3ebb03cf3844cf84b43ab34b8a (patch) | |
| tree | 6167c5f176e8d81fd373ee97d2936f5de1dfeed9 /src/test/regress/sql/select_parallel.sql | |
| parent | 7d4a10e260083bc571ea05592884084eabcc7afa (diff) | |
| download | postgresql-b403ea43e40aae3ebb03cf3844cf84b43ab34b8a.tar.gz postgresql-b403ea43e40aae3ebb03cf3844cf84b43ab34b8a.zip | |
Make some subquery-using test cases a bit more robust.
These test cases could be adversely affected by an upcoming change
to allow pullup of FROM-less subqueries. Tweak them to ensure that
they'll continue to test what they did before.
Discussion: https://postgr.es/m/5395.1539275668@sss.pgh.pa.us
Diffstat (limited to 'src/test/regress/sql/select_parallel.sql')
| -rw-r--r-- | src/test/regress/sql/select_parallel.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/sql/select_parallel.sql b/src/test/regress/sql/select_parallel.sql index e0f99accb4d..03c056b8b77 100644 --- a/src/test/regress/sql/select_parallel.sql +++ b/src/test/regress/sql/select_parallel.sql @@ -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; |