Commit89b160c

committed

Improve new AND CHAIN tests

Tweak the tests so that we're not just testing the default setting oftransaction_read_only.Reported-by: fn ln <emuser20140816@gmail.com>

1 parent1192e3f commit89b160cCopy full SHA for 89b160c

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -940,15 +940,15 @@ ERROR: RELEASE SAVEPOINT can only be used in transaction blocks`
`940`	`940`	`-- but this is OK, because the BEGIN converts it to a regular xact`
`941`	`941`	`SELECT 1\; BEGIN\; SAVEPOINT sp\; ROLLBACK TO SAVEPOINT sp\; COMMIT;`
`942`	`942`	`-- Tests for AND CHAIN in implicit transaction blocks`
`943`		`-SET TRANSACTION READWRITE\; COMMIT AND CHAIN; -- error`
	`943`	`+SET TRANSACTION READONLY\; COMMIT AND CHAIN; -- error`
`944`	`944`	`ERROR: COMMIT AND CHAIN can only be used in transaction blocks`
`945`	`945`	`SHOW transaction_read_only;`
`946`	`946`	`transaction_read_only`
`947`	`947`	`-----------------------`
`948`	`948`	`off`
`949`	`949`	`(1 row)`
`950`	`950`
`951`		`-SET TRANSACTION READWRITE\; ROLLBACK AND CHAIN; -- error`
	`951`	`+SET TRANSACTION READONLY\; ROLLBACK AND CHAIN; -- error`
`952`	`952`	`ERROR: ROLLBACK AND CHAIN can only be used in transaction blocks`
`953`	`953`	`SHOW transaction_read_only;`
`954`	`954`	`transaction_read_only`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -542,10 +542,10 @@ SELECT 1\; BEGIN\; SAVEPOINT sp\; ROLLBACK TO SAVEPOINT sp\; COMMIT;`
`542`	`542`
`543`	`543`	`-- Tests for AND CHAIN in implicit transaction blocks`
`544`	`544`
`545`		`-SET TRANSACTION READWRITE\;COMMITAND CHAIN;-- error`
	`545`	`+SET TRANSACTION READONLY\;COMMITAND CHAIN;-- error`
`546`	`546`	`SHOW transaction_read_only;`
`547`	`547`
`548`		`-SET TRANSACTION READWRITE\;ROLLBACKAND CHAIN;-- error`
	`548`	`+SET TRANSACTION READONLY\;ROLLBACKAND CHAIN;-- error`
`549`	`549`	`SHOW transaction_read_only;`
`550`	`550`
`551`	`551`	`CREATETABLEabc (aint);`

Comments

(0)