Commit56076be

authored and

committed

Add test for proper package state level assignment

1 parentead4952 commit56076beCopy full SHA for 56076be

File tree

+36

-0

lines changed

+36

-0

lines changed

Lines changed: 27 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1935,6 +1935,33 @@ ERROR: syntax error at or near "ERROR"`
`1935`	`1935`	`LINE 1: ERROR;`
`1936`	`1936`	`^`
`1937`	`1937`	`COMMIT;`
	`1938`	`+BEGIN;`
	`1939`	`+SELECT pgv_set('vars', 'any1', 'some value'::text, true);`
	`1940`	`+ pgv_set`
	`1941`	`+---------`
	`1942`	`+`
	`1943`	`+(1 row)`
	`1944`	`+`
	`1945`	`+SELECT pgv_free();`
	`1946`	`+ pgv_free`
	`1947`	`+----------`
	`1948`	`+`
	`1949`	`+(1 row)`
	`1950`	`+`
	`1951`	`+SAVEPOINT sp_to_rollback;`
	`1952`	`+SELECT pgv_set('vars', 'any1', 'some value'::text, true);`
	`1953`	`+ pgv_set`
	`1954`	`+---------`
	`1955`	`+`
	`1956`	`+(1 row)`
	`1957`	`+`
	`1958`	`+ROLLBACK TO sp_to_rollback;`
	`1959`	`+COMMIT;`
	`1960`	`+SELECT package FROM pgv_stats() ORDER BY package;`
	`1961`	`+ package`
	`1962`	`+---------`
	`1963`	`+(0 rows)`
	`1964`	`+`
`1938`	`1965`	`SELECT pgv_free();`
`1939`	`1966`	`pgv_free`
`1940`	`1967`	`----------`

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -500,4 +500,13 @@ SELECT pgv_free();`
`500`	`500`	`ERROR;`
`501`	`501`	`COMMIT;`
`502`	`502`
	`503`	`+BEGIN;`
	`504`	`+SELECT pgv_set('vars','any1','some value'::text, true);`
	`505`	`+SELECT pgv_free();`
	`506`	`+SAVEPOINT sp_to_rollback;`
	`507`	`+SELECT pgv_set('vars','any1','some value'::text, true);`
	`508`	`+ROLLBACK TO sp_to_rollback;`
	`509`	`+COMMIT;`
	`510`	`+SELECT packageFROM pgv_stats()ORDER BY package;`
	`511`	`+`
`503`	`512`	`SELECT pgv_free();`

Comments

(0)