Commit7e22540

committed

add test case for DROP INDEX CONCURRENTLY

1 parent86e280c commit7e22540Copy full SHA for 7e22540

File tree

+38

-0

lines changed

+38

-0

lines changed

Lines changed: 19 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1043,6 +1043,25 @@ SELECT context, entries FROM pathman_cache_stats ORDER BY context;/* OK */`
`1043`	`1043`
`1044`	`1044`	`DROP SCHEMA calamity CASCADE;`
`1045`	`1045`	`DROP EXTENSION pg_pathman;`
	`1046`	`+/*`
	`1047`	`+ * -----------------------------------------------------------`
	`1048`	`+ * Special tests (drop index concurrently to test snapshots)`
	`1049`	`+ * -----------------------------------------------------------`
	`1050`	`+ */`
	`1051`	`+CREATE SCHEMA calamity;`
	`1052`	`+CREATE EXTENSION pg_pathman;`
	`1053`	`+CREATE TABLE calamity.drop_index (val INT4 NOT NULL);`
	`1054`	`+CREATE INDEX ON calamity.drop_index (val);`
	`1055`	`+SELECT create_hash_partitions('calamity.drop_index', 'val', 2);`
	`1056`	`+ create_hash_partitions`
	`1057`	`+------------------------`
	`1058`	`+ 2`
	`1059`	`+(1 row)`
	`1060`	`+`
	`1061`	`+DROP INDEX CONCURRENTLY calamity.drop_index_0_val_idx;`
	`1062`	`+DROP SCHEMA calamity CASCADE;`
	`1063`	`+NOTICE: drop cascades to 3 other objects`
	`1064`	`+DROP EXTENSION pg_pathman;`
`1046`	`1065`	`/*`
`1047`	`1066`	`* ------------------------------------------`
`1048`	`1067`	`* Special tests (uninitialized pg_pathman)`

Lines changed: 19 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -422,6 +422,25 @@ DROP EXTENSION pg_pathman;`
`422`	`422`
`423`	`423`
`424`	`424`
	`425`	`+/*`
	`426`	`+ * -----------------------------------------------------------`
	`427`	`+ * Special tests (drop index concurrently to test snapshots)`
	`428`	`+ * -----------------------------------------------------------`
	`429`	`+*/`
	`430`	`+`
	`431`	`+CREATESCHEMAcalamity;`
	`432`	`+CREATE EXTENSION pg_pathman;`
	`433`	`+`
	`434`	`+CREATETABLEcalamity.drop_index (val INT4NOT NULL);`
	`435`	`+CREATEINDEXONcalamity.drop_index (val);`
	`436`	`+SELECT create_hash_partitions('calamity.drop_index','val',2);`
	`437`	`+DROPINDEX CONCURRENTLYcalamity.drop_index_0_val_idx;`
	`438`	`+`
	`439`	`+DROPSCHEMA calamity CASCADE;`
	`440`	`+DROP EXTENSION pg_pathman;`
	`441`	`+`
	`442`	`+`
	`443`	`+`
`425`	`444`	`/*`
`426`	`445`	`* ------------------------------------------`
`427`	`446`	`* Special tests (uninitialized pg_pathman)`

Comments

(0)