Commit6c6e05c

committed

pathman_inserts: test a gap case

1 parentc0854eb commit6c6e05cCopy full SHA for 6c6e05c

File tree

+24

-1

lines changed

+24

-1

lines changed

Lines changed: 16 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -856,6 +856,21 @@ NOTICE: AFTER INSERTION TRIGGER ON TABLE storage_14 HAS EXPIRED. INSERTED ROW:`
`856`	`856`	`256 \| 128 \| test_inserts.storage_14`
`857`	`857`	`(27 rows)`
`858`	`858`
	`859`	`+/* test gap case (missing partition in between) */`
	`860`	`+CREATE TABLE test_inserts.test_gap(val INT NOT NULL);`
	`861`	`+INSERT INTO test_inserts.test_gap SELECT generate_series(1, 30);`
	`862`	`+SELECT create_range_partitions('test_inserts.test_gap', 'val', 1, 10);`
	`863`	`+NOTICE: sequence "test_gap_seq" does not exist, skipping`
	`864`	`+ create_range_partitions`
	`865`	`+-------------------------`
	`866`	`+ 3`
	`867`	`+(1 row)`
	`868`	`+`
	`869`	`+DROP TABLE test_inserts.test_gap_2; /* make a gap */`
	`870`	`+INSERT INTO test_inserts.test_gap VALUES(15); /* not ok */`
	`871`	`+ERROR: cannot spawn a partition`
	`872`	`+DROP TABLE test_inserts.test_gap CASCADE;`
	`873`	`+NOTICE: drop cascades to 2 other objects`
`859`	`874`	`DROP SCHEMA test_inserts CASCADE;`
`860`		`-NOTICE: drop cascades to19 other objects`
	`875`	`+NOTICE: drop cascades to20 other objects`
`861`	`876`	`DROP EXTENSION pg_pathman CASCADE;`

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -165,6 +165,14 @@ FROM generate_series(-2, 130, 5) i`
`165`	`165`	`RETURNING e*2, b, tableoid::regclass;`
`166`	`166`
`167`	`167`
	`168`	`+/* test gap case (missing partition in between)*/`
	`169`	`+CREATETABLEtest_inserts.test_gap(valINTNOT NULL);`
	`170`	`+INSERT INTOtest_inserts.test_gapSELECT generate_series(1,30);`
	`171`	`+SELECT create_range_partitions('test_inserts.test_gap','val',1,10);`
	`172`	`+DROPTABLEtest_inserts.test_gap_2;/* make a gap*/`
	`173`	`+INSERT INTOtest_inserts.test_gapVALUES(15);/* not ok*/`
	`174`	`+DROPTABLEtest_inserts.test_gap CASCADE;`
	`175`	`+`
`168`	`176`
`169`	`177`	`DROPSCHEMA test_inserts CASCADE;`
`170`	`178`	`DROP EXTENSION pg_pathman CASCADE;`

Comments

(0)