Improve tests

za-arthur · za-arthur · commit ac709b4109bf · 2019-02-13T18:14:57.000+03:00
diff --git a/regression.diffs b/regression.diffs
@@ -0,0 +1,24 @@
+*** /home/artur/source/pg/pg_variables/expected/pg_variables.out	2019-02-13 17:46:10.430008139 +0300
+--- /home/artur/source/pg/pg_variables/results/pg_variables.out	2019-02-13 18:14:44.927663951 +0300
+***************
+*** 583,594 ****
+--- 583,598 ----
+   f
+  (1 row)
+  
++ SELECT pgv_update('vars4', 'r1', row(3, 'str22'::varchar)); -- fail
++ ERROR:  unrecognized package "vars4"
+  select pgv_delete('vars3', 'r2', NULL::int);
+   pgv_delete 
+  ------------
+   f
+  (1 row)
+  
++ select pgv_delete('vars4', 'r2', NULL::int); -- fail
++ ERROR:  unrecognized package "vars4"
+  -- Test NULL values
+  SELECT pgv_insert('vars3', 'r2', NULL); -- fail
+  ERROR:  record argument can not be NULL
+
+======================================================================
+
diff --git a/regression.out b/regression.out
@@ -0,0 +1,3 @@
+test pg_variables                 ... FAILED
+test pg_variables_any             ... ok
+test pg_variables_trans           ... ok
diff --git a/sql/pg_variables.sql b/sql/pg_variables.sql
@@ -164,7 +164,9 @@ SELECT pgv_select('vars3', 'r1', ARRAY[[1,2]]); -- fail
 -- Test variables caching
 SELECT pgv_insert('vars3', 'r2', row(1, 'str1', 'str2'));
 SELECT pgv_update('vars3', 'r1', row(3, 'str22'::varchar));
+SELECT pgv_update('vars4', 'r1', row(3, 'str22'::varchar)); -- fail
 select pgv_delete('vars3', 'r2', NULL::int);
+select pgv_delete('vars4', 'r2', NULL::int); -- fail
 
 -- Test NULL values
 SELECT pgv_insert('vars3', 'r2', NULL); -- fail

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+test pg_variables ... FAILED`
	`2`	`+test pg_variables_any ... ok`
	`3`	`+test pg_variables_trans ... ok`