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

Commit96fa7c3

Browse files
committed
fix regression tests for RuntimeXXX nodes
1 parentd881ef4 commit96fa7c3

File tree

2 files changed

+10
-10
lines changed

2 files changed

+10
-10
lines changed

‎expected/pg_pathman.out

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -194,7 +194,7 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2 OR value = 1;
194194

195195
-- Temporarily commented out
196196
-- EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value BETWEEN 1 AND 2;
197-
-- QUERY PLAN
197+
-- QUERY PLAN
198198
-- -------------------------------------------------
199199
-- Append
200200
-- -> Seq Scan on hash_rel_1
@@ -619,7 +619,7 @@ begin
619619
'wrong plan provider');
620620

621621
perform test.pathman_equal((plan->0->'Plan'->'Plans'->1->'Relation Name')::text,
622-
'"runtime_test_1_1"',
622+
format('"runtime_test_1_%s"', pathman.get_hash(hashint4(1), 6)),
623623
'wrong partition');
624624

625625
select count(*) from jsonb_array_elements_text(plan->0->'Plan'->'Plans') into num;
@@ -652,7 +652,7 @@ begin
652652

653653
for i in 0..3 loop
654654
perform test.pathman_equal((plan->0->'Plan'->'Plans'->1->'Plans'->i->'Relation Name')::text,
655-
format('"runtime_test_1_%s"', i + 1),
655+
format('"runtime_test_1_%s"',pathman.get_hash(hashint4(i + 1), 6)),
656656
'wrong partition');
657657

658658
num = plan->0->'Plan'->'Plans'->1->'Plans'->i->'Actual Loops';
@@ -686,7 +686,7 @@ begin
686686

687687
for i in 0..5 loop
688688
num = plan->0->'Plan'->'Plans'->1->'Plans'->i->'Actual Loops';
689-
perform test.pathman_assert(num > 0 and num <=1667, 'expected no more than1667 loops');
689+
perform test.pathman_assert(num > 0 and num <=1718, 'expected no more than1718 loops');
690690
end loop;
691691

692692
return 'ok';
@@ -718,7 +718,7 @@ begin
718718

719719
for i in 0..3 loop
720720
perform test.pathman_equal((plan->0->'Plan'->'Plans'->1->'Plans'->0->'Plans'->i->'Relation Name')::text,
721-
format('"runtime_test_2_%s"', i + 1),
721+
format('"runtime_test_2_%s"',pathman.get_hash(hashint4(i + 1), 6)),
722722
'wrong partition');
723723

724724
num = plan->0->'Plan'->'Plans'->1->'Plans'->0->'Plans'->i->'Actual Loops';

‎sql/pg_pathman.sql

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -71,7 +71,7 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2;
7171
EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value=2OR value=1;
7272
-- Temporarily commented out
7373
-- EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value BETWEEN 1 AND 2;
74-
-- QUERY PLAN
74+
-- QUERY PLAN
7575
-- -------------------------------------------------
7676
-- Append
7777
-- -> Seq Scan on hash_rel_1
@@ -203,7 +203,7 @@ begin
203203
'wrong plan provider');
204204

205205
performtest.pathman_equal((plan->0->'Plan'->'Plans'->1->'Relation Name')::text,
206-
'"runtime_test_1_1"',
206+
format('"runtime_test_1_%s"',pathman.get_hash(hashint4(1),6)),
207207
'wrong partition');
208208

209209
selectcount(*)from jsonb_array_elements_text(plan->0->'Plan'->'Plans') into num;
@@ -237,7 +237,7 @@ begin
237237

238238
for iin0..3 loop
239239
performtest.pathman_equal((plan->0->'Plan'->'Plans'->1->'Plans'->i->'Relation Name')::text,
240-
format('"runtime_test_1_%s"', i+1),
240+
format('"runtime_test_1_%s"',pathman.get_hash(hashint4(i+1),6)),
241241
'wrong partition');
242242

243243
num= plan->0->'Plan'->'Plans'->1->'Plans'->i->'Actual Loops';
@@ -272,7 +272,7 @@ begin
272272

273273
for iin0..5 loop
274274
num= plan->0->'Plan'->'Plans'->1->'Plans'->i->'Actual Loops';
275-
performtest.pathman_assert(num>0and num<=1667,'expected no more than1667 loops');
275+
performtest.pathman_assert(num>0and num<=1718,'expected no more than1718 loops');
276276
end loop;
277277

278278
return'ok';
@@ -305,7 +305,7 @@ begin
305305

306306
for iin0..3 loop
307307
performtest.pathman_equal((plan->0->'Plan'->'Plans'->1->'Plans'->0->'Plans'->i->'Relation Name')::text,
308-
format('"runtime_test_2_%s"', i+1),
308+
format('"runtime_test_2_%s"',pathman.get_hash(hashint4(i+1),6)),
309309
'wrong partition');
310310

311311
num= plan->0->'Plan'->'Plans'->1->'Plans'->0->'Plans'->i->'Actual Loops';

0 commit comments

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