File: coltap.out

package info (click to toggle)
pgtap 1.3.4-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 2,792 kB
  • sloc: sql: 25,795; sh: 790; makefile: 287; perl: 175
file content (278 lines) | stat: -rw-r--r-- 20,781 bytes parent folder | download | duplicates (2)
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
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
\unset ECHO
1..276
ok 1 - col_not_null( sch, tab, col, desc ) should pass
ok 2 - col_not_null( sch, tab, col, desc ) should have the proper description
ok 3 - col_not_null( sch, tab, col, desc ) should have the proper diagnostics
ok 4 - col_not_null( sch, tab, col::name ) should pass
ok 5 - col_not_null( sch, tab, col::name ) should have the proper description
ok 6 - col_not_null( sch, tab, col::name ) should have the proper diagnostics
ok 7 - col_not_null( tab, col, desc ) should pass
ok 8 - col_not_null( tab, col, desc ) should have the proper description
ok 9 - col_not_null( tab, col, desc ) should have the proper diagnostics
ok 10 - col_not_null( table, column ) should pass
ok 11 - col_not_null( table, column ) should have the proper description
ok 12 - col_not_null( table, column ) should have the proper diagnostics
ok 13 - col_not_null( table, column ) fail should fail
ok 14 - col_not_null( table, column ) fail should have the proper description
ok 15 - col_not_null( table, column ) fail should have the proper diagnostics
ok 16 - col_not_null( sch, tab, noncol, desc ) should fail
ok 17 - col_not_null( sch, tab, noncol, desc ) should have the proper description
ok 18 - col_not_null( sch, tab, noncol, desc ) should have the proper diagnostics
ok 19 - col_not_null( table, noncolumn ) fail should fail
ok 20 - col_not_null( table, noncolumn ) fail should have the proper description
ok 21 - col_not_null( table, noncolumn ) fail should have the proper diagnostics
ok 22 - col_is_null( sch, tab, col, desc ) should pass
ok 23 - col_is_null( sch, tab, col, desc ) should have the proper description
ok 24 - col_is_null( sch, tab, col, desc ) should have the proper diagnostics
ok 25 - col_is_null( sch, tab, col::name ) should pass
ok 26 - col_is_null( sch, tab, col::name ) should have the proper description
ok 27 - col_is_null( sch, tab, col::name ) should have the proper diagnostics
ok 28 - col_is_null( tab, col, desc ) should pass
ok 29 - col_is_null( tab, col, desc ) should have the proper description
ok 30 - col_is_null( tab, col, desc ) should have the proper diagnostics
ok 31 - col_is_null( tab, col ) should pass
ok 32 - col_is_null( tab, col ) should have the proper description
ok 33 - col_is_null( tab, col ) should have the proper diagnostics
ok 34 - col_is_null( tab, col ) fail should fail
ok 35 - col_is_null( tab, col ) fail should have the proper description
ok 36 - col_is_null( tab, col ) fail should have the proper diagnostics
ok 37 - col_is_null( sch, tab, noncol, desc ) should fail
ok 38 - col_is_null( sch, tab, noncol, desc ) should have the proper description
ok 39 - col_is_null( sch, tab, noncol, desc ) should have the proper diagnostics
ok 40 - col_is_null( table, noncolumn ) fail should fail
ok 41 - col_is_null( table, noncolumn ) fail should have the proper description
ok 42 - col_is_null( table, noncolumn ) fail should have the proper diagnostics
ok 43 - col_type_is( sch, tab, col, sch, type, desc ) should pass
ok 44 - col_type_is( sch, tab, col, sch, type, desc ) should have the proper description
ok 45 - col_type_is( sch, tab, col, sch, type, desc ) should have the proper diagnostics
ok 46 - col_type_is( sch, tab, col, sch, type, desc ) should pass
ok 47 - col_type_is( sch, tab, col, sch, type, desc ) should have the proper description
ok 48 - col_type_is( sch, tab, col, sch, type, desc ) should have the proper diagnostics
ok 49 - col_type_is( sch, tab, myNum, sch, type, desc ) should pass
ok 50 - col_type_is( sch, tab, myNum, sch, type, desc ) should have the proper description
ok 51 - col_type_is( sch, tab, myNum, sch, type, desc ) should have the proper diagnostics
ok 52 - col_type_is( sch, tab, myNum, sch, type, desc ) should pass
ok 53 - col_type_is( sch, tab, myNum, sch, type, desc ) should have the proper description
ok 54 - col_type_is( sch, tab, myNum, sch, type, desc ) should have the proper diagnostics
ok 55 - col_type_is( sch, tab, camel, sch, type, desc ) should pass
ok 56 - col_type_is( sch, tab, camel, sch, type, desc ) should have the proper description
ok 57 - col_type_is( sch, tab, camel, sch, type, desc ) should have the proper diagnostics
ok 58 - col_type_is( sch, tab, camel, sch, type ) should pass
ok 59 - col_type_is( sch, tab, camel, sch, type ) should have the proper description
ok 60 - col_type_is( sch, tab, camel, sch, type ) should have the proper diagnostics
ok 61 - col_type_is( sch, tab, camel, type, desc ) should pass
ok 62 - col_type_is( sch, tab, camel, type, desc ) should have the proper description
ok 63 - col_type_is( sch, tab, camel, type, desc ) should have the proper diagnostics
ok 64 - col_type_is( sch, tab, interval, sch, type, desc ) should pass
ok 65 - col_type_is( sch, tab, interval, sch, type, desc ) should have the proper description
ok 66 - col_type_is( sch, tab, interval, sch, type, desc ) should have the proper diagnostics
ok 67 - col_type_is( sch, tab, interval, sch, type, desc ) should pass
ok 68 - col_type_is( sch, tab, interval, sch, type, desc ) should have the proper description
ok 69 - col_type_is( sch, tab, interval, sch, type, desc ) should have the proper diagnostics
ok 70 - col_type_is( sch, tab, inval, type, desc ) should pass
ok 71 - col_type_is( sch, tab, inval, type, desc ) should have the proper description
ok 72 - col_type_is( sch, tab, inval, type, desc ) should have the proper diagnostics
ok 73 - col_type_is( sch, tab, intsec, sch, type, desc ) should pass
ok 74 - col_type_is( sch, tab, intsec, sch, type, desc ) should have the proper description
ok 75 - col_type_is( sch, tab, intsec, sch, type, desc ) should have the proper diagnostics
ok 76 - col_type_is( sch, tab, interval, sch, type, desc ) should pass
ok 77 - col_type_is( sch, tab, interval, sch, type, desc ) should have the proper description
ok 78 - col_type_is( sch, tab, interval, sch, type, desc ) should have the proper diagnostics
ok 79 - col_type_is( sch, tab, inval, type, desc ) should pass
ok 80 - col_type_is( sch, tab, inval, type, desc ) should have the proper description
ok 81 - col_type_is( sch, tab, inval, type, desc ) should have the proper diagnostics
ok 82 - col_type_is( sch, tab, stuff, sch, type, desc ) should pass
ok 83 - col_type_is( sch, tab, stuff, sch, type, desc ) should have the proper description
ok 84 - col_type_is( sch, tab, stuff, sch, type, desc ) should have the proper diagnostics
ok 85 - col_type_is( sch, tab, stuff, sch, type, desc ) should pass
ok 86 - col_type_is( sch, tab, stuff, sch, type, desc ) should have the proper description
ok 87 - col_type_is( sch, tab, stuff, sch, type, desc ) should have the proper diagnostics
ok 88 - col_type_is( sch, tab, col, sch, type, desc ) fail should fail
ok 89 - col_type_is( sch, tab, col, sch, type, desc ) fail should have the proper description
ok 90 - col_type_is( sch, tab, col, sch, type, desc ) fail should have the proper diagnostics
ok 91 - col_type_is( sch, tab, col, sch, non-type, desc ) should fail
ok 92 - col_type_is( sch, tab, col, sch, non-type, desc ) should have the proper description
ok 93 - col_type_is( sch, tab, col, sch, non-type, desc ) should have the proper diagnostics
ok 94 - col_type_is( sch, tab, col, non-sch, type, desc ) should fail
ok 95 - col_type_is( sch, tab, col, non-sch, type, desc ) should have the proper description
ok 96 - col_type_is( sch, tab, col, non-sch, type, desc ) should have the proper diagnostics
ok 97 - col_type_is( sch, tab, col, non-sch, type, desc ) should fail
ok 98 - col_type_is( sch, tab, col, non-sch, type, desc ) should have the proper description
ok 99 - col_type_is( sch, tab, col, non-sch, type, desc ) should have the proper diagnostics
ok 100 - col_type_is( sch, tab, col, non-type, desc ) should fail
ok 101 - col_type_is( sch, tab, col, non-type, desc ) should have the proper description
ok 102 - col_type_is( sch, tab, col, non-type, desc ) should have the proper diagnostics
ok 103 - col_type_is( tab, col, non-type, desc ) should fail
ok 104 - col_type_is( tab, col, non-type, desc ) should have the proper description
ok 105 - col_type_is( tab, col, non-type, desc ) should have the proper diagnostics
ok 106 - col_type_is( sch, tab, non-col, sch, type, desc ) should fail
ok 107 - col_type_is( sch, tab, non-col, sch, type, desc ) should have the proper description
ok 108 - col_type_is( sch, tab, non-col, sch, type, desc ) should have the proper diagnostics
ok 109 - col_type_is( sch, tab, col, type, desc ) should pass
ok 110 - col_type_is( sch, tab, col, type, desc ) should have the proper description
ok 111 - col_type_is( sch, tab, col, type, desc ) should have the proper diagnostics
ok 112 - col_type_is( sch, tab, col, type ) should pass
ok 113 - col_type_is( sch, tab, col, type ) should have the proper description
ok 114 - col_type_is( sch, tab, col, type ) should have the proper diagnostics
ok 115 - col_type_is( tab, col, type, desc ) should pass
ok 116 - col_type_is( tab, col, type, desc ) should have the proper description
ok 117 - col_type_is( tab, col, type, desc ) should have the proper diagnostics
ok 118 - col_type_is( tab, col, type ) should pass
ok 119 - col_type_is( tab, col, type ) should have the proper description
ok 120 - col_type_is( tab, col, type ) should have the proper diagnostics
ok 121 - col_type_is( tab, col, type ) fail should fail
ok 122 - col_type_is( tab, col, type ) fail should have the proper description
ok 123 - col_type_is( tab, col, type ) fail should have the proper diagnostics
ok 124 - col_type_is( tab, noncol, type ) fail should fail
ok 125 - col_type_is( tab, noncol, type ) fail should have the proper description
ok 126 - col_type_is( tab, noncol, type ) fail should have the proper diagnostics
ok 127 - col_type_is( sch, tab, noncol, type, desc ) fail should fail
ok 128 - col_type_is( sch, tab, noncol, type, desc ) fail should have the proper description
ok 129 - col_type_is( sch, tab, noncol, type, desc ) fail should have the proper diagnostics
ok 130 - col_type_is with precision should pass
ok 131 - col_type_is with precision should have the proper description
ok 132 - col_type_is with precision should have the proper diagnostics
ok 133 - col_type_is precision fail should fail
ok 134 - col_type_is precision fail should have the proper description
ok 135 - col_type_is precision fail should have the proper diagnostics
ok 136 - col_has_default( sch, tab, col, desc ) should pass
ok 137 - col_has_default( sch, tab, col, desc ) should have the proper description
ok 138 - col_has_default( sch, tab, col, desc ) should have the proper diagnostics
ok 139 - col_has_default( tab, col, desc ) should pass
ok 140 - col_has_default( tab, col, desc ) should have the proper description
ok 141 - col_has_default( tab, col, desc ) should have the proper diagnostics
ok 142 - col_has_default( tab, col ) should pass
ok 143 - col_has_default( tab, col ) should have the proper description
ok 144 - col_has_default( tab, col ) should have the proper diagnostics
ok 145 - col_has_default( sch, tab, col, desc ) should fail
ok 146 - col_has_default( sch, tab, col, desc ) should have the proper description
ok 147 - col_has_default( sch, tab, col, desc ) should have the proper diagnostics
ok 148 - col_has_default( tab, col, desc ) should fail
ok 149 - col_has_default( tab, col, desc ) should have the proper description
ok 150 - col_has_default( tab, col, desc ) should have the proper diagnostics
ok 151 - col_has_default( tab, col ) should fail
ok 152 - col_has_default( tab, col ) should have the proper description
ok 153 - col_has_default( tab, col ) should have the proper diagnostics
ok 154 - col_has_default( sch, tab, col, desc ) should fail
ok 155 - col_has_default( sch, tab, col, desc ) should have the proper description
ok 156 - col_has_default( sch, tab, col, desc ) should have the proper diagnostics
ok 157 - col_has_default( tab, col, desc ) should fail
ok 158 - col_has_default( tab, col, desc ) should have the proper description
ok 159 - col_has_default( tab, col, desc ) should have the proper diagnostics
ok 160 - col_has_default( tab, col ) should fail
ok 161 - col_has_default( tab, col ) should have the proper description
ok 162 - col_has_default( tab, col ) should have the proper diagnostics
ok 163 - col_hasnt_default( sch, tab, col, desc ) should fail
ok 164 - col_hasnt_default( sch, tab, col, desc ) should have the proper description
ok 165 - col_hasnt_default( sch, tab, col, desc ) should have the proper diagnostics
ok 166 - col_hasnt_default( tab, col, desc ) should fail
ok 167 - col_hasnt_default( tab, col, desc ) should have the proper description
ok 168 - col_hasnt_default( tab, col, desc ) should have the proper diagnostics
ok 169 - col_hasnt_default( tab, col ) should fail
ok 170 - col_hasnt_default( tab, col ) should have the proper description
ok 171 - col_hasnt_default( tab, col ) should have the proper diagnostics
ok 172 - col_hasnt_default( sch, tab, col, desc ) should pass
ok 173 - col_hasnt_default( sch, tab, col, desc ) should have the proper description
ok 174 - col_hasnt_default( sch, tab, col, desc ) should have the proper diagnostics
ok 175 - col_hasnt_default( tab, col, desc ) should pass
ok 176 - col_hasnt_default( tab, col, desc ) should have the proper description
ok 177 - col_hasnt_default( tab, col, desc ) should have the proper diagnostics
ok 178 - col_hasnt_default( tab, col ) should pass
ok 179 - col_hasnt_default( tab, col ) should have the proper description
ok 180 - col_hasnt_default( tab, col ) should have the proper diagnostics
ok 181 - col_hasnt_default( sch, tab, col, desc ) should fail
ok 182 - col_hasnt_default( sch, tab, col, desc ) should have the proper description
ok 183 - col_hasnt_default( sch, tab, col, desc ) should have the proper diagnostics
ok 184 - col_hasnt_default( tab, col, desc ) should fail
ok 185 - col_hasnt_default( tab, col, desc ) should have the proper description
ok 186 - col_hasnt_default( tab, col, desc ) should have the proper diagnostics
ok 187 - col_hasnt_default( tab, col ) should fail
ok 188 - col_hasnt_default( tab, col ) should have the proper description
ok 189 - col_hasnt_default( tab, col ) should have the proper diagnostics
ok 190 - col_default_is( sch, tab, col, def, desc ) should pass
ok 191 - col_default_is( sch, tab, col, def, desc ) should have the proper description
ok 192 - col_default_is( sch, tab, col, def, desc ) should have the proper diagnostics
ok 193 - col_default_is() fail should fail
ok 194 - col_default_is() fail should have the proper description
ok 195 - col_default_is() fail should have the proper diagnostics
ok 196 - col_default_is( tab, col, def, desc ) should pass
ok 197 - col_default_is( tab, col, def, desc ) should have the proper description
ok 198 - col_default_is( tab, col, def, desc ) should have the proper diagnostics
ok 199 - col_default_is( tab, col, def ) should pass
ok 200 - col_default_is( tab, col, def ) should have the proper description
ok 201 - col_default_is( tab, col, def ) should have the proper diagnostics
ok 202 - col_default_is( tab, col, int ) should pass
ok 203 - col_default_is( tab, col, int ) should have the proper description
ok 204 - col_default_is( tab, col, int ) should have the proper diagnostics
ok 205 - col_default_is( tab, col, NULL, desc ) should pass
ok 206 - col_default_is( tab, col, NULL, desc ) should have the proper description
ok 207 - col_default_is( tab, col, NULL, desc ) should have the proper diagnostics
ok 208 - col_default_is( tab, col, NULL ) should pass
ok 209 - col_default_is( tab, col, NULL ) should have the proper description
ok 210 - col_default_is( tab, col, NULL ) should have the proper diagnostics
ok 211 - col_default_is( tab, col, bogus, desc ) should fail
ok 212 - col_default_is( tab, col, bogus, desc ) should have the proper description
ok 213 - col_default_is( tab, col, bogus, desc ) should have the proper diagnostics
ok 214 - col_default_is( tab, col, bogus ) should fail
ok 215 - col_default_is( tab, col, bogus ) should have the proper description
ok 216 - col_default_is( tab, col, bogus ) should have the proper diagnostics
ok 217 - col_default_is( tab, col, expression ) should pass
ok 218 - col_default_is( tab, col, expression ) should have the proper description
ok 219 - col_default_is( tab, col, expression ) should have the proper diagnostics
ok 220 - col_default_is( tab, col, expression::text ) should pass
ok 221 - col_default_is( tab, col, expression::text ) should have the proper description
ok 222 - col_default_is( tab, col, expression::text ) should have the proper diagnostics
ok 223 - col_default_is( tab, col, expression, desc ) should pass
ok 224 - col_default_is( tab, col, expression, desc ) should have the proper description
ok 225 - col_default_is( tab, col, expression, desc ) should have the proper diagnostics
ok 226 - col_default_is( tab, col, expression, desc ) should pass
ok 227 - col_default_is( tab, col, expression, desc ) should have the proper description
ok 228 - col_default_is( tab, col, expression, desc ) should have the proper diagnostics
ok 229 - col_default_is( schema, tab, col, expression, desc ) should pass
ok 230 - col_default_is( schema, tab, col, expression, desc ) should have the proper description
ok 231 - col_default_is( schema, tab, col, expression, desc ) should have the proper diagnostics
ok 232 - col_default_is( schema, tab, col, expression, desc ) should pass
ok 233 - col_default_is( schema, tab, col, expression, desc ) should have the proper description
ok 234 - col_default_is( schema, tab, col, expression, desc ) should have the proper diagnostics
ok 235 - col_default_is( sch, tab, col, def, desc ) should fail
ok 236 - col_default_is( sch, tab, col, def, desc ) should have the proper description
ok 237 - col_default_is( sch, tab, col, def, desc ) should have the proper diagnostics
ok 238 - col_default_is( tab, col, def, desc ) should fail
ok 239 - col_default_is( tab, col, def, desc ) should have the proper description
ok 240 - col_default_is( tab, col, def, desc ) should have the proper diagnostics
ok 241 - col_default_is( tab, col, def ) should fail
ok 242 - col_default_is( tab, col, def ) should have the proper description
ok 243 - col_default_is( tab, col, def ) should have the proper diagnostics
ok 244 - col_default_is( tab, col, CURRENT_CATALOG ) should pass
ok 245 - col_default_is( tab, col, CURRENT_CATALOG ) should have the proper description
ok 246 - col_default_is( tab, col, CURRENT_CATALOG ) should have the proper diagnostics
ok 247 - col_default_is( tab, col, CURRENT_ROLE ) should pass
ok 248 - col_default_is( tab, col, CURRENT_ROLE ) should have the proper description
ok 249 - col_default_is( tab, col, CURRENT_ROLE ) should have the proper diagnostics
ok 250 - col_default_is( tab, col, CURRENT_SCHEMA ) should pass
ok 251 - col_default_is( tab, col, CURRENT_SCHEMA ) should have the proper description
ok 252 - col_default_is( tab, col, CURRENT_SCHEMA ) should have the proper diagnostics
ok 253 - col_default_is( tab, col, CURRENT_USER ) should pass
ok 254 - col_default_is( tab, col, CURRENT_USER ) should have the proper description
ok 255 - col_default_is( tab, col, CURRENT_USER ) should have the proper diagnostics
ok 256 - col_default_is( tab, col, SESSION_USER ) should pass
ok 257 - col_default_is( tab, col, SESSION_USER ) should have the proper description
ok 258 - col_default_is( tab, col, SESSION_USER ) should have the proper diagnostics
ok 259 - col_default_is( tab, col, USER ) should pass
ok 260 - col_default_is( tab, col, USER ) should have the proper description
ok 261 - col_default_is( tab, col, USER ) should have the proper diagnostics
ok 262 - col_default_is( tab, col, CURRENT_DATE ) should pass
ok 263 - col_default_is( tab, col, CURRENT_DATE ) should have the proper description
ok 264 - col_default_is( tab, col, CURRENT_DATE ) should have the proper diagnostics
ok 265 - col_default_is( tab, col, CURRENT_TIME ) should pass
ok 266 - col_default_is( tab, col, CURRENT_TIME ) should have the proper description
ok 267 - col_default_is( tab, col, CURRENT_TIME ) should have the proper diagnostics
ok 268 - col_default_is( tab, col, CURRENT_TIMESTAMP ) should pass
ok 269 - col_default_is( tab, col, CURRENT_TIMESTAMP ) should have the proper description
ok 270 - col_default_is( tab, col, CURRENT_TIMESTAMP ) should have the proper diagnostics
ok 271 - col_default_is( tab, col, LOCALTIME ) should pass
ok 272 - col_default_is( tab, col, LOCALTIME ) should have the proper description
ok 273 - col_default_is( tab, col, LOCALTIME ) should have the proper diagnostics
ok 274 - col_default_is( tab, col, LOCALTIMESTAMP ) should pass
ok 275 - col_default_is( tab, col, LOCALTIMESTAMP ) should have the proper description
ok 276 - col_default_is( tab, col, LOCALTIMESTAMP ) should have the proper diagnostics