Commit2e174ba

committed

[PGPRO-5255] fix tests for postgres 9.5 and 10

1 parent98b1f18 commit2e174baCopy full SHA for 2e174ba

File tree

+10

-10

lines changed

+10

-10

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -94,7 +94,8 @@ Check constraints:`
`94`	`94`	`"pathman_r4_check" CHECK (dt >= '06-01-2015'::date AND dt < '01-01-2016'::date)`
`95`	`95`	`Inherits: test.range_rel`
`96`	`96`
`97`		`-ALTER TABLE IF EXISTS test.nonexistent_table ATTACH PARTITION baz DEFAULT;`
	`97`	`+/* Note: PG-10 doesn't support ATTACH PARTITION ... DEFAULT */`
	`98`	`+ALTER TABLE IF EXISTS test.nonexistent_table ATTACH PARTITION baz FOR VALUES IN (42);`
`98`	`99`	`NOTICE: relation "nonexistent_table" does not exist, skipping`
`99`	`100`	`ALTER TABLE IF EXISTS test.nonexistent_table DETACH PARTITION baz;`
`100`	`101`	`NOTICE: relation "nonexistent_table" does not exist, skipping`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -94,7 +94,8 @@ Check constraints:`
`94`	`94`	`"pathman_r4_check" CHECK (dt >= '06-01-2015'::date AND dt < '01-01-2016'::date)`
`95`	`95`	`Inherits: test.range_rel`
`96`	`96`
`97`		`-ALTER TABLE IF EXISTS test.nonexistent_table ATTACH PARTITION baz DEFAULT;`
	`97`	`+/* Note: PG-10 doesn't support ATTACH PARTITION ... DEFAULT */`
	`98`	`+ALTER TABLE IF EXISTS test.nonexistent_table ATTACH PARTITION baz FOR VALUES IN (42);`
`98`	`99`	`NOTICE: relation "nonexistent_table" does not exist, skipping`
`99`	`100`	`ALTER TABLE IF EXISTS test.nonexistent_table DETACH PARTITION baz;`
`100`	`101`	`NOTICE: relation "nonexistent_table" does not exist, skipping`

Lines changed: 2 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -377,12 +377,10 @@ CREATE SCHEMA test_nonexistance;`
`377`	`377`	`ALTER TABLE IF EXISTS test_nonexistance.nonexistent_table RENAME TO other_table_name;`
`378`	`378`	`NOTICE: relation "nonexistent_table" does not exist, skipping`
`379`	`379`	`/* renaming existent tables already tested earlier (see rename.plain_test) */`
`380`		`-ALTER TABLE IF EXISTS test_nonexistance.nonexistent_table ADD COLUMNIF NOT EXISTSj INT4;`
	`380`	`+ALTER TABLE IF EXISTS test_nonexistance.nonexistent_table ADD COLUMN j INT4;`
`381`	`381`	`NOTICE: relation "nonexistent_table" does not exist, skipping`
`382`	`382`	`CREATE TABLE test_nonexistance.existent_table(i INT4);`
`383`		`-ALTER TABLE IF EXISTS test_nonexistance.existent_table ADD COLUMN IF NOT EXISTS i INT4;`
`384`		`-NOTICE: column "i" of relation "existent_table" already exists, skipping`
`385`		`-ALTER TABLE IF EXISTS test_nonexistance.existent_table ADD COLUMN IF NOT EXISTS j INT4;`
	`383`	`+ALTER TABLE IF EXISTS test_nonexistance.existent_table ADD COLUMN j INT4;`
`386`	`384`	`SELECT attname FROM pg_attribute WHERE attnum > 0 AND attrelid = 'test_nonexistance.existent_table'::REGCLASS;`
`387`	`385`	`attname`
`388`	`386`	`---------`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -39,7 +39,8 @@ CREATE TABLE test.r4 PARTITION OF test.range_rel`
`39`	`39`	`FORVALUESFROM ('2015-06-01') TO ('2016-01-01');`
`40`	`40`	`\d+test.r4;`
`41`	`41`
`42`		`-ALTERTABLE IF EXISTStest.nonexistent_table ATTACH PARTITION baz DEFAULT;`
	`42`	`+/* Note: PG-10 doesn't support ATTACH PARTITION ... DEFAULT*/`
	`43`	`+ALTERTABLE IF EXISTStest.nonexistent_table ATTACH PARTITION baz FORVALUESIN (42);`
`43`	`44`	`ALTERTABLE IF EXISTStest.nonexistent_table DETACH PARTITION baz;`
`44`	`45`
`45`	`46`	`DROPSCHEMA test CASCADE;`

Lines changed: 2 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -258,10 +258,9 @@ CREATE SCHEMA test_nonexistance;`
`258`	`258`	`ALTERTABLE IF EXISTStest_nonexistance.nonexistent_table RENAME TO other_table_name;`
`259`	`259`	`/* renaming existent tables already tested earlier (see rename.plain_test)*/`
`260`	`260`
`261`		`-ALTERTABLE IF EXISTStest_nonexistance.nonexistent_table ADD COLUMNIF NOT EXISTSj INT4;`
	`261`	`+ALTERTABLE IF EXISTStest_nonexistance.nonexistent_table ADD COLUMN j INT4;`
`262`	`262`	`CREATETABLEtest_nonexistance.existent_table(i INT4);`
`263`		`-ALTERTABLE IF EXISTStest_nonexistance.existent_table ADD COLUMN IF NOT EXISTS i INT4;`
`264`		`-ALTERTABLE IF EXISTStest_nonexistance.existent_table ADD COLUMN IF NOT EXISTS j INT4;`
	`263`	`+ALTERTABLE IF EXISTStest_nonexistance.existent_table ADD COLUMN j INT4;`
`265`	`264`	`SELECT attnameFROM pg_attributeWHERE attnum>0AND attrelid='test_nonexistance.existent_table'::REGCLASS;`
`266`	`265`	`DROPTABLEtest_nonexistance.existent_table;`
`267`	`266`

Comments

(0)