Commit8ba32c2

authored and

committed

Add cache test

1 parent3074d07 commit8ba32c2Copy full SHA for 8ba32c2

File tree

+23

-0

lines changed

+23

-0

lines changed

Lines changed: 16 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1838,3 +1838,19 @@ SELECT pgv_remove('vars');`
`1838`	`1838`
`1839`	`1839`	`(1 row)`
`1840`	`1840`
	`1841`	`+-- REMOVED TRANSACTIONAL VARIABLE SHOULD BE NOT ACCESSIBLE THROUGH LastVariable`
	`1842`	`+SELECT pgv_insert('package', 'errs',row(n), true)`
	`1843`	`+FROM generate_series(1,5) AS gs(n) WHERE 1.0/(n-3)<>0;`
	`1844`	`+ERROR: division by zero`
	`1845`	`+SELECT pgv_insert('package', 'errs',row(1), true);`
	`1846`	`+ pgv_insert`
	`1847`	`+------------`
	`1848`	`+`
	`1849`	`+(1 row)`
	`1850`	`+`
	`1851`	`+SELECT pgv_free();`
	`1852`	`+ pgv_free`
	`1853`	`+----------`
	`1854`	`+`
	`1855`	`+(1 row)`
	`1856`	`+`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -460,3 +460,10 @@ SELECT pgv_set('vars', 'trans1', 'package restored'::text, true);`
`460`	`460`	`SELECT*FROM pgv_list()ORDER BY package, name;`
`461`	`461`	`COMMIT;`
`462`	`462`	`SELECT pgv_remove('vars');`
	`463`	`+`
	`464`	`+-- REMOVED TRANSACTIONAL VARIABLE SHOULD BE NOT ACCESSIBLE THROUGH LastVariable`
	`465`	`+SELECT pgv_insert('package','errs',row(n), true)`
	`466`	`+FROM generate_series(1,5)AS gs(n)WHERE1.0/(n-3)<>0;`
	`467`	`+SELECT pgv_insert('package','errs',row(1), true);`
	`468`	`+`
	`469`	`+SELECT pgv_free();`

Comments

(0)