| 1 |
|
| 2 |
--source include/have_optimizer_trace.inc |
| 3 |
--source include/have_64bit.inc |
| 4 |
--source include/not_hypergraph.inc # Does not output the same optimizer trace. |
| 5 |
|
| 6 |
# Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled |
| 7 |
--source include/no_protocol.inc |
| 8 |
|
| 9 |
SET optimizer_trace_max_mem_size=1048576; # 1MB |
| 10 |
SET end_markers_in_json=off; |
| 11 |
SET optimizer_trace="enabled=on,one_line=off"; |
| 12 |
|
| 13 |
|
| 14 |
## Each column here takes 1022 bytes, plus 2 bytes length field. |
| 15 |
## Except the last column, which is one byte shorter. |
| 16 |
## Total record size is 65535 which is the MySQL maximum. |
| 17 |
CREATE TABLE t1 ( |
| 18 |
c1 VARCHAR(1022) NOT NULL DEFAULT '', |
| 19 |
c2 VARCHAR(1022) NOT NULL DEFAULT '', |
| 20 |
c3 VARCHAR(1022) NOT NULL DEFAULT '', |
| 21 |
c4 VARCHAR(1022) NOT NULL DEFAULT '', |
| 22 |
c5 VARCHAR(1022) NOT NULL DEFAULT '', |
| 23 |
c6 VARCHAR(1022) NOT NULL DEFAULT '', |
| 24 |
c7 VARCHAR(1022) NOT NULL DEFAULT '', |
| 25 |
c8 VARCHAR(1022) NOT NULL DEFAULT '', |
| 26 |
c9 VARCHAR(1022) NOT NULL DEFAULT '', |
| 27 |
c10 VARCHAR(1022) NOT NULL DEFAULT '', |
| 28 |
c11 VARCHAR(1022) NOT NULL DEFAULT '', |
| 29 |
c12 VARCHAR(1022) NOT NULL DEFAULT '', |
| 30 |
c13 VARCHAR(1022) NOT NULL DEFAULT '', |
| 31 |
c14 VARCHAR(1022) NOT NULL DEFAULT '', |
| 32 |
c15 VARCHAR(1022) NOT NULL DEFAULT '', |
| 33 |
c16 VARCHAR(1022) NOT NULL DEFAULT '', |
| 34 |
c17 VARCHAR(1022) NOT NULL DEFAULT '', |
| 35 |
c18 VARCHAR(1022) NOT NULL DEFAULT '', |
| 36 |
c19 VARCHAR(1022) NOT NULL DEFAULT '', |
| 37 |
c20 VARCHAR(1022) NOT NULL DEFAULT '', |
| 38 |
c21 VARCHAR(1022) NOT NULL DEFAULT '', |
| 39 |
c22 VARCHAR(1022) NOT NULL DEFAULT '', |
| 40 |
c23 VARCHAR(1022) NOT NULL DEFAULT '', |
| 41 |
c24 VARCHAR(1022) NOT NULL DEFAULT '', |
| 42 |
c25 VARCHAR(1022) NOT NULL DEFAULT '', |
| 43 |
c26 VARCHAR(1022) NOT NULL DEFAULT '', |
| 44 |
c27 VARCHAR(1022) NOT NULL DEFAULT '', |
| 45 |
c28 VARCHAR(1022) NOT NULL DEFAULT '', |
| 46 |
c29 VARCHAR(1022) NOT NULL DEFAULT '', |
| 47 |
c30 VARCHAR(1022) NOT NULL DEFAULT '', |
| 48 |
c31 VARCHAR(1022) NOT NULL DEFAULT '', |
| 49 |
c32 VARCHAR(1022) NOT NULL DEFAULT '', |
| 50 |
c33 VARCHAR(1022) NOT NULL DEFAULT '', |
| 51 |
c34 VARCHAR(1022) NOT NULL DEFAULT '', |
| 52 |
c35 VARCHAR(1022) NOT NULL DEFAULT '', |
| 53 |
c36 VARCHAR(1022) NOT NULL DEFAULT '', |
| 54 |
c37 VARCHAR(1022) NOT NULL DEFAULT '', |
| 55 |
c38 VARCHAR(1022) NOT NULL DEFAULT '', |
| 56 |
c39 VARCHAR(1022) NOT NULL DEFAULT '', |
| 57 |
c40 VARCHAR(1022) NOT NULL DEFAULT '', |
| 58 |
c41 VARCHAR(1022) NOT NULL DEFAULT '', |
| 59 |
c42 VARCHAR(1022) NOT NULL DEFAULT '', |
| 60 |
c43 VARCHAR(1022) NOT NULL DEFAULT '', |
| 61 |
c44 VARCHAR(1022) NOT NULL DEFAULT '', |
| 62 |
c45 VARCHAR(1022) NOT NULL DEFAULT '', |
| 63 |
c46 VARCHAR(1022) NOT NULL DEFAULT '', |
| 64 |
c47 VARCHAR(1022) NOT NULL DEFAULT '', |
| 65 |
c48 VARCHAR(1022) NOT NULL DEFAULT '', |
| 66 |
c49 VARCHAR(1022) NOT NULL DEFAULT '', |
| 67 |
c50 VARCHAR(1022) NOT NULL DEFAULT '', |
| 68 |
c51 VARCHAR(1022) NOT NULL DEFAULT '', |
| 69 |
c52 VARCHAR(1022) NOT NULL DEFAULT '', |
| 70 |
c53 VARCHAR(1022) NOT NULL DEFAULT '', |
| 71 |
c54 VARCHAR(1022) NOT NULL DEFAULT '', |
| 72 |
c55 VARCHAR(1022) NOT NULL DEFAULT '', |
| 73 |
c56 VARCHAR(1022) NOT NULL DEFAULT '', |
| 74 |
c57 VARCHAR(1022) NOT NULL DEFAULT '', |
| 75 |
c58 VARCHAR(1022) NOT NULL DEFAULT '', |
| 76 |
c59 VARCHAR(1022) NOT NULL DEFAULT '', |
| 77 |
c60 VARCHAR(1022) NOT NULL DEFAULT '', |
| 78 |
c61 VARCHAR(1022) NOT NULL DEFAULT '', |
| 79 |
c62 VARCHAR(1022) NOT NULL DEFAULT '', |
| 80 |
c63 VARCHAR(1022) NOT NULL DEFAULT '', |
| 81 |
c64 VARCHAR(1021) NOT NULL DEFAULT '' |
| 82 |
) ENGINE = INNODB, charset latin1; |
| 83 |
|
| 84 |
SET @save_sort_buffer_size= @@sort_buffer_size; |
| 85 |
|
| 86 |
## We can use addons, but not packed addons. |
| 87 |
## With addon fields, we need larger sort_buffer_size. |
| 88 |
SET @@sort_buffer_size = 8 + 15 * (65535 + 1022 + 8); |
| 89 |
select * from t1 order by c1; |
| 90 |
SELECT * FROM information_schema.OPTIMIZER_TRACE; |
| 91 |
|
| 92 |
## We can use addons, but not packed addons. |
| 93 |
## With addon fields, we need larger sort_buffer_size. |
| 94 |
SET @@sort_buffer_size = 8 + 15 * (65535 + 1023 + 8); |
| 95 |
select * from t1 order by c1; |
| 96 |
SELECT * FROM information_schema.OPTIMIZER_TRACE; |
| 97 |
|
| 98 |
## Here we can use packed addons. |
| 99 |
## With addon fields, we need larger sort_buffer_size. |
| 100 |
SET @@sort_buffer_size = 8 + 15 * (65535 + 1024 + 8); |
| 101 |
select * from t1 order by c1; |
| 102 |
SELECT * FROM information_schema.OPTIMIZER_TRACE; |
| 103 |
|
| 104 |
SET @@sort_buffer_size= @save_sort_buffer_size; |
| 105 |
|
| 106 |
DROP TABLE t1; |
| 107 |
|
| 108 |
SET innodb_strict_mode=off; |
| 109 |
CREATE TABLE t1 ( |
| 110 |
c1 CHAR(255) NOT NULL DEFAULT '', |
| 111 |
c2 CHAR(255) NOT NULL DEFAULT '', |
| 112 |
c3 CHAR(255) NOT NULL DEFAULT '', |
| 113 |
c4 CHAR(255) NOT NULL DEFAULT '', |
| 114 |
c5 CHAR(255) NOT NULL DEFAULT '', |
| 115 |
c6 CHAR(255) NOT NULL DEFAULT '', |
| 116 |
c7 CHAR(255) NOT NULL DEFAULT '', |
| 117 |
c8 CHAR(255) NOT NULL DEFAULT '', |
| 118 |
c9 CHAR(255) NOT NULL DEFAULT '', |
| 119 |
c10 CHAR(255) NOT NULL DEFAULT '', |
| 120 |
c11 CHAR(255) NOT NULL DEFAULT '', |
| 121 |
c12 CHAR(255) NOT NULL DEFAULT '', |
| 122 |
c13 CHAR(255) NOT NULL DEFAULT '', |
| 123 |
c14 CHAR(255) NOT NULL DEFAULT '', |
| 124 |
c15 CHAR(255) NOT NULL DEFAULT '', |
| 125 |
c16 CHAR(255) NOT NULL DEFAULT '', |
| 126 |
c17 CHAR(255) NOT NULL DEFAULT '', |
| 127 |
c18 CHAR(255) NOT NULL DEFAULT '', |
| 128 |
c19 CHAR(255) NOT NULL DEFAULT '', |
| 129 |
c20 CHAR(255) NOT NULL DEFAULT '', |
| 130 |
c21 CHAR(255) NOT NULL DEFAULT '', |
| 131 |
c22 CHAR(255) NOT NULL DEFAULT '', |
| 132 |
c23 CHAR(255) NOT NULL DEFAULT '', |
| 133 |
c24 CHAR(255) NOT NULL DEFAULT '', |
| 134 |
c25 CHAR(255) NOT NULL DEFAULT '', |
| 135 |
c26 CHAR(255) NOT NULL DEFAULT '', |
| 136 |
c27 CHAR(255) NOT NULL DEFAULT '', |
| 137 |
c28 CHAR(255) NOT NULL DEFAULT '', |
| 138 |
c29 CHAR(255) NOT NULL DEFAULT '', |
| 139 |
c30 CHAR(255) NOT NULL DEFAULT '', |
| 140 |
c31 CHAR(255) NOT NULL DEFAULT '', |
| 141 |
c32 CHAR(255) NOT NULL DEFAULT '', |
| 142 |
c33 CHAR(255) NOT NULL DEFAULT '', |
| 143 |
c34 CHAR(255) NOT NULL DEFAULT '', |
| 144 |
c35 CHAR(255) NOT NULL DEFAULT '', |
| 145 |
c36 CHAR(255) NOT NULL DEFAULT '', |
| 146 |
c37 CHAR(255) NOT NULL DEFAULT '', |
| 147 |
c38 CHAR(255) NOT NULL DEFAULT '', |
| 148 |
c39 CHAR(255) NOT NULL DEFAULT '', |
| 149 |
c40 CHAR(255) NOT NULL DEFAULT '', |
| 150 |
c41 CHAR(255) NOT NULL DEFAULT '', |
| 151 |
c42 CHAR(255) NOT NULL DEFAULT '', |
| 152 |
c43 CHAR(255) NOT NULL DEFAULT '', |
| 153 |
c44 CHAR(255) NOT NULL DEFAULT '', |
| 154 |
c45 CHAR(255) NOT NULL DEFAULT '', |
| 155 |
c46 CHAR(255) NOT NULL DEFAULT '', |
| 156 |
c47 CHAR(255) NOT NULL DEFAULT '', |
| 157 |
c48 CHAR(255) NOT NULL DEFAULT '', |
| 158 |
c49 CHAR(255) NOT NULL DEFAULT '', |
| 159 |
c50 CHAR(255) NOT NULL DEFAULT '', |
| 160 |
c51 CHAR(255) NOT NULL DEFAULT '', |
| 161 |
c52 CHAR(255) NOT NULL DEFAULT '', |
| 162 |
c53 CHAR(255) NOT NULL DEFAULT '', |
| 163 |
c54 CHAR(255) NOT NULL DEFAULT '', |
| 164 |
c55 CHAR(255) NOT NULL DEFAULT '', |
| 165 |
c56 CHAR(255) NOT NULL DEFAULT '', |
| 166 |
c57 CHAR(255) NOT NULL DEFAULT '', |
| 167 |
c58 CHAR(255) NOT NULL DEFAULT '', |
| 168 |
c59 CHAR(255) NOT NULL DEFAULT '', |
| 169 |
c60 CHAR(255) NOT NULL DEFAULT '', |
| 170 |
c61 CHAR(255) NOT NULL DEFAULT '', |
| 171 |
c62 CHAR(255) NOT NULL DEFAULT '', |
| 172 |
c63 CHAR(255) NOT NULL DEFAULT '', |
| 173 |
c64 CHAR(255) NOT NULL DEFAULT '', |
| 174 |
c65 CHAR(255) NOT NULL DEFAULT '', |
| 175 |
c66 CHAR(255) NOT NULL DEFAULT '', |
| 176 |
c67 CHAR(255) NOT NULL DEFAULT '', |
| 177 |
c68 CHAR(255) NOT NULL DEFAULT '', |
| 178 |
c69 CHAR(255) NOT NULL DEFAULT '', |
| 179 |
c70 CHAR(255) NOT NULL DEFAULT '', |
| 180 |
c71 CHAR(255) NOT NULL DEFAULT '', |
| 181 |
c72 CHAR(255) NOT NULL DEFAULT '', |
| 182 |
c73 CHAR(255) NOT NULL DEFAULT '', |
| 183 |
c74 CHAR(255) NOT NULL DEFAULT '', |
| 184 |
c75 CHAR(255) NOT NULL DEFAULT '', |
| 185 |
c76 CHAR(255) NOT NULL DEFAULT '', |
| 186 |
c77 CHAR(255) NOT NULL DEFAULT '', |
| 187 |
c78 CHAR(255) NOT NULL DEFAULT '', |
| 188 |
c79 CHAR(255) NOT NULL DEFAULT '', |
| 189 |
c80 CHAR(255) NOT NULL DEFAULT '', |
| 190 |
c81 CHAR(255) NOT NULL DEFAULT '', |
| 191 |
c82 CHAR(255) NOT NULL DEFAULT '', |
| 192 |
c83 CHAR(255) NOT NULL DEFAULT '', |
| 193 |
c84 CHAR(255) NOT NULL DEFAULT '', |
| 194 |
c85 CHAR(255) NOT NULL DEFAULT '', |
| 195 |
c86 CHAR(255) NOT NULL DEFAULT '', |
| 196 |
c87 CHAR(255) NOT NULL DEFAULT '', |
| 197 |
c88 CHAR(255) NOT NULL DEFAULT '', |
| 198 |
c89 CHAR(255) NOT NULL DEFAULT '', |
| 199 |
c90 CHAR(255) NOT NULL DEFAULT '', |
| 200 |
c91 CHAR(255) NOT NULL DEFAULT '', |
| 201 |
c92 CHAR(255) NOT NULL DEFAULT '', |
| 202 |
c93 CHAR(255) NOT NULL DEFAULT '', |
| 203 |
c94 CHAR(255) NOT NULL DEFAULT '', |
| 204 |
c95 CHAR(255) NOT NULL DEFAULT '', |
| 205 |
c96 CHAR(255) NOT NULL DEFAULT '', |
| 206 |
c97 CHAR(255) NOT NULL DEFAULT '', |
| 207 |
c98 CHAR(255) NOT NULL DEFAULT '', |
| 208 |
c99 CHAR(255) NOT NULL DEFAULT '', |
| 209 |
c100 CHAR(255) NOT NULL DEFAULT '', |
| 210 |
c101 CHAR(255) NOT NULL DEFAULT '', |
| 211 |
c102 CHAR(255) NOT NULL DEFAULT '', |
| 212 |
c103 CHAR(255) NOT NULL DEFAULT '', |
| 213 |
c104 CHAR(255) NOT NULL DEFAULT '', |
| 214 |
c105 CHAR(255) NOT NULL DEFAULT '', |
| 215 |
c106 CHAR(255) NOT NULL DEFAULT '', |
| 216 |
c107 CHAR(255) NOT NULL DEFAULT '', |
| 217 |
c108 CHAR(255) NOT NULL DEFAULT '', |
| 218 |
c109 CHAR(255) NOT NULL DEFAULT '', |
| 219 |
c110 CHAR(255) NOT NULL DEFAULT '', |
| 220 |
c111 CHAR(255) NOT NULL DEFAULT '', |
| 221 |
c112 CHAR(255) NOT NULL DEFAULT '', |
| 222 |
c113 CHAR(255) NOT NULL DEFAULT '', |
| 223 |
c114 CHAR(255) NOT NULL DEFAULT '', |
| 224 |
c115 CHAR(255) NOT NULL DEFAULT '', |
| 225 |
c116 CHAR(255) NOT NULL DEFAULT '', |
| 226 |
c117 CHAR(255) NOT NULL DEFAULT '', |
| 227 |
c118 CHAR(255) NOT NULL DEFAULT '', |
| 228 |
c119 CHAR(255) NOT NULL DEFAULT '', |
| 229 |
c120 CHAR(255) NOT NULL DEFAULT '', |
| 230 |
c121 CHAR(255) NOT NULL DEFAULT '', |
| 231 |
c122 CHAR(255) NOT NULL DEFAULT '', |
| 232 |
c123 CHAR(255) NOT NULL DEFAULT '', |
| 233 |
c124 CHAR(255) NOT NULL DEFAULT '', |
| 234 |
c125 CHAR(255) NOT NULL DEFAULT '', |
| 235 |
c126 CHAR(255) NOT NULL DEFAULT '', |
| 236 |
c127 CHAR(255) NOT NULL DEFAULT '', |
| 237 |
c128 CHAR(255) NOT NULL DEFAULT '', |
| 238 |
c129 CHAR(255) NOT NULL DEFAULT '', |
| 239 |
c130 CHAR(255) NOT NULL DEFAULT '', |
| 240 |
c131 CHAR(255) NOT NULL DEFAULT '', |
| 241 |
c132 CHAR(255) NOT NULL DEFAULT '', |
| 242 |
c133 CHAR(255) NOT NULL DEFAULT '', |
| 243 |
c134 CHAR(255) NOT NULL DEFAULT '', |
| 244 |
c135 CHAR(255) NOT NULL DEFAULT '', |
| 245 |
c136 CHAR(255) NOT NULL DEFAULT '', |
| 246 |
c137 CHAR(255) NOT NULL DEFAULT '', |
| 247 |
c138 CHAR(255) NOT NULL DEFAULT '', |
| 248 |
c139 CHAR(255) NOT NULL DEFAULT '', |
| 249 |
c140 CHAR(255) NOT NULL DEFAULT '', |
| 250 |
c141 CHAR(255) NOT NULL DEFAULT '', |
| 251 |
c142 CHAR(255) NOT NULL DEFAULT '', |
| 252 |
c143 CHAR(255) NOT NULL DEFAULT '', |
| 253 |
c144 CHAR(255) NOT NULL DEFAULT '', |
| 254 |
c145 CHAR(255) NOT NULL DEFAULT '', |
| 255 |
c146 CHAR(255) NOT NULL DEFAULT '', |
| 256 |
c147 CHAR(255) NOT NULL DEFAULT '', |
| 257 |
c148 CHAR(255) NOT NULL DEFAULT '', |
| 258 |
c149 CHAR(255) NOT NULL DEFAULT '', |
| 259 |
c150 CHAR(255) NOT NULL DEFAULT '', |
| 260 |
c151 CHAR(255) NOT NULL DEFAULT '', |
| 261 |
c152 CHAR(255) NOT NULL DEFAULT '', |
| 262 |
c153 CHAR(255) NOT NULL DEFAULT '', |
| 263 |
c154 CHAR(255) NOT NULL DEFAULT '', |
| 264 |
c155 CHAR(255) NOT NULL DEFAULT '', |
| 265 |
c156 CHAR(255) NOT NULL DEFAULT '', |
| 266 |
c157 CHAR(255) NOT NULL DEFAULT '', |
| 267 |
c158 CHAR(255) NOT NULL DEFAULT '', |
| 268 |
c159 CHAR(255) NOT NULL DEFAULT '', |
| 269 |
c160 CHAR(255) NOT NULL DEFAULT '', |
| 270 |
c161 CHAR(255) NOT NULL DEFAULT '', |
| 271 |
c162 CHAR(255) NOT NULL DEFAULT '', |
| 272 |
c163 CHAR(255) NOT NULL DEFAULT '', |
| 273 |
c164 CHAR(255) NOT NULL DEFAULT '', |
| 274 |
c165 CHAR(255) NOT NULL DEFAULT '', |
| 275 |
c166 CHAR(255) NOT NULL DEFAULT '', |
| 276 |
c167 CHAR(255) NOT NULL DEFAULT '', |
| 277 |
c168 CHAR(255) NOT NULL DEFAULT '', |
| 278 |
c169 CHAR(255) NOT NULL DEFAULT '', |
| 279 |
c170 CHAR(255) NOT NULL DEFAULT '', |
| 280 |
c171 CHAR(255) NOT NULL DEFAULT '', |
| 281 |
c172 CHAR(255) NOT NULL DEFAULT '', |
| 282 |
c173 CHAR(255) NOT NULL DEFAULT '', |
| 283 |
c174 CHAR(255) NOT NULL DEFAULT '', |
| 284 |
c175 CHAR(255) NOT NULL DEFAULT '', |
| 285 |
c176 CHAR(255) NOT NULL DEFAULT '', |
| 286 |
c177 CHAR(255) NOT NULL DEFAULT '', |
| 287 |
c178 CHAR(255) NOT NULL DEFAULT '', |
| 288 |
c179 CHAR(255) NOT NULL DEFAULT '', |
| 289 |
c180 CHAR(255) NOT NULL DEFAULT '', |
| 290 |
c181 CHAR(255) NOT NULL DEFAULT '', |
| 291 |
c182 CHAR(255) NOT NULL DEFAULT '', |
| 292 |
c183 CHAR(255) NOT NULL DEFAULT '', |
| 293 |
c184 CHAR(255) NOT NULL DEFAULT '', |
| 294 |
c185 CHAR(255) NOT NULL DEFAULT '', |
| 295 |
c186 CHAR(255) NOT NULL DEFAULT '', |
| 296 |
c187 CHAR(255) NOT NULL DEFAULT '', |
| 297 |
c188 CHAR(255) NOT NULL DEFAULT '', |
| 298 |
c189 CHAR(255) NOT NULL DEFAULT '', |
| 299 |
c190 CHAR(255) NOT NULL DEFAULT '', |
| 300 |
c191 CHAR(255) NOT NULL DEFAULT '', |
| 301 |
c192 CHAR(255) NOT NULL DEFAULT '', |
| 302 |
c193 CHAR(255) NOT NULL DEFAULT '', |
| 303 |
c194 CHAR(255) NOT NULL DEFAULT '', |
| 304 |
c195 CHAR(255) NOT NULL DEFAULT '', |
| 305 |
c196 CHAR(255) NOT NULL DEFAULT '', |
| 306 |
c197 CHAR(255) NOT NULL DEFAULT '', |
| 307 |
c198 CHAR(255) NOT NULL DEFAULT '', |
| 308 |
c199 CHAR(255) NOT NULL DEFAULT '', |
| 309 |
c200 CHAR(255) NOT NULL DEFAULT '', |
| 310 |
c201 CHAR(255) NOT NULL DEFAULT '', |
| 311 |
c202 CHAR(255) NOT NULL DEFAULT '', |
| 312 |
c203 CHAR(255) NOT NULL DEFAULT '', |
| 313 |
c204 CHAR(255) NOT NULL DEFAULT '', |
| 314 |
c205 CHAR(255) NOT NULL DEFAULT '', |
| 315 |
c206 CHAR(255) NOT NULL DEFAULT '', |
| 316 |
c207 CHAR(255) NOT NULL DEFAULT '', |
| 317 |
c208 CHAR(255) NOT NULL DEFAULT '', |
| 318 |
c209 CHAR(255) NOT NULL DEFAULT '', |
| 319 |
c210 CHAR(255) NOT NULL DEFAULT '', |
| 320 |
c211 CHAR(255) NOT NULL DEFAULT '', |
| 321 |
c212 CHAR(255) NOT NULL DEFAULT '', |
| 322 |
c213 CHAR(255) NOT NULL DEFAULT '', |
| 323 |
c214 CHAR(255) NOT NULL DEFAULT '', |
| 324 |
c215 CHAR(255) NOT NULL DEFAULT '', |
| 325 |
c216 CHAR(255) NOT NULL DEFAULT '', |
| 326 |
c217 CHAR(255) NOT NULL DEFAULT '', |
| 327 |
c218 CHAR(255) NOT NULL DEFAULT '', |
| 328 |
c219 CHAR(255) NOT NULL DEFAULT '', |
| 329 |
c220 CHAR(255) NOT NULL DEFAULT '', |
| 330 |
c221 CHAR(255) NOT NULL DEFAULT '', |
| 331 |
c222 CHAR(255) NOT NULL DEFAULT '', |
| 332 |
c223 CHAR(255) NOT NULL DEFAULT '', |
| 333 |
c224 CHAR(255) NOT NULL DEFAULT '', |
| 334 |
c225 CHAR(255) NOT NULL DEFAULT '', |
| 335 |
c226 CHAR(255) NOT NULL DEFAULT '', |
| 336 |
c227 CHAR(255) NOT NULL DEFAULT '', |
| 337 |
c228 CHAR(255) NOT NULL DEFAULT '', |
| 338 |
c229 CHAR(255) NOT NULL DEFAULT '', |
| 339 |
c230 CHAR(255) NOT NULL DEFAULT '', |
| 340 |
c231 CHAR(255) NOT NULL DEFAULT '', |
| 341 |
c232 CHAR(255) NOT NULL DEFAULT '', |
| 342 |
c233 CHAR(255) NOT NULL DEFAULT '', |
| 343 |
c234 CHAR(255) NOT NULL DEFAULT '', |
| 344 |
c235 CHAR(255) NOT NULL DEFAULT '', |
| 345 |
c236 CHAR(255) NOT NULL DEFAULT '', |
| 346 |
c237 CHAR(255) NOT NULL DEFAULT '', |
| 347 |
c238 CHAR(255) NOT NULL DEFAULT '', |
| 348 |
c239 CHAR(255) NOT NULL DEFAULT '', |
| 349 |
c240 CHAR(255) NOT NULL DEFAULT '', |
| 350 |
c241 CHAR(255) NOT NULL DEFAULT '', |
| 351 |
c242 CHAR(255) NOT NULL DEFAULT '', |
| 352 |
c243 CHAR(255) NOT NULL DEFAULT '', |
| 353 |
c244 CHAR(255) NOT NULL DEFAULT '', |
| 354 |
c245 CHAR(255) NOT NULL DEFAULT '', |
| 355 |
c246 CHAR(255) NOT NULL DEFAULT '', |
| 356 |
c247 CHAR(255) NOT NULL DEFAULT '', |
| 357 |
c248 CHAR(255) NOT NULL DEFAULT '', |
| 358 |
c249 CHAR(255) NOT NULL DEFAULT '', |
| 359 |
c250 CHAR(255) NOT NULL DEFAULT '', |
| 360 |
c251 CHAR(255) NOT NULL DEFAULT '', |
| 361 |
c252 CHAR(255) NOT NULL DEFAULT '', |
| 362 |
c253 CHAR(255) NOT NULL DEFAULT '', |
| 363 |
c254 CHAR(255) NOT NULL DEFAULT '', |
| 364 |
c255 CHAR(255) NOT NULL DEFAULT '', |
| 365 |
c256 CHAR(255) NOT NULL DEFAULT '', |
| 366 |
c257 CHAR(254) NOT NULL DEFAULT '' |
| 367 |
) ENGINE = INNODB ROW_FORMAT=COMPACT charset latin1; |
| 368 |
|
| 369 |
SELECT * FROM t1 ORDER BY c1; |
| 370 |
SELECT * FROM information_schema.OPTIMIZER_TRACE; |
| 371 |
|
| 372 |
DROP TABLE t1; |