\unset ECHO
1..297
ok 1 - has_index() single column should pass
ok 2 - has_index() single column should have the proper description
ok 3 - has_index() single column should have the proper diagnostics
ok 4 - has_index() single column no desc should pass
ok 5 - has_index() single column no desc should have the proper description
ok 6 - has_index() single column no desc should have the proper diagnostics
ok 7 - has_index() hash index should pass
ok 8 - has_index() hash index should have the proper description
ok 9 - has_index() hash index should have the proper diagnostics
ok 10 - has_index() hash index no desc should pass
ok 11 - has_index() hash index no desc should have the proper description
ok 12 - has_index() hash index no desc should have the proper diagnostics
ok 13 - has_index() multi-column should pass
ok 14 - has_index() multi-column should have the proper description
ok 15 - has_index() multi-column should have the proper diagnostics
ok 16 - has_index() multi-column no desc should pass
ok 17 - has_index() multi-column no desc should have the proper description
ok 18 - has_index() multi-column no desc should have the proper diagnostics
ok 19 - has_index() functional should pass
ok 20 - has_index() functional should have the proper description
ok 21 - has_index() functional should have the proper diagnostics
ok 22 - has_index() [functional] should pass
ok 23 - has_index() [functional] should have the proper description
ok 24 - has_index() [functional] should have the proper diagnostics
ok 25 - has_index() [col, expr] should pass
ok 26 - has_index() [col, expr] should have the proper description
ok 27 - has_index() [col, expr] should have the proper diagnostics
ok 28 - has_index() [expr, col, expr] should pass
ok 29 - has_index() [expr, col, expr] should have the proper description
ok 30 - has_index() [expr, col, expr] should have the proper diagnostics
ok 31 - has_index() no cols should pass
ok 32 - has_index() no cols should have the proper description
ok 33 - has_index() no cols should have the proper diagnostics
ok 34 - has_index() hash index should pass
ok 35 - has_index() hash index should have the proper description
ok 36 - has_index() hash index should have the proper diagnostics
ok 37 - has_index() no cols no desc should pass
ok 38 - has_index() no cols no desc should have the proper description
ok 39 - has_index() no cols no desc should have the proper diagnostics
ok 40 - has_index() no cols hash index no desc should pass
ok 41 - has_index() no cols hash index no desc should have the proper description
ok 42 - has_index() no cols hash index no desc should have the proper diagnostics
ok 43 - has_index() no schema single column should pass
ok 44 - has_index() no schema single column should have the proper description
ok 45 - has_index() no schema single column should have the proper diagnostics
ok 46 - has_index() no schema single column no desc should pass
ok 47 - has_index() no schema single column no desc should have the proper description
ok 48 - has_index() no schema single column no desc should have the proper diagnostics
ok 49 - has_index() no schema multi-column should pass
ok 50 - has_index() no schema multi-column should have the proper description
ok 51 - has_index() no schema multi-column should have the proper diagnostics
ok 52 - has_index() no schema multi-column no desc should pass
ok 53 - has_index() no schema multi-column no desc should have the proper description
ok 54 - has_index() no schema multi-column no desc should have the proper diagnostics
ok 55 - has_index() no schema functional should pass
ok 56 - has_index() no schema functional should have the proper description
ok 57 - has_index() no schema functional should have the proper diagnostics
ok 58 - has_index() no schema functional no desc should pass
ok 59 - has_index() no schema functional no desc should have the proper description
ok 60 - has_index() no schema functional no desc should have the proper diagnostics
ok 61 - has_index() no schema or cols should pass
ok 62 - has_index() no schema or cols should have the proper description
ok 63 - has_index() no schema or cols should have the proper diagnostics
ok 64 - has_index() hash index no schema or cols should pass
ok 65 - has_index() hash index no schema or cols should have the proper description
ok 66 - has_index() hash index no schema or cols should have the proper diagnostics
ok 67 - has_index() no schema or cols or desc should pass
ok 68 - has_index() no schema or cols or desc should have the proper description
ok 69 - has_index() no schema or cols or desc should have the proper diagnostics
ok 70 - has_index() hash index no schema or cols or desc should pass
ok 71 - has_index() hash index no schema or cols or desc should have the proper description
ok 72 - has_index() hash index no schema or cols or desc should have the proper diagnostics
ok 73 - has_index() non-existent should fail
ok 74 - has_index() non-existent should have the proper description
ok 75 - has_index() non-existent should have the proper diagnostics
ok 76 - has_index() missing should fail
ok 77 - has_index() missing should have the proper description
ok 78 - has_index() missing should have the proper diagnostics
ok 79 - has_index() invalid should fail
ok 80 - has_index() invalid should have the proper description
ok 81 - has_index() invalid should have the proper diagnostics
ok 82 - has_index() missing column should fail
ok 83 - has_index() missing column should have the proper description
ok 84 - has_index() missing column should have the proper diagnostics
ok 85 - has_index() missing no schema should fail
ok 86 - has_index() missing no schema should have the proper description
ok 87 - has_index() missing no schema should have the proper diagnostics
ok 88 - has_index() invalid no schema should fail
ok 89 - has_index() invalid no schema should have the proper description
ok 90 - has_index() invalid no schema should have the proper diagnostics
ok 91 - has_index() functional fail should fail
ok 92 - has_index() functional fail should have the proper description
ok 93 - has_index() functional fail should have the proper diagnostics
ok 94 - has_index() functional fail no schema should fail
ok 95 - has_index() functional fail no schema should have the proper description
ok 96 - has_index() functional fail no schema should have the proper diagnostics
ok 97 - hasnt_index(schema, table, index, desc) should fail
ok 98 - hasnt_index(schema, table, index, desc) should have the proper description
ok 99 - hasnt_index(schema, table, index, desc) should have the proper diagnostics
ok 100 - hasnt_index(schema, table, index) should fail
ok 101 - hasnt_index(schema, table, index) should have the proper description
ok 102 - hasnt_index(schema, table, index) should have the proper diagnostics
ok 103 - hasnt_index(schema, table, non-index, desc) should pass
ok 104 - hasnt_index(schema, table, non-index, desc) should have the proper description
ok 105 - hasnt_index(schema, table, non-index, desc) should have the proper diagnostics
ok 106 - hasnt_index(schema, table, non-index) should pass
ok 107 - hasnt_index(schema, table, non-index) should have the proper description
ok 108 - hasnt_index(schema, table, non-index) should have the proper diagnostics
ok 109 - hasnt_index(table, index, desc) should fail
ok 110 - hasnt_index(table, index, desc) should have the proper description
ok 111 - hasnt_index(table, index, desc) should have the proper diagnostics
ok 112 - hasnt_index(table, index) should fail
ok 113 - hasnt_index(table, index) should have the proper description
ok 114 - hasnt_index(table, index) should have the proper diagnostics
ok 115 - hasnt_index(table, non-index, desc) should pass
ok 116 - hasnt_index(table, non-index, desc) should have the proper description
ok 117 - hasnt_index(table, non-index, desc) should have the proper diagnostics
ok 118 - hasnt_index(table, non-index) should pass
ok 119 - hasnt_index(table, non-index) should have the proper description
ok 120 - hasnt_index(table, non-index) should have the proper diagnostics
ok 121 - index_is_unique() should pass
ok 122 - index_is_unique() should have the proper description
ok 123 - index_is_unique() should have the proper diagnostics
ok 124 - index_is_unique() no desc should pass
ok 125 - index_is_unique() no desc should have the proper description
ok 126 - index_is_unique() no desc should have the proper diagnostics
ok 127 - index_is_unique() no schema should pass
ok 128 - index_is_unique() no schema should have the proper description
ok 129 - index_is_unique() no schema should have the proper diagnostics
ok 130 - index_is_unique() index only should pass
ok 131 - index_is_unique() index only should have the proper description
ok 132 - index_is_unique() index only should have the proper diagnostics
ok 133 - index_is_unique() on pk should pass
ok 134 - index_is_unique() on pk should have the proper description
ok 135 - index_is_unique() on pk should have the proper diagnostics
ok 136 - index_is_unique() on pk no desc should pass
ok 137 - index_is_unique() on pk no desc should have the proper description
ok 138 - index_is_unique() on pk no desc should have the proper diagnostics
ok 139 - index_is_unique() on pk no schema should pass
ok 140 - index_is_unique() on pk no schema should have the proper description
ok 141 - index_is_unique() on pk no schema should have the proper diagnostics
ok 142 - index_is_unique() on pk index only should pass
ok 143 - index_is_unique() on pk index only should have the proper description
ok 144 - index_is_unique() on pk index only should have the proper diagnostics
ok 145 - index_is_unique() fail should fail
ok 146 - index_is_unique() fail should have the proper description
ok 147 - index_is_unique() fail should have the proper diagnostics
ok 148 - index_is_unique() fail no desc should fail
ok 149 - index_is_unique() fail no desc should have the proper description
ok 150 - index_is_unique() fail no desc should have the proper diagnostics
ok 151 - index_is_unique() fail no schema should fail
ok 152 - index_is_unique() fail no schema should have the proper description
ok 153 - index_is_unique() fail no schema should have the proper diagnostics
ok 154 - index_is_unique() fail index only should fail
ok 155 - index_is_unique() fail index only should have the proper description
ok 156 - index_is_unique() fail index only should have the proper diagnostics
ok 157 - index_is_unique() no such index should fail
ok 158 - index_is_unique() no such index should have the proper description
ok 159 - index_is_unique() no such index should have the proper diagnostics
ok 160 - index_is_primary() should pass
ok 161 - index_is_primary() should have the proper description
ok 162 - index_is_primary() should have the proper diagnostics
ok 163 - index_is_primary() no desc should pass
ok 164 - index_is_primary() no desc should have the proper description
ok 165 - index_is_primary() no desc should have the proper diagnostics
ok 166 - index_is_primary() no schema should pass
ok 167 - index_is_primary() no schema should have the proper description
ok 168 - index_is_primary() no schema should have the proper diagnostics
ok 169 - index_is_primary() index only should pass
ok 170 - index_is_primary() index only should have the proper description
ok 171 - index_is_primary() index only should have the proper diagnostics
ok 172 - index_is_primary() fail should fail
ok 173 - index_is_primary() fail should have the proper description
ok 174 - index_is_primary() fail should have the proper diagnostics
ok 175 - index_is_primary() fail no desc should fail
ok 176 - index_is_primary() fail no desc should have the proper description
ok 177 - index_is_primary() fail no desc should have the proper diagnostics
ok 178 - index_is_primary() fail no schema should fail
ok 179 - index_is_primary() fail no schema should have the proper description
ok 180 - index_is_primary() fail no schema should have the proper diagnostics
ok 181 - index_is_primary() fail index only should fail
ok 182 - index_is_primary() fail index only should have the proper description
ok 183 - index_is_primary() fail index only should have the proper diagnostics
ok 184 - index_is_primary() no such index should fail
ok 185 - index_is_primary() no such index should have the proper description
ok 186 - index_is_primary() no such index should have the proper diagnostics
ok 187 - index_is_partial() should pass
ok 188 - index_is_partial() should have the proper description
ok 189 - index_is_partial() should have the proper diagnostics
ok 190 - index_is_partial() no desc should pass
ok 191 - index_is_partial() no desc should have the proper description
ok 192 - index_is_partial() no desc should have the proper diagnostics
ok 193 - index_is_partial() no schema should pass
ok 194 - index_is_partial() no schema should have the proper description
ok 195 - index_is_partial() no schema should have the proper diagnostics
ok 196 - index_is_partial() index only should pass
ok 197 - index_is_partial() index only should have the proper description
ok 198 - index_is_partial() index only should have the proper diagnostics
ok 199 - index_is_partial() fail should fail
ok 200 - index_is_partial() fail should have the proper description
ok 201 - index_is_partial() fail should have the proper diagnostics
ok 202 - index_is_partial() fail no desc should fail
ok 203 - index_is_partial() fail no desc should have the proper description
ok 204 - index_is_partial() fail no desc should have the proper diagnostics
ok 205 - index_is_partial() fail no schema should fail
ok 206 - index_is_partial() fail no schema should have the proper description
ok 207 - index_is_partial() fail no schema should have the proper diagnostics
ok 208 - index_is_partial() fail index only should fail
ok 209 - index_is_partial() fail index only should have the proper description
ok 210 - index_is_partial() fail index only should have the proper diagnostics
ok 211 - index_is_partial() no such index should fail
ok 212 - index_is_partial() no such index should have the proper description
ok 213 - index_is_partial() no such index should have the proper diagnostics
ok 214 - is_clustered() fail should fail
ok 215 - is_clustered() fail should have the proper description
ok 216 - is_clustered() fail should have the proper diagnostics
ok 217 - is_clustered() fail no desc should fail
ok 218 - is_clustered() fail no desc should have the proper description
ok 219 - is_clustered() fail no desc should have the proper diagnostics
ok 220 - is_clustered() fail no schema should fail
ok 221 - is_clustered() fail no schema should have the proper description
ok 222 - is_clustered() fail no schema should have the proper diagnostics
ok 223 - is_clustered() fail index only should fail
ok 224 - is_clustered() fail index only should have the proper description
ok 225 - is_clustered() fail index only should have the proper diagnostics
ok 226 - is_clustered() should pass
ok 227 - is_clustered() should have the proper description
ok 228 - is_clustered() should have the proper diagnostics
ok 229 - is_clustered() no desc should pass
ok 230 - is_clustered() no desc should have the proper description
ok 231 - is_clustered() no desc should have the proper diagnostics
ok 232 - is_clustered() no schema should pass
ok 233 - is_clustered() no schema should have the proper description
ok 234 - is_clustered() no schema should have the proper diagnostics
ok 235 - is_clustered() index only should pass
ok 236 - is_clustered() index only should have the proper description
ok 237 - is_clustered() index only should have the proper diagnostics
ok 238 - index_is_type() should pass
ok 239 - index_is_type() should have the proper description
ok 240 - index_is_type() should have the proper diagnostics
ok 241 - index_is_type() no desc should pass
ok 242 - index_is_type() no desc should have the proper description
ok 243 - index_is_type() no desc should have the proper diagnostics
ok 244 - index_is_type() fail should fail
ok 245 - index_is_type() fail should have the proper description
ok 246 - index_is_type() fail should have the proper diagnostics
ok 247 - index_is_type() no schema should pass
ok 248 - index_is_type() no schema should have the proper description
ok 249 - index_is_type() no schema should have the proper diagnostics
ok 250 - index_is_type() no schema fail should fail
ok 251 - index_is_type() no schema fail should have the proper description
ok 252 - index_is_type() no schema fail should have the proper diagnostics
ok 253 - index_is_type() no table should pass
ok 254 - index_is_type() no table should have the proper description
ok 255 - index_is_type() no table should have the proper diagnostics
ok 256 - index_is_type() no table fail should fail
ok 257 - index_is_type() no table fail should have the proper description
ok 258 - index_is_type() no table fail should have the proper diagnostics
ok 259 - index_is_type() hash should pass
ok 260 - index_is_type() hash should have the proper description
ok 261 - index_is_type() hash should have the proper diagnostics
ok 262 - is_indexed( schema, table, columns[], description ) should pass
ok 263 - is_indexed( schema, table, columns[], description ) should have the proper description
ok 264 - is_indexed( schema, table, columns[], description ) should have the proper diagnostics
ok 265 - is_indexed( schema, table, columns[] ) should pass
ok 266 - is_indexed( schema, table, columns[] ) should have the proper description
ok 267 - is_indexed( schema, table, columns[] ) should have the proper diagnostics
ok 268 - is_indexed( table, columns[], description ) should pass
ok 269 - is_indexed( table, columns[], description ) should have the proper description
ok 270 - is_indexed( table, columns[], description ) should have the proper diagnostics
ok 271 - is_indexed( table, columns[] ) should pass
ok 272 - is_indexed( table, columns[] ) should have the proper description
ok 273 - is_indexed( table, columns[] ) should have the proper diagnostics
ok 274 - is_indexed( schema, table, column, description ) should pass
ok 275 - is_indexed( schema, table, column, description ) should have the proper description
ok 276 - is_indexed( schema, table, column, description ) should have the proper diagnostics
ok 277 - is_indexed( schema, table, column ) should pass
ok 278 - is_indexed( schema, table, column ) should have the proper description
ok 279 - is_indexed( schema, table, column ) should have the proper diagnostics
ok 280 - is_indexed( schema, table, column ) fail should fail
ok 281 - is_indexed( schema, table, column ) fail should have the proper description
ok 282 - is_indexed( schema, table, column ) fail should have the proper diagnostics
ok 283 - is_indexed( schema, table, columns[] ) fail, column order matters should fail
ok 284 - is_indexed( schema, table, columns[] ) fail, column order matters should have the proper description
ok 285 - is_indexed( schema, table, columns[] ) fail, column order matters should have the proper diagnostics
ok 286 - is_indexed(schema, table, expressions) should pass
ok 287 - is_indexed(schema, table, expressions) should have the proper description
ok 288 - is_indexed(schema, table, expressions) should have the proper diagnostics
ok 289 - is_indexed(schema, table, expression) should pass
ok 290 - is_indexed(schema, table, expression) should have the proper description
ok 291 - is_indexed(schema, table, expression) should have the proper diagnostics
ok 292 - is_indexed(table, expressions) should pass
ok 293 - is_indexed(table, expressions) should have the proper description
ok 294 - is_indexed(table, expressions) should have the proper diagnostics
ok 295 - is_indexed( table, expression) should pass
ok 296 - is_indexed( table, expression) should have the proper description
ok 297 - is_indexed( table, expression) should have the proper diagnostics