Skip to content

Commit 96fa7c3

Browse files
funbringerfunbringer
committed
fix regression tests for RuntimeXXX nodes
1 parent d881ef4 commit 96fa7c3

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 than 1667 loops');
689+
perform test.pathman_assert(num > 0 and num <= 1718, 'expected no more than 1718 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 * FROM test.hash_rel WHERE value = 2 OR 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
perform test.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
select count(*) from jsonb_array_elements_text(plan->0->'Plan'->'Plans') into num;
@@ -237,7 +237,7 @@ begin
237237

238238
for i in 0..3 loop
239239
perform test.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 i in 0..5 loop
274274
num = plan->0->'Plan'->'Plans'->1->'Plans'->i->'Actual Loops';
275-
perform test.pathman_assert(num > 0 and num <= 1667, 'expected no more than 1667 loops');
275+
perform test.pathman_assert(num > 0 and num <= 1718, 'expected no more than 1718 loops');
276276
end loop;
277277

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

306306
for i in 0..3 loop
307307
perform test.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)