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

Commitb11d80a

Browse files
author
Vlada Pogozhelskaya
committed
[PGPRO-10100] Fixed regression test in pathman_upd_del
1 parentcc95f1c commitb11d80a

File tree

1 file changed

+23
-23
lines changed

1 file changed

+23
-23
lines changed

‎expected/pathman_upd_del_2.out

Lines changed: 23 additions & 23 deletions
Original file line numberDiff line numberDiff line change
@@ -23,7 +23,7 @@ INSERT INTO test.tmp VALUES (1, 1), (2, 2);
2323
CREATE TABLE test.tmp2 (id INTEGER NOT NULL, value INTEGER NOT NULL);
2424
INSERT INTO test.tmp2 SELECT i % 10 + 1, i FROM generate_series(1, 100) i;
2525
SELECT pathman.create_range_partitions('test.tmp2', 'id', 1, 1, 10);
26-
create_range_partitions
26+
create_range_partitions
2727
-------------------------
2828
10
2929
(1 row)
@@ -38,7 +38,7 @@ FROM generate_series('2010-01-01'::date, '2010-12-31'::date, '1 day') AS g;
3838
SELECT pathman.create_range_partitions('test.range_rel', 'dt',
3939
'2010-01-01'::date, '1 month'::interval,
4040
12);
41-
create_range_partitions
41+
create_range_partitions
4242
-------------------------
4343
12
4444
(1 row)
@@ -49,7 +49,7 @@ VACUUM ANALYZE;
4949
*/
5050
/* have partitions for this 'dt' */
5151
EXPLAIN (COSTS OFF) UPDATE test.range_rel SET value = 111 WHERE dt = '2010-06-15';
52-
QUERY PLAN
52+
QUERY PLAN
5353
--------------------------------------------------------------------------------
5454
Update on range_rel_6
5555
-> Seq Scan on range_rel_6
@@ -59,15 +59,15 @@ EXPLAIN (COSTS OFF) UPDATE test.range_rel SET value = 111 WHERE dt = '2010-06-15
5959
BEGIN;
6060
UPDATE test.range_rel SET value = 111 WHERE dt = '2010-06-15';
6161
SELECT * FROM test.range_rel WHERE dt = '2010-06-15';
62-
id | dt | value
62+
id | dt | value
6363
-----+--------------------------+-------
6464
166 | Tue Jun 15 00:00:00 2010 | 111
6565
(1 row)
6666

6767
ROLLBACK;
6868
/* have partitions for this 'dt' */
6969
EXPLAIN (COSTS OFF) DELETE FROM test.range_rel WHERE dt = '2010-06-15';
70-
QUERY PLAN
70+
QUERY PLAN
7171
--------------------------------------------------------------------------------
7272
Delete on range_rel_6
7373
-> Seq Scan on range_rel_6
@@ -77,14 +77,14 @@ EXPLAIN (COSTS OFF) DELETE FROM test.range_rel WHERE dt = '2010-06-15';
7777
BEGIN;
7878
DELETE FROM test.range_rel WHERE dt = '2010-06-15';
7979
SELECT * FROM test.range_rel WHERE dt = '2010-06-15';
80-
id | dt | value
80+
id | dt | value
8181
----+----+-------
8282
(0 rows)
8383

8484
ROLLBACK;
8585
/* no partitions for this 'dt' */
8686
EXPLAIN (COSTS OFF) UPDATE test.range_rel SET value = 222 WHERE dt = '1990-01-01';
87-
QUERY PLAN
87+
QUERY PLAN
8888
--------------------------------------------------------------------------------
8989
Update on range_rel
9090
-> Seq Scan on range_rel
@@ -94,14 +94,14 @@ EXPLAIN (COSTS OFF) UPDATE test.range_rel SET value = 222 WHERE dt = '1990-01-01
9494
BEGIN;
9595
UPDATE test.range_rel SET value = 111 WHERE dt = '1990-01-01';
9696
SELECT * FROM test.range_rel WHERE dt = '1990-01-01';
97-
id | dt | value
97+
id | dt | value
9898
----+----+-------
9999
(0 rows)
100100

101101
ROLLBACK;
102102
/* no partitions for this 'dt' */
103103
EXPLAIN (COSTS OFF) DELETE FROM test.range_rel WHERE dt < '1990-01-01';
104-
QUERY PLAN
104+
QUERY PLAN
105105
--------------------------------------------------------------------------------
106106
Delete on range_rel
107107
-> Seq Scan on range_rel
@@ -111,7 +111,7 @@ EXPLAIN (COSTS OFF) DELETE FROM test.range_rel WHERE dt < '1990-01-01';
111111
BEGIN;
112112
DELETE FROM test.range_rel WHERE dt < '1990-01-01';
113113
SELECT * FROM test.range_rel WHERE dt < '1990-01-01';
114-
id | dt | value
114+
id | dt | value
115115
----+----+-------
116116
(0 rows)
117117

@@ -120,7 +120,7 @@ ROLLBACK;
120120
EXPLAIN (COSTS OFF)
121121
UPDATE test.range_rel r SET value = t.value
122122
FROM test.tmp t WHERE r.dt = '2010-01-01' AND r.id = t.id;
123-
QUERY PLAN
123+
QUERY PLAN
124124
--------------------------------------------------------------------------------------
125125
Update on range_rel_1 r
126126
-> Nested Loop
@@ -138,7 +138,7 @@ ROLLBACK;
138138
EXPLAIN (COSTS OFF)
139139
UPDATE test.tmp t SET value = r.value
140140
FROM test.range_rel r WHERE r.dt = '2010-01-01' AND r.id = t.id;
141-
QUERY PLAN
141+
QUERY PLAN
142142
--------------------------------------------------------------------------------------
143143
Update on tmp t
144144
-> Nested Loop
@@ -156,7 +156,7 @@ ROLLBACK;
156156
EXPLAIN (COSTS OFF)
157157
DELETE FROM test.range_rel r USING test.tmp t
158158
WHERE r.dt = '2010-01-02' AND r.id = t.id;
159-
QUERY PLAN
159+
QUERY PLAN
160160
--------------------------------------------------------------------------------------
161161
Delete on range_rel_1 r
162162
-> Nested Loop
@@ -174,7 +174,7 @@ ROLLBACK;
174174
EXPLAIN (COSTS OFF)
175175
DELETE FROM test.tmp t USING test.range_rel r
176176
WHERE r.dt = '2010-01-02' AND r.id = t.id;
177-
QUERY PLAN
177+
QUERY PLAN
178178
--------------------------------------------------------------------------------------
179179
Delete on tmp t
180180
-> Nested Loop
@@ -224,7 +224,7 @@ USING (SELECT *
224224
JOIN test.tmp2 a2
225225
USING(id)) t
226226
WHERE t.id = r.id;
227-
QUERY PLAN
227+
QUERY PLAN
228228
------------------------------------------------
229229
Delete on tmp r
230230
-> Nested Loop
@@ -303,7 +303,7 @@ UPDATE test.tmp t SET value = 2
303303
WHERE t.id IN (SELECT id
304304
FROM test.tmp2 t2
305305
WHERE id = t.id);
306-
QUERY PLAN
306+
QUERY PLAN
307307
--------------------------------------------
308308
Update on tmp t
309309
-> Seq Scan on tmp t
@@ -338,7 +338,7 @@ EXPLAIN (COSTS OFF)
338338
WITH q AS (SELECT * FROM test.range_rel r
339339
WHERE r.dt = '2010-01-02')
340340
DELETE FROM test.tmp USING q;
341-
QUERY PLAN
341+
QUERY PLAN
342342
--------------------------------------------------------------------------------------------
343343
Delete on tmp
344344
-> Nested Loop
@@ -359,7 +359,7 @@ WITH q AS (DELETE FROM test.range_rel r
359359
WHERE r.dt = '2010-01-02'
360360
RETURNING *)
361361
DELETE FROM test.tmp USING q;
362-
QUERY PLAN
362+
QUERY PLAN
363363
----------------------------------------------------------------------------------------
364364
Delete on tmp
365365
CTE q
@@ -384,7 +384,7 @@ WITH q AS (DELETE FROM test.tmp t
384384
WHERE r.dt = '2010-01-02' AND r.id = t.id
385385
RETURNING *)
386386
DELETE FROM test.tmp USING q;
387-
QUERY PLAN
387+
QUERY PLAN
388388
----------------------------------------------------------------------------------------------
389389
Delete on tmp
390390
CTE q
@@ -414,15 +414,15 @@ WITH q AS (WITH n AS (SELECT id FROM test.tmp2 WHERE id = 2)
414414
WHERE t.id = n.id
415415
RETURNING *)
416416
DELETE FROM test.tmp USING q;
417-
QUERY PLAN
418-
----------------------------------------
417+
QUERY PLAN
418+
---------------------------------------------
419419
Delete on tmp
420420
CTE q
421421
-> Delete on tmp t
422422
-> Nested Loop
423423
-> Seq Scan on tmp t
424424
Filter: (id = 2)
425-
-> Seq Scan on tmp2_2
425+
-> Seq Scan on tmp2_2 tmp2
426426
Filter: (id = 2)
427427
-> Nested Loop
428428
-> Seq Scan on tmp
@@ -434,7 +434,7 @@ EXPLAIN (COSTS OFF)
434434
WITH q AS (SELECT id FROM test.tmp2
435435
WHERE id < 3)
436436
DELETE FROM test.tmp t WHERE t.id in (SELECT id FROM q);
437-
QUERY PLAN
437+
QUERY PLAN
438438
--------------------------------------------------------------
439439
Delete on tmp t
440440
-> Nested Loop Semi Join

0 commit comments

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