diff options
| -rw-r--r-- | src/test/regress/expected/select_parallel.out | 10 | ||||
| -rw-r--r-- | src/test/regress/sql/select_parallel.sql | 3 |
2 files changed, 13 insertions, 0 deletions
diff --git a/src/test/regress/expected/select_parallel.out b/src/test/regress/expected/select_parallel.out index 2463f1ff98e..d65c2b93a8c 100644 --- a/src/test/regress/expected/select_parallel.out +++ b/src/test/regress/expected/select_parallel.out @@ -280,6 +280,16 @@ explain (costs off) Index Cond: (unique1 = 1) (5 rows) +-- to increase the parallel query test coverage +EXPLAIN (analyze, timing off, summary off, costs off) SELECT * FROM tenk1; + QUERY PLAN +------------------------------------------------------------- + Gather (actual rows=10000 loops=1) + Workers Planned: 4 + Workers Launched: 4 + -> Parallel Seq Scan on tenk1 (actual rows=2000 loops=5) +(4 rows) + -- provoke error in worker select stringu1::int2 from tenk1 where unique1 = 1; ERROR: invalid input syntax for integer: "BAAAAA" diff --git a/src/test/regress/sql/select_parallel.sql b/src/test/regress/sql/select_parallel.sql index 53f4271c182..b2a0bd5d94a 100644 --- a/src/test/regress/sql/select_parallel.sql +++ b/src/test/regress/sql/select_parallel.sql @@ -116,6 +116,9 @@ set force_parallel_mode=1; explain (costs off) select stringu1::int2 from tenk1 where unique1 = 1; +-- to increase the parallel query test coverage +EXPLAIN (analyze, timing off, summary off, costs off) SELECT * FROM tenk1; + -- provoke error in worker select stringu1::int2 from tenk1 where unique1 = 1; |