NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commitf6fe29c

committed

fix isolation tests (rollback_on_create_partitions)

1 parentf833863 commitf6fe29cCopy full SHA for f6fe29c

File tree

1 file changed

-19

lines changed

expected
- rollback_on_create_partitions.out

1 file changed

-19

lines changed

`‎expected/rollback_on_create_partitions.out`

Lines changed: 0 additions & 19 deletions

Original file line number	Diff line number	Diff line change
`@@ -21,7 +21,6 @@ Append`
`21`	`21`	`-> Seq Scan on range_rel_8`
`22`	`22`	`-> Seq Scan on range_rel_9`
`23`	`23`	`-> Seq Scan on range_rel_10`
`24`		`-WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache`
`25`	`24`	`step rollback: ROLLBACK;`
`26`	`25`	`step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`27`	`26`	`QUERY PLAN`
`@@ -83,8 +82,6 @@ QUERY PLAN`
`83`	`82`
`84`	`83`	`Seq Scan on range_rel`
`85`	`84`	`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`
`88`	`85`	`step rollback: ROLLBACK;`
`89`	`86`	`step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`90`	`87`	`QUERY PLAN`
`@@ -129,7 +126,6 @@ drop_partitions`
`129`	`126`
`130`	`127`	`10`
`131`	`128`	`step savepoint_c: SAVEPOINT c;`
`132`		`-WARNING: All changes in partitioned table 'range_rel' will be discarded`
`133`	`129`	`step rollback_b: ROLLBACK TO SAVEPOINT b;`
`134`	`130`	`step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`135`	`131`	`QUERY PLAN`
`@@ -145,7 +141,6 @@ Append`
`145`	`141`	`-> Seq Scan on range_rel_8`
`146`	`142`	`-> Seq Scan on range_rel_9`
`147`	`143`	`-> Seq Scan on range_rel_10`
`148`		`-WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache`
`149`	`144`	`step rollback: ROLLBACK;`
`150`	`145`	`step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`151`	`146`	`QUERY PLAN`
`@@ -166,7 +161,6 @@ drop_partitions`
`166`	`161`
`167`	`162`	`10`
`168`	`163`	`step savepoint_c: SAVEPOINT c;`
`169`		`-WARNING: All changes in partitioned table 'range_rel' will be discarded`
`170`	`164`	`step rollback_b: ROLLBACK TO SAVEPOINT b;`
`171`	`165`	`step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`172`	`166`	`QUERY PLAN`
`@@ -216,8 +210,6 @@ QUERY PLAN`
`216`	`210`
`217`	`211`	`Seq Scan on range_rel`
`218`	`212`	`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`
`221`	`213`	`step rollback_a: ROLLBACK TO SAVEPOINT a;`
`222`	`214`	`step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`223`	`215`	`QUERY PLAN`
`@@ -247,8 +239,6 @@ QUERY PLAN`
`247`	`239`
`248`	`240`	`Seq Scan on range_rel`
`249`	`241`	`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`
`252`	`242`	`step rollback_a: ROLLBACK TO SAVEPOINT a;`
`253`	`243`	`step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`254`	`244`	`QUERY PLAN`
`@@ -278,7 +268,6 @@ QUERY PLAN`
`278`	`268`
`279`	`269`	`Seq Scan on range_rel`
`280`	`270`	`step savepoint_c: SAVEPOINT c;`
`281`		`-WARNING: All changes in partitioned table 'range_rel' will be discarded`
`282`	`271`	`step rollback_b: ROLLBACK TO SAVEPOINT b;`
`283`	`272`	`step drop_partitions: SELECT drop_partitions('range_rel');`
`284`	`273`	`drop_partitions`
`@@ -288,8 +277,6 @@ step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`288`	`277`	`QUERY PLAN`
`289`	`278`
`290`	`279`	`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`
`293`	`280`	`step rollback: ROLLBACK;`
`294`	`281`	`step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`295`	`282`	`QUERY PLAN`
`@@ -314,7 +301,6 @@ QUERY PLAN`
`314`	`301`
`315`	`302`	`Seq Scan on range_rel`
`316`	`303`	`step savepoint_c: SAVEPOINT c;`
`317`		`-WARNING: All changes in partitioned table 'range_rel' will be discarded`
`318`	`304`	`step rollback_b: ROLLBACK TO SAVEPOINT b;`
`319`	`305`	`step drop_partitions: SELECT drop_partitions('range_rel');`
`320`	`306`	`drop_partitions`
`@@ -343,8 +329,6 @@ step drop_partitions: SELECT drop_partitions('range_rel');`
`343`	`329`	`drop_partitions`
`344`	`330`
`345`	`331`	`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`
`348`	`332`	`step rollback_a: ROLLBACK TO SAVEPOINT a;`
`349`	`333`	`step create_partitions: SELECT create_range_partitions('range_rel', 'id', 1, 1000);`
`350`	`334`	`create_range_partitions`
`@@ -364,7 +348,6 @@ Append`
`364`	`348`	`-> Seq Scan on range_rel_8`
`365`	`349`	`-> Seq Scan on range_rel_9`
`366`	`350`	`-> Seq Scan on range_rel_10`
`367`		`-WARNING: Partitioning of table 'range_rel' has been aborted, removing partitions from pg_pathman's cache`
`368`	`351`	`step rollback: ROLLBACK;`
`369`	`352`	`step show_rel: EXPLAIN (COSTS OFF) SELECT * FROM range_rel;`
`370`	`353`	`QUERY PLAN`
`@@ -384,8 +367,6 @@ step drop_partitions: SELECT drop_partitions('range_rel');`
`384`	`367`	`drop_partitions`
`385`	`368`
`386`	`369`	`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`
`389`	`370`	`step rollback_a: ROLLBACK TO SAVEPOINT a;`
`390`	`371`	`step create_partitions: SELECT create_range_partitions('range_rel', 'id', 1, 1000);`
`391`	`372`	`create_range_partitions`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitf6fe29c

File tree

1 file changed

1 file changed

`‎expected/rollback_on_create_partitions.out`

0 commit comments