Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitac709b4

Browse files
committed
Improve tests
1 parent660968a commitac709b4

File tree

3 files changed

+29
-0
lines changed

3 files changed

+29
-0
lines changed

‎regression.diffs‎

Lines changed: 24 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,24 @@
1+
*** /home/artur/source/pg/pg_variables/expected/pg_variables.out2019-02-13 17:46:10.430008139 +0300
2+
--- /home/artur/source/pg/pg_variables/results/pg_variables.out2019-02-13 18:14:44.927663951 +0300
3+
***************
4+
*** 583,594 ****
5+
--- 583,598 ----
6+
f
7+
(1 row)
8+
9+
+ SELECT pgv_update('vars4', 'r1', row(3, 'str22'::varchar)); -- fail
10+
+ ERROR: unrecognized package "vars4"
11+
select pgv_delete('vars3', 'r2', NULL::int);
12+
pgv_delete
13+
------------
14+
f
15+
(1 row)
16+
17+
+ select pgv_delete('vars4', 'r2', NULL::int); -- fail
18+
+ ERROR: unrecognized package "vars4"
19+
-- Test NULL values
20+
SELECT pgv_insert('vars3', 'r2', NULL); -- fail
21+
ERROR: record argument can not be NULL
22+
23+
======================================================================
24+

‎regression.out‎

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
test pg_variables ... FAILED
2+
test pg_variables_any ... ok
3+
test pg_variables_trans ... ok

‎sql/pg_variables.sql‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -164,7 +164,9 @@ SELECT pgv_select('vars3', 'r1', ARRAY[[1,2]]); -- fail
164164
-- Test variables caching
165165
SELECT pgv_insert('vars3','r2', row(1,'str1','str2'));
166166
SELECT pgv_update('vars3','r1', row(3,'str22'::varchar));
167+
SELECT pgv_update('vars4','r1', row(3,'str22'::varchar));-- fail
167168
select pgv_delete('vars3','r2',NULL::int);
169+
select pgv_delete('vars4','r2',NULL::int);-- fail
168170

169171
-- Test NULL values
170172
SELECT pgv_insert('vars3','r2',NULL);-- fail

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp