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
|