Commitddf509e

committed

Tweak tests in COPY FREEZE

1 parent8de72b6 commitddf509eCopy full SHA for ddf509e

File tree

+10

-6

lines changed

+10

-6

lines changed

Lines changed: 10 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -297,16 +297,20 @@ SELECT * FROM vistest;`
`297`	`297`	`(2 rows)`
`298`	`298`
`299`	`299`	`COMMIT;`
	`300`	`+BEGIN;`
`300`	`301`	`TRUNCATE vistest;`
`301`	`302`	`COPY vistest FROM stdin CSV FREEZE;`
`302`		`-NOTICE: FREEZE option specified but pre-conditions not met`
`303`	`303`	`SELECT * FROM vistest;`
`304`	`304`	`a`
`305`	`305`	`---`
`306`		`-a`
`307`		`-b`
	`306`	`+x`
	`307`	`+y`
`308`	`308`	`(2 rows)`
`309`	`309`
	`310`	`+COMMIT;`
	`311`	`+TRUNCATE vistest;`
	`312`	`+COPY vistest FROM stdin CSV FREEZE;`
	`313`	`+NOTICE: FREEZE option specified but pre-conditions not met`
`310`	`314`	`BEGIN;`
`311`	`315`	`INSERT INTO vistest VALUES ('z');`
`312`	`316`	`SAVEPOINT s1;`
`@@ -318,8 +322,8 @@ NOTICE: FREEZE option specified but pre-conditions not met`
`318`	`322`	`SELECT * FROM vistest;`
`319`	`323`	`a`
`320`	`324`	`---`
`321`		`-a`
`322`		`-b`
	`325`	`+p`
	`326`	`+g`
`323`	`327`	`z`
`324`	`328`	`d`
`325`	`329`	`e`
`@@ -360,6 +364,7 @@ SELECT * FROM vistest;`
`360`	`364`	`(2 rows)`
`361`	`365`
`362`	`366`	`DROP TABLE vistest;`
	`367`	`+DROP FUNCTION truncate_in_subxact();`
`363`	`368`	`DROP TABLE x, y;`
`364`	`369`	`DROP FUNCTION fn_x_before();`
`365`	`370`	`DROP FUNCTION fn_x_after();`

Lines changed: 0 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -229,7 +229,6 @@ INSERT INTO vistest VALUES ('z');`
`229`	`229`	`SAVEPOINT s1;`
`230`	`230`	`TRUNCATE vistest;`
`231`	`231`	`ROLLBACK TO SAVEPOINT s1;`
`232`		`--- FREEZE should be silently ignored here`
`233`	`232`	`COPY vistestFROM stdin CSV FREEZE;`
`234`	`233`	`d`
`235`	`234`	`e`

Comments

(0)