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

Commit38fe61e

Browse files
committed
add new regression test (pathman_param_upd_del)
1 parent98bfe69 commit38fe61e

File tree

3 files changed

+171
-0
lines changed

3 files changed

+171
-0
lines changed

‎Makefile‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -40,6 +40,7 @@ REGRESS = pathman_array_qual \
4040
pathman_lateral\
4141
pathman_mergejoin\
4242
pathman_only\
43+
pathman_param_upd_del\
4344
pathman_permissions\
4445
pathman_rebuild_updates\
4546
pathman_rowmarks\

‎expected/pathman_param_upd_del.out‎

Lines changed: 132 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,132 @@
1+
\set VERBOSITY terse
2+
SET search_path = 'public';
3+
CREATE EXTENSION pg_pathman;
4+
CREATE SCHEMA param_upd_del;
5+
CREATE TABLE param_upd_del.test(key INT4 NOT NULL, val INT4);
6+
SELECT create_hash_partitions('param_upd_del.test', 'key', 10);
7+
create_hash_partitions
8+
------------------------
9+
10
10+
(1 row)
11+
12+
INSERT INTO param_upd_del.test SELECT i, i FROM generate_series(1, 1000) i;
13+
ANALYZE;
14+
PREPARE upd(INT4) AS UPDATE param_upd_del.test SET val = val + 1 WHERE key = $1;
15+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
16+
QUERY PLAN
17+
----------------------------
18+
Update on test_3
19+
-> Seq Scan on test_3
20+
Filter: (key = 10)
21+
(3 rows)
22+
23+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
24+
QUERY PLAN
25+
----------------------------
26+
Update on test_3
27+
-> Seq Scan on test_3
28+
Filter: (key = 10)
29+
(3 rows)
30+
31+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
32+
QUERY PLAN
33+
----------------------------
34+
Update on test_3
35+
-> Seq Scan on test_3
36+
Filter: (key = 10)
37+
(3 rows)
38+
39+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
40+
QUERY PLAN
41+
----------------------------
42+
Update on test_3
43+
-> Seq Scan on test_3
44+
Filter: (key = 10)
45+
(3 rows)
46+
47+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
48+
QUERY PLAN
49+
----------------------------
50+
Update on test_3
51+
-> Seq Scan on test_3
52+
Filter: (key = 10)
53+
(3 rows)
54+
55+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
56+
QUERY PLAN
57+
----------------------------
58+
Update on test_3
59+
-> Seq Scan on test_3
60+
Filter: (key = 10)
61+
(3 rows)
62+
63+
EXPLAIN (COSTS OFF) EXECUTE upd(11);
64+
QUERY PLAN
65+
----------------------------
66+
Update on test_9
67+
-> Seq Scan on test_9
68+
Filter: (key = 11)
69+
(3 rows)
70+
71+
DEALLOCATE upd;
72+
PREPARE del(INT4) AS DELETE FROM param_upd_del.test WHERE key = $1;
73+
EXPLAIN (COSTS OFF) EXECUTE del(10);
74+
QUERY PLAN
75+
----------------------------
76+
Delete on test_3
77+
-> Seq Scan on test_3
78+
Filter: (key = 10)
79+
(3 rows)
80+
81+
EXPLAIN (COSTS OFF) EXECUTE del(10);
82+
QUERY PLAN
83+
----------------------------
84+
Delete on test_3
85+
-> Seq Scan on test_3
86+
Filter: (key = 10)
87+
(3 rows)
88+
89+
EXPLAIN (COSTS OFF) EXECUTE del(10);
90+
QUERY PLAN
91+
----------------------------
92+
Delete on test_3
93+
-> Seq Scan on test_3
94+
Filter: (key = 10)
95+
(3 rows)
96+
97+
EXPLAIN (COSTS OFF) EXECUTE del(10);
98+
QUERY PLAN
99+
----------------------------
100+
Delete on test_3
101+
-> Seq Scan on test_3
102+
Filter: (key = 10)
103+
(3 rows)
104+
105+
EXPLAIN (COSTS OFF) EXECUTE del(10);
106+
QUERY PLAN
107+
----------------------------
108+
Delete on test_3
109+
-> Seq Scan on test_3
110+
Filter: (key = 10)
111+
(3 rows)
112+
113+
EXPLAIN (COSTS OFF) EXECUTE del(10);
114+
QUERY PLAN
115+
----------------------------
116+
Delete on test_3
117+
-> Seq Scan on test_3
118+
Filter: (key = 10)
119+
(3 rows)
120+
121+
EXPLAIN (COSTS OFF) EXECUTE del(11);
122+
QUERY PLAN
123+
----------------------------
124+
Delete on test_9
125+
-> Seq Scan on test_9
126+
Filter: (key = 11)
127+
(3 rows)
128+
129+
DEALLOCATE del;
130+
DROP SCHEMA param_upd_del CASCADE;
131+
NOTICE: drop cascades to 11 other objects
132+
DROP EXTENSION pg_pathman;

‎sql/pathman_param_upd_del.sql‎

Lines changed: 38 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,38 @@
1+
\set VERBOSITY terse
2+
3+
SET search_path='public';
4+
CREATE EXTENSION pg_pathman;
5+
CREATESCHEMAparam_upd_del;
6+
7+
8+
CREATETABLEparam_upd_del.test(key INT4NOT NULL, val INT4);
9+
SELECT create_hash_partitions('param_upd_del.test','key',10);
10+
INSERT INTOparam_upd_del.testSELECT i, iFROM generate_series(1,1000) i;
11+
12+
ANALYZE;
13+
14+
15+
PREPARE upd(INT4)ASUPDATEparam_upd_del.testSET val= val+1WHERE key= $1;
16+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
17+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
18+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
19+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
20+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
21+
EXPLAIN (COSTS OFF) EXECUTE upd(10);
22+
EXPLAIN (COSTS OFF) EXECUTE upd(11);
23+
DEALLOCATE upd;
24+
25+
26+
PREPARE del(INT4)ASDELETEFROMparam_upd_del.testWHERE key= $1;
27+
EXPLAIN (COSTS OFF) EXECUTE del(10);
28+
EXPLAIN (COSTS OFF) EXECUTE del(10);
29+
EXPLAIN (COSTS OFF) EXECUTE del(10);
30+
EXPLAIN (COSTS OFF) EXECUTE del(10);
31+
EXPLAIN (COSTS OFF) EXECUTE del(10);
32+
EXPLAIN (COSTS OFF) EXECUTE del(10);
33+
EXPLAIN (COSTS OFF) EXECUTE del(11);
34+
DEALLOCATE del;
35+
36+
37+
DROPSCHEMA param_upd_del CASCADE;
38+
DROP EXTENSION pg_pathman;

0 commit comments

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