Commitf46bd22

committed

Fix test cases related with NOT NULL check

1 parent74778ce commitf46bd22Copy full SHA for f46bd22

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -131,10 +131,10 @@ CREATE INDEX ON test.range_rel (dt);`
`131`	`131`	`INSERT INTO test.range_rel (dt, txt)`
`132`	`132`	`SELECT g, md5(g::TEXT) FROM generate_series('2015-01-01', '2015-04-30', '1 day'::interval) as g;`
`133`	`133`	`SELECT pathman.create_range_partitions('test.range_rel', 'dt', '2015-01-01'::DATE, '1 month'::INTERVAL, 2);`
	`134`	`+ERROR: not enough partitions to fit all values of "dt"`
	`135`	`+SELECT pathman.create_range_partitions('test.range_rel', 'dt', '2015-01-01'::DATE, '1 month'::INTERVAL);`
`134`	`136`	`ERROR: partitioning key "dt" must be NOT NULL`
`135`	`137`	`ALTER TABLE test.range_rel ALTER COLUMN dt SET NOT NULL;`
`136`		`-SELECT pathman.create_range_partitions('test.range_rel', 'dt', '2015-01-01'::DATE, '1 month'::INTERVAL, 2);`
`137`		`-ERROR: not enough partitions to fit all values of "dt"`
`138`	`138`	`SELECT pathman.create_range_partitions('test.range_rel', 'DT', '2015-01-01'::DATE, '1 month'::INTERVAL);`
`139`	`139`	`NOTICE: sequence "range_rel_seq" does not exist, skipping`
`140`	`140`	`create_range_partitions`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -40,8 +40,8 @@ CREATE INDEX ON test.range_rel (dt);`
`40`	`40`	`INSERT INTOtest.range_rel (dt, txt)`
`41`	`41`	`SELECT g, md5(g::TEXT)FROM generate_series('2015-01-01','2015-04-30','1 day'::interval)as g;`
`42`	`42`	`SELECTpathman.create_range_partitions('test.range_rel','dt','2015-01-01'::DATE,'1 month'::INTERVAL,2);`
	`43`	`+SELECTpathman.create_range_partitions('test.range_rel','dt','2015-01-01'::DATE,'1 month'::INTERVAL);`
`43`	`44`	`ALTERTABLEtest.range_rel ALTER COLUMN dtSETNOT NULL;`
`44`		`-SELECTpathman.create_range_partitions('test.range_rel','dt','2015-01-01'::DATE,'1 month'::INTERVAL,2);`
`45`	`45`	`SELECTpathman.create_range_partitions('test.range_rel','DT','2015-01-01'::DATE,'1 month'::INTERVAL);`
`46`	`46`	`SELECTCOUNT(*)FROMtest.range_rel;`
`47`	`47`	`SELECTCOUNT(*)FROM ONLYtest.range_rel;`

Comments

(0)