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

Commitd1bdab2

Browse files
committed
test_shm_mq: Improve regression tests.
Per discussion with Tom Lane.
1 parentf88d4cf commitd1bdab2

File tree

2 files changed

+25
-4
lines changed

2 files changed

+25
-4
lines changed

‎contrib/test_shm_mq/expected/test_shm_mq.out

Lines changed: 20 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4,13 +4,31 @@ CREATE EXTENSION test_shm_mq;
44
-- the operations complete without crashing or hanging and that none of their
55
-- internal sanity tests fail.
66
--
7-
SELECT test_shm_mq(32768, (select string_agg(chr(32+(random()*96)::int), '') from generate_series(1,400)), 10000, 1);
7+
SELECT test_shm_mq(1024, '', 2000, 1);
88
test_shm_mq
99
-------------
1010

1111
(1 row)
1212

13-
SELECT test_shm_mq_pipelined(16384, (select string_agg(chr(32+(random()*96)::int), '') from generate_series(1,270000)), 200, 3);
13+
SELECT test_shm_mq(1024, 'a', 2001, 1);
14+
test_shm_mq
15+
-------------
16+
17+
(1 row)
18+
19+
SELECT test_shm_mq(32768, (select string_agg(chr(32+(random()*95)::int), '') from generate_series(1,(100+900*random())::int)), 10000, 1);
20+
test_shm_mq
21+
-------------
22+
23+
(1 row)
24+
25+
SELECT test_shm_mq(100, (select string_agg(chr(32+(random()*95)::int), '') from generate_series(1,(100+200*random())::int)), 10000, 1);
26+
test_shm_mq
27+
-------------
28+
29+
(1 row)
30+
31+
SELECT test_shm_mq_pipelined(16384, (select string_agg(chr(32+(random()*95)::int), '') from generate_series(1,270000)), 200, 3);
1432
test_shm_mq_pipelined
1533
-----------------------
1634

‎contrib/test_shm_mq/sql/test_shm_mq.sql

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5,5 +5,8 @@ CREATE EXTENSION test_shm_mq;
55
-- the operations complete without crashing or hanging and that none of their
66
-- internal sanity tests fail.
77
--
8-
SELECT test_shm_mq(32768, (select string_agg(chr(32+(random()*96)::int),'')from generate_series(1,400)),10000,1);
9-
SELECT test_shm_mq_pipelined(16384, (select string_agg(chr(32+(random()*96)::int),'')from generate_series(1,270000)),200,3);
8+
SELECT test_shm_mq(1024,'',2000,1);
9+
SELECT test_shm_mq(1024,'a',2001,1);
10+
SELECT test_shm_mq(32768, (select string_agg(chr(32+(random()*95)::int),'')from generate_series(1,(100+900*random())::int)),10000,1);
11+
SELECT test_shm_mq(100, (select string_agg(chr(32+(random()*95)::int),'')from generate_series(1,(100+200*random())::int)),10000,1);
12+
SELECT test_shm_mq_pipelined(16384, (select string_agg(chr(32+(random()*95)::int),'')from generate_series(1,270000)),200,3);

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp