1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
|
\unset ECHO
ok 1 - starting up
ok 2 - starting up some more
# Subtest: whatever."test ident"()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
ok 4 - ident
ok 5 - ident 2
ok 6 - teardown
ok 7 - teardown more
1..7
ok 3 - whatever."test ident"
# Subtest: whatever.testdividebyzero()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
# Test died: 22012: division by zero
# CONTEXT:
# SQL function "testdividebyzero" statement 1
# PL/pgSQL function _runner(text[],text[],text[],text[],text[]) line 62 at FOR over EXECUTE statement
# SQL function "runtests" statement 1
# SQL function "runtests" statement 1
not ok 4 - whatever.testdividebyzero
# Failed test 4: "whatever.testdividebyzero"
# Subtest: whatever.testplpgsql()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
ok 4 - plpgsql simple
ok 5 - plpgsql simple 2
ok 6 - Should be a 1 in the test table
ok 7 - teardown
ok 8 - teardown more
1..8
ok 5 - whatever.testplpgsql
# Subtest: whatever.testplpgsqldie()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
# Test died: P0001: This test should die, but not halt execution.
# Note that in some cases we get what appears to be a duplicate context message, but that is due to Postgres itself.
# DETAIL: DETAIL
# SCHEMA: SCHEMA
# TABLE: TABLE
# COLUMN: COLUMN
# CONSTRAINT: CONSTRAINT
# TYPE: TYPE
# CONTEXT:
# PL/pgSQL function __die() line 3 at RAISE
# SQL statement "SELECT __die();"
# PL/pgSQL function whatever.testplpgsqldie() line 23 at EXECUTE
# PL/pgSQL function _runner(text[],text[],text[],text[],text[]) line 62 at FOR over EXECUTE statement
# SQL function "runtests" statement 1
# SQL function "runtests" statement 1
not ok 6 - whatever.testplpgsqldie
# Failed test 6: "whatever.testplpgsqldie"
# Subtest: whatever.testthis()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
ok 4 - simple pass
ok 5 - another simple pass
ok 6 - teardown
ok 7 - teardown more
1..7
ok 7 - whatever.testthis
# Subtest: whatever.testy()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
not ok 4 - this test intentionally fails
# Failed test 4: "this test intentionally fails"
ok 5 - teardown
ok 6 - teardown more
1..6
# Looks like you failed 1 test of 6
not ok 8 - whatever.testy
# Failed test 8: "whatever.testy"
# Subtest: whatever.testz()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
ok 4 - Late test should find nothing in the test table
ok 5 - teardown
ok 6 - teardown more
1..6
ok 9 - whatever.testz
ok 10 - shutting down
ok 11 - shutting down more
1..11
# Looks like you failed 3 tests of 11
ok 1 - starting up
ok 2 - starting up some more
# Subtest: whatever."test ident"()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
ok 4 - ident
ok 5 - ident 2
ok 6 - teardown
ok 7 - teardown more
1..7
ok 3 - whatever."test ident"
# Subtest: whatever.testdividebyzero()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
# Test died: 22012: division by zero
# CONTEXT:
# SQL function "testdividebyzero" statement 1
# PL/pgSQL function _runner(text[],text[],text[],text[],text[]) line 62 at FOR over EXECUTE statement
# SQL function "runtests" statement 1
not ok 4 - whatever.testdividebyzero
# Failed test 4: "whatever.testdividebyzero"
# Subtest: whatever.testplpgsql()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
ok 4 - plpgsql simple
ok 5 - plpgsql simple 2
ok 6 - Should be a 1 in the test table
ok 7 - teardown
ok 8 - teardown more
1..8
ok 5 - whatever.testplpgsql
# Subtest: whatever.testplpgsqldie()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
# Test died: P0001: This test should die, but not halt execution.
# Note that in some cases we get what appears to be a duplicate context message, but that is due to Postgres itself.
# DETAIL: DETAIL
# SCHEMA: SCHEMA
# TABLE: TABLE
# COLUMN: COLUMN
# CONSTRAINT: CONSTRAINT
# TYPE: TYPE
# CONTEXT:
# PL/pgSQL function __die() line 3 at RAISE
# SQL statement "SELECT __die();"
# PL/pgSQL function whatever.testplpgsqldie() line 23 at EXECUTE
# PL/pgSQL function _runner(text[],text[],text[],text[],text[]) line 62 at FOR over EXECUTE statement
# SQL function "runtests" statement 1
not ok 6 - whatever.testplpgsqldie
# Failed test 6: "whatever.testplpgsqldie"
# Subtest: whatever.testthis()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
ok 4 - simple pass
ok 5 - another simple pass
ok 6 - teardown
ok 7 - teardown more
1..7
ok 7 - whatever.testthis
# Subtest: whatever.testy()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
not ok 4 - this test intentionally fails
# Failed test 4: "this test intentionally fails"
ok 5 - teardown
ok 6 - teardown more
1..6
# Looks like you failed 1 test of 6
not ok 8 - whatever.testy
# Failed test 8: "whatever.testy"
# Subtest: whatever.testz()
ok 1 - setup
ok 2 - Should be nothing in the test table
ok 3 - setup more
ok 4 - Late test should find nothing in the test table
ok 5 - teardown
ok 6 - teardown more
1..6
ok 9 - whatever.testz
ok 10 - shutting down
ok 11 - shutting down more
1..11
# Looks like you failed 3 tests of 11
|
