Skip to content

Commit f6fe29c

Browse files
funbringerfunbringer
committed
fix isolation tests (rollback_on_create_partitions)
1 parent f833863 commit f6fe29c

File tree

1 file changed

+0
-19
lines changed

1 file changed

+0
-19
lines changed

‎expected/rollback_on_create_partitions.out

Lines changed: 0 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -21,7 +21,6 @@ Append
2121
-> Seq Scan on range_rel_8
2222
-> Seq Scan on range_rel_9
2323
-> Seq Scan on range_rel_10
24-
WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache
2524
step rollback: ROLLBACK;
2625
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
2726
QUERY PLAN
@@ -83,8 +82,6 @@ QUERY PLAN
8382

8483
Seq Scan on range_rel
8584
step savepoint_c: SAVEPOINT c;
86-
WARNING: All changes in partitioned table 'range_rel' will be discarded
87-
WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache
8885
step rollback: ROLLBACK;
8986
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
9087
QUERY PLAN
@@ -129,7 +126,6 @@ drop_partitions
129126

130127
10
131128
step savepoint_c: SAVEPOINT c;
132-
WARNING: All changes in partitioned table 'range_rel' will be discarded
133129
step rollback_b: ROLLBACK TO SAVEPOINT b;
134130
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
135131
QUERY PLAN
@@ -145,7 +141,6 @@ Append
145141
-> Seq Scan on range_rel_8
146142
-> Seq Scan on range_rel_9
147143
-> Seq Scan on range_rel_10
148-
WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache
149144
step rollback: ROLLBACK;
150145
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
151146
QUERY PLAN
@@ -166,7 +161,6 @@ drop_partitions
166161

167162
10
168163
step savepoint_c: SAVEPOINT c;
169-
WARNING: All changes in partitioned table 'range_rel' will be discarded
170164
step rollback_b: ROLLBACK TO SAVEPOINT b;
171165
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
172166
QUERY PLAN
@@ -216,8 +210,6 @@ QUERY PLAN
216210

217211
Seq Scan on range_rel
218212
step savepoint_c: SAVEPOINT c;
219-
WARNING: All changes in partitioned table 'range_rel' will be discarded
220-
WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache
221213
step rollback_a: ROLLBACK TO SAVEPOINT a;
222214
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
223215
QUERY PLAN
@@ -247,8 +239,6 @@ QUERY PLAN
247239

248240
Seq Scan on range_rel
249241
step savepoint_c: SAVEPOINT c;
250-
WARNING: All changes in partitioned table 'range_rel' will be discarded
251-
WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache
252242
step rollback_a: ROLLBACK TO SAVEPOINT a;
253243
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
254244
QUERY PLAN
@@ -278,7 +268,6 @@ QUERY PLAN
278268

279269
Seq Scan on range_rel
280270
step savepoint_c: SAVEPOINT c;
281-
WARNING: All changes in partitioned table 'range_rel' will be discarded
282271
step rollback_b: ROLLBACK TO SAVEPOINT b;
283272
step drop_partitions: SELECT drop_partitions('range_rel');
284273
drop_partitions
@@ -288,8 +277,6 @@ step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
288277
QUERY PLAN
289278

290279
Seq Scan on range_rel
291-
WARNING: All changes in partitioned table 'range_rel' will be discarded
292-
WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache
293280
step rollback: ROLLBACK;
294281
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
295282
QUERY PLAN
@@ -314,7 +301,6 @@ QUERY PLAN
314301

315302
Seq Scan on range_rel
316303
step savepoint_c: SAVEPOINT c;
317-
WARNING: All changes in partitioned table 'range_rel' will be discarded
318304
step rollback_b: ROLLBACK TO SAVEPOINT b;
319305
step drop_partitions: SELECT drop_partitions('range_rel');
320306
drop_partitions
@@ -343,8 +329,6 @@ step drop_partitions: SELECT drop_partitions('range_rel');
343329
drop_partitions
344330

345331
10
346-
WARNING: All changes in partitioned table 'range_rel' will be discarded
347-
WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache
348332
step rollback_a: ROLLBACK TO SAVEPOINT a;
349333
step create_partitions: SELECT create_range_partitions('range_rel', 'id', 1, 1000);
350334
create_range_partitions
@@ -364,7 +348,6 @@ Append
364348
-> Seq Scan on range_rel_8
365349
-> Seq Scan on range_rel_9
366350
-> Seq Scan on range_rel_10
367-
WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache
368351
step rollback: ROLLBACK;
369352
step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;
370353
QUERY PLAN
@@ -384,8 +367,6 @@ step drop_partitions: SELECT drop_partitions('range_rel');
384367
drop_partitions
385368

386369
10
387-
WARNING: All changes in partitioned table 'range_rel' will be discarded
388-
WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache
389370
step rollback_a: ROLLBACK TO SAVEPOINT a;
390371
step create_partitions: SELECT create_range_partitions('range_rel', 'id', 1, 1000);
391372
create_range_partitions

0 commit comments

Comments
 (0)