Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitf9472d7

Browse files
committed
Run select_parallel test by itself
Remove the plpgsql wrapping that hides the context. So now the testwill fail if the work doesn't actually happen in a parallel worker. Runthe test in its own test group to ensure it won't run out of resourcesfor that.
1 parent234309f commitf9472d7

File tree

3 files changed

+10
-19
lines changed

3 files changed

+10
-19
lines changed

‎src/test/regress/expected/select_parallel.out

Lines changed: 4 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -111,14 +111,8 @@ explain (costs off)
111111
Index Cond: (unique1 = 1)
112112
(5 rows)
113113

114-
do $$begin
115-
-- Provoke error, possibly in worker. If this error happens to occur in
116-
-- the worker, there will be a CONTEXT line which must be hidden.
117-
perform stringu1::int2 from tenk1 where unique1 = 1;
118-
exception
119-
when others then
120-
raise 'SQLERRM: %', sqlerrm;
121-
end$$;
122-
ERROR: SQLERRM: invalid input syntax for integer: "BAAAAA"
123-
CONTEXT: PL/pgSQL function inline_code_block line 7 at RAISE
114+
-- provoke error in worker
115+
select stringu1::int2 from tenk1 where unique1 = 1;
116+
ERROR: invalid input syntax for integer: "BAAAAA"
117+
CONTEXT: parallel worker
124118
rollback;

‎src/test/regress/parallel_schedule

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -92,7 +92,10 @@ test: brin gin gist spgist privileges init_privs security_label collate matview
9292
test: alter_generic alter_operator misc psql async dbsize misc_functions
9393

9494
# rules cannot run concurrently with any test that creates a view
95-
test: rules psql_crosstab select_parallel amutils
95+
test: rules psql_crosstab amutils
96+
97+
# run by itself so it can run parallel workers
98+
test: select_parallel
9699

97100
# ----------
98101
# Another group of parallel tests

‎src/test/regress/sql/select_parallel.sql

Lines changed: 2 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -44,13 +44,7 @@ set force_parallel_mode=1;
4444
explain (costs off)
4545
select stringu1::int2from tenk1where unique1=1;
4646

47-
do $$begin
48-
-- Provoke error, possibly in worker. If this error happens to occur in
49-
-- the worker, there will be a CONTEXT line which must be hidden.
50-
perform stringu1::int2from tenk1where unique1=1;
51-
exception
52-
when others then
53-
raise'SQLERRM: %', sqlerrm;
54-
end$$;
47+
-- provoke error in worker
48+
select stringu1::int2from tenk1where unique1=1;
5549

5650
rollback;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp