Commit660968a

committed

Improve tests

1 parentc163b97 commit660968aCopy full SHA for 660968a

File tree

+21

-12

lines changed

+21

-12

lines changed

Lines changed: 16 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -577,10 +577,16 @@ SELECT pgv_insert('vars3', 'r2', row(1, 'str1', 'str2'));`
`577`	`577`
`578`	`578`	`(1 row)`
`579`	`579`
`580`		`-SELECT pgv_update('vars3', 'r2', row(1, 'str2', 'str1'));`
	`580`	`+SELECT pgv_update('vars3', 'r1', row(3, 'str22'::varchar));`
`581`	`581`	`pgv_update`
`582`	`582`	`------------`
`583`		`- t`
	`583`	`+ f`
	`584`	`+(1 row)`
	`585`	`+`
	`586`	`+select pgv_delete('vars3', 'r2', NULL::int);`
	`587`	`+ pgv_delete`
	`588`	`+------------`
	`589`	`+ f`
`584`	`590`	`(1 row)`
`585`	`591`
`586`	`592`	`-- Test NULL values`
`@@ -611,6 +617,8 @@ SELECT pgv_select('vars3', 'r1', 1);`
`611`	`617`	`(1,str11)`
`612`	`618`	`(1 row)`
`613`	`619`
	`620`	`+SELECT pgv_select('vars3', 'r1', 1::float); -- fail`
	`621`	`+ERROR: requested value type differs from variable "r1" key type`
`614`	`622`	`SELECT pgv_select('vars3', 'r1', 0);`
`615`	`623`	`pgv_select`
`616`	`624`	`------------`
`@@ -641,6 +649,12 @@ SELECT pgv_update('vars3', 'r1', tab) FROM tab;`
`641`	`649`	`t`
`642`	`650`	`(4 rows)`
`643`	`651`
	`652`	`+SELECT pgv_update('vars3', 'r1', row(4, 'str44'::varchar));`
	`653`	`+ pgv_update`
	`654`	`+------------`
	`655`	`+ f`
	`656`	`+(1 row)`
	`657`	`+`
`644`	`658`	`SELECT pgv_select('vars3', 'r1');`
`645`	`659`	`pgv_select`
`646`	`660`	`------------`

Lines changed: 1 addition & 9 deletions

Original file line number	Diff line number	Diff line change
`@@ -918,15 +918,7 @@ remove_package(PG_FUNCTION_ARGS)`
`918`	`918`	`package_name=PG_GETARG_TEXT_PP(0);`
`919`	`919`
`920`	`920`	`package=getPackageByName(package_name, false, true);`
`921`		`-if (package)`
`922`		`-removePackageInternal(package);`
`923`		`-else`
`924`		`-{`
`925`		`-getKeyFromName(package_name,key);`
`926`		`-ereport(ERROR,`
`927`		`-(errcode(ERRCODE_INVALID_PARAMETER_VALUE),`
`928`		`-errmsg("unrecognized package \"%s\"",key)));`
`929`		`-}`
	`921`	`+removePackageInternal(package);`
`930`	`922`
`931`	`923`	`resetVariablesCache(true);`
`932`	`924`

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -163,7 +163,8 @@ SELECT pgv_select('vars3', 'r1', ARRAY[[1,2]]); -- fail`
`163`	`163`
`164`	`164`	`-- Test variables caching`
`165`	`165`	`SELECT pgv_insert('vars3','r2', row(1,'str1','str2'));`
`166`		`-SELECT pgv_update('vars3','r2', row(1,'str2','str1'));`
	`166`	`+SELECT pgv_update('vars3','r1', row(3,'str22'::varchar));`
	`167`	`+select pgv_delete('vars3','r2',NULL::int);`
`167`	`168`
`168`	`169`	`-- Test NULL values`
`169`	`170`	`SELECT pgv_insert('vars3','r2',NULL);-- fail`
`@@ -173,12 +174,14 @@ SELECT pgv_select('vars3', 'r1', NULL::int[]); -- fail`
`173`	`174`
`174`	`175`	`SELECT pgv_select('vars3','r1');`
`175`	`176`	`SELECT pgv_select('vars3','r1',1);`
	`177`	`+SELECT pgv_select('vars3','r1',1::float);-- fail`
`176`	`178`	`SELECT pgv_select('vars3','r1',0);`
`177`	`179`	`SELECT pgv_select('vars3','r1',NULL::int);`
`178`	`180`	`SELECT pgv_select('vars3','r1', ARRAY[1,0,NULL]);`
`179`	`181`
`180`	`182`	`UPDATE tabSET t='str33'WHERE id=1;`
`181`	`183`	`SELECT pgv_update('vars3','r1', tab)FROM tab;`
	`184`	`+SELECT pgv_update('vars3','r1', row(4,'str44'::varchar));`
`182`	`185`	`SELECT pgv_select('vars3','r1');`
`183`	`186`
`184`	`187`	`SELECT pgv_delete('vars3','r1',1);`

Comments

(0)