| 1 |
# Don't run under valgrind, the big table is really slow to |
| 2 |
# create and drop |
| 3 |
--source include/not_valgrind.inc |
| 4 |
--source include/have_ndb.inc |
| 5 |
|
| 6 |
# big table, 512 columns, 42 blob, 64x2 indices |
| 7 |
|
| 8 |
create table t1 ( |
| 9 |
ci001 int, ci002 int, ci003 int, ci004 int, ci005 int, ci006 int, ci007 int, ci008 int, |
| 10 |
ci009 int, ci010 int, ci011 int, ci012 int, ci013 int, ci014 int, ci015 int, ci016 int, |
| 11 |
ci017 int, ci018 int, ci019 int, ci020 int, ci021 int, ci022 int, ci023 int, ci024 int, |
| 12 |
ci025 int, ci026 int, ci027 int, ci028 int, ci029 int, ci030 int, ci031 int, ci032 int, |
| 13 |
ci033 int, ci034 int, ci035 int, ci036 int, ci037 int, ci038 int, ci039 int, ci040 int, |
| 14 |
ci041 int, ci042 int, ci043 int, ci044 int, ci045 int, ci046 int, ci047 int, ci048 int, |
| 15 |
ci049 int, ci050 int, ci051 int, ci052 int, ci053 int, ci054 int, ci055 int, ci056 int, |
| 16 |
ci057 int, ci058 int, ci059 int, ci060 int, ci061 int, ci062 int, ci063 int, ci064 int, |
| 17 |
ci065 int, ci066 int, ci067 int, ci068 int, ci069 int, ci070 int, ci071 int, ci072 int, |
| 18 |
ci073 int, ci074 int, ci075 int, ci076 int, ci077 int, ci078 int, ci079 int, ci080 int, |
| 19 |
ci081 int, ci082 int, ci083 int, ci084 int, ci085 int, ci086 int, ci087 int, ci088 int, |
| 20 |
ci089 int, ci090 int, ci091 int, ci092 int, ci093 int, ci094 int, ci095 int, ci096 int, |
| 21 |
ci097 int, ci098 int, ci099 int, ci100 int, ci101 int, ci102 int, ci103 int, ci104 int, |
| 22 |
ci105 int, ci106 int, ci107 int, ci108 int, ci109 int, ci110 int, ci111 int, ci112 int, |
| 23 |
ci113 int, ci114 int, ci115 int, ci116 int, ci117 int, ci118 int, ci119 int, ci120 int, |
| 24 |
ci121 int, ci122 int, ci123 int, ci124 int, ci125 int, ci126 int, ci127 int, ci128 int, |
| 25 |
ci129 int, ci130 int, ci131 int, ci132 int, ci133 int, ci134 int, ci135 int, ci136 int, |
| 26 |
ci137 int, ci138 int, ci139 int, ci140 int, ci141 int, ci142 int, ci143 int, ci144 int, |
| 27 |
ci145 int, ci146 int, ci147 int, ci148 int, ci149 int, ci150 int, ci151 int, ci152 int, |
| 28 |
ci153 int, ci154 int, ci155 int, ci156 int, ci157 int, ci158 int, ci159 int, ci160 int, |
| 29 |
ci161 int, ci162 int, ci163 int, ci164 int, ci165 int, ci166 int, ci167 int, ci168 int, |
| 30 |
ci169 int, ci170 int, ci171 int, ci172 int, ci173 int, ci174 int, ci175 int, ci176 int, |
| 31 |
ci177 int, ci178 int, ci179 int, ci180 int, ci181 int, ci182 int, ci183 int, ci184 int, |
| 32 |
ci185 int, ci186 int, ci187 int, ci188 int, ci189 int, ci190 int, ci191 int, ci192 int, |
| 33 |
ci193 int, ci194 int, ci195 int, ci196 int, ci197 int, ci198 int, ci199 int, ci200 int, |
| 34 |
ci201 int, ci202 int, ci203 int, ci204 int, ci205 int, ci206 int, ci207 int, ci208 int, |
| 35 |
ci209 int, ci210 int, ci211 int, ci212 int, ci213 int, ci214 int, ci215 int, ci216 int, |
| 36 |
ci217 int, ci218 int, ci219 int, ci220 int, ci221 int, ci222 int, ci223 int, ci224 int, |
| 37 |
ci225 int, ci226 int, ci227 int, ci228 int, ci229 int, ci230 int, ci231 int, ci232 int, |
| 38 |
ci233 int, ci234 int, ci235 int, ci236 int, ci237 int, ci238 int, ci239 int, ci240 int, |
| 39 |
ci241 int, ci242 int, ci243 int, ci244 int, ci245 int, ci246 int, ci247 int, ci248 int, |
| 40 |
ci249 int, ci250 int, ci251 int, ci252 int, ci253 int, ci254 int, ci255 int, ci256 int, |
| 41 |
ci257 int, ci258 int, ci259 int, ci260 int, ci261 int, ci262 int, ci263 int, ci264 int, |
| 42 |
ci265 int, ci266 int, ci267 int, ci268 int, ci269 int, ci270 int, ci271 int, ci272 int, |
| 43 |
ci273 int, ci274 int, ci275 int, ci276 int, ci277 int, ci278 int, ci279 int, ci280 int, |
| 44 |
ci281 int, ci282 int, ci283 int, ci284 int, ci285 int, ci286 int, ci287 int, ci288 int, |
| 45 |
ci289 int, ci290 int, ci291 int, ci292 int, ci293 int, ci294 int, ci295 int, ci296 int, |
| 46 |
ci297 int, ci298 int, ci299 int, ci300 int, ci301 int, ci302 int, ci303 int, ci304 int, |
| 47 |
ci305 int, ci306 int, ci307 int, ci308 int, ci309 int, ci310 int, ci311 int, ci312 int, |
| 48 |
ci313 int, ci314 int, ci315 int, ci316 int, ci317 int, ci318 int, ci319 int, ci320 int, |
| 49 |
ci321 int, ci322 int, ci323 int, ci324 int, ci325 int, ci326 int, ci327 int, ci328 int, |
| 50 |
ci329 int, ci330 int, ci331 int, ci332 int, ci333 int, ci334 int, ci335 int, ci336 int, |
| 51 |
ci337 int, ci338 int, ci339 int, ci340 int, ci341 int, ci342 int, ci343 int, ci344 int, |
| 52 |
ci345 int, ci346 int, ci347 int, ci348 int, ci349 int, ci350 int, ci351 int, ci352 int, |
| 53 |
ci353 int, ci354 int, ci355 int, ci356 int, ci357 int, ci358 int, ci359 int, ci360 int, |
| 54 |
ci361 int, ci362 int, ci363 int, ci364 int, ci365 int, ci366 int, ci367 int, ci368 int, |
| 55 |
ci369 int, ci370 int, ci371 int, ci372 int, ci373 int, ci374 int, ci375 int, ci376 int, |
| 56 |
ci377 int, ci378 int, ci379 int, ci380 int, ci381 int, ci382 int, ci383 int, ci384 int, |
| 57 |
ci385 int, ci386 int, ci387 int, ci388 int, ci389 int, ci390 int, ci391 int, ci392 int, |
| 58 |
ci393 int, ci394 int, ci395 int, ci396 int, ci397 int, ci398 int, ci399 int, ci400 int, |
| 59 |
ci401 int, ci402 int, ci403 int, ci404 int, ci405 int, ci406 int, ci407 int, ci408 int, |
| 60 |
ci409 int, ci410 int, ci411 int, ci412 int, ci413 int, ci414 int, ci415 int, ci416 int, |
| 61 |
ci417 int, ci418 int, ci419 int, ci420 int, ci421 int, ci422 int, ci423 int, ci424 int, |
| 62 |
ci425 int, ci426 int, ci427 int, ci428 int, ci429 int, ci430 int, ci431 int, ci432 int, |
| 63 |
ci433 int, ci434 int, ci435 int, ci436 int, ci437 int, ci438 int, ci439 int, ci440 int, |
| 64 |
ci441 int, ci442 int, ci443 int, ci444 int, ci445 int, ci446 int, ci447 int, ci448 int, |
| 65 |
ci449 int, ci450 int, ci451 int, ci452 int, ci453 int, ci454 int, ci455 int, ci456 int, |
| 66 |
ci457 int, ci458 int, ci459 int, ci460 int, ci461 int, ci462 int, ci463 int, ci464 int, |
| 67 |
ci465 int, ci466 int, ci467 int, ci468 int, ci469 int, ci470 int, |
| 68 |
cb471 blob, cb472 blob, cb473 blob, cb474 blob, cb475 blob, cb476 blob, cb477 blob, cb478 blob, |
| 69 |
cb479 blob, cb480 blob, cb481 blob, cb482 blob, cb483 blob, cb484 blob, cb485 blob, cb486 blob, |
| 70 |
cb487 blob, cb488 blob, cb489 blob, cb490 blob, cb491 blob, cb492 blob, cb493 blob, cb494 blob, |
| 71 |
cb495 blob, cb496 blob, cb497 blob, cb498 blob, cb499 blob, cb500 blob, cb501 blob, cb502 blob, |
| 72 |
cb503 blob, cb504 blob, cb505 blob, cb506 blob, cb507 blob, cb508 blob, cb509 blob, cb510 blob, |
| 73 |
cb511 blob, cb512 blob, |
| 74 |
primary key (ci001), |
| 75 |
unique i1 (ci002), |
| 76 |
unique i2 (ci003), |
| 77 |
unique i3 (ci004), |
| 78 |
unique i4 (ci005), |
| 79 |
unique i5 (ci006), |
| 80 |
unique i6 (ci007), |
| 81 |
unique i7 (ci008), |
| 82 |
unique i8 (ci009), |
| 83 |
unique i9 (ci010), |
| 84 |
unique i10 (ci011), |
| 85 |
unique i11 (ci012), |
| 86 |
unique i12 (ci013), |
| 87 |
unique i13 (ci014), |
| 88 |
unique i14 (ci015), |
| 89 |
unique i15 (ci016), |
| 90 |
unique i16 (ci017), |
| 91 |
unique i17 (ci018), |
| 92 |
unique i18 (ci019), |
| 93 |
unique i19 (ci020), |
| 94 |
unique i20 (ci021), |
| 95 |
unique i21 (ci022), |
| 96 |
unique i22 (ci023), |
| 97 |
unique i23 (ci024), |
| 98 |
unique i24 (ci025), |
| 99 |
unique i25 (ci026), |
| 100 |
unique i26 (ci027), |
| 101 |
unique i27 (ci028), |
| 102 |
unique i28 (ci029), |
| 103 |
unique i29 (ci030), |
| 104 |
unique i30 (ci031), |
| 105 |
unique i31 (ci032), |
| 106 |
unique i32 (ci033), |
| 107 |
unique i33 (ci034), |
| 108 |
unique i34 (ci035), |
| 109 |
unique i35 (ci036), |
| 110 |
unique i36 (ci037), |
| 111 |
unique i37 (ci038), |
| 112 |
unique i38 (ci039), |
| 113 |
unique i39 (ci040), |
| 114 |
unique i40 (ci041), |
| 115 |
unique i41 (ci042), |
| 116 |
unique i42 (ci043), |
| 117 |
unique i43 (ci044), |
| 118 |
unique i44 (ci045), |
| 119 |
unique i45 (ci046), |
| 120 |
unique i46 (ci047), |
| 121 |
unique i47 (ci048), |
| 122 |
unique i48 (ci049), |
| 123 |
unique i49 (ci050), |
| 124 |
unique i50 (ci051), |
| 125 |
unique i51 (ci052), |
| 126 |
unique i52 (ci053), |
| 127 |
unique i53 (ci054), |
| 128 |
unique i54 (ci055), |
| 129 |
unique i55 (ci056), |
| 130 |
unique i56 (ci057), |
| 131 |
unique i57 (ci058), |
| 132 |
unique i58 (ci059), |
| 133 |
unique i59 (ci060), |
| 134 |
unique i60 (ci061), |
| 135 |
unique i61 (ci062), |
| 136 |
unique i62 (ci063), |
| 137 |
unique i63 (ci064) |
| 138 |
) engine=ndb charset=latin1; |
| 139 |
drop table t1; |