part_blocked_sql_func_myisam.result 163 KB
Newer Older
1 2 3 4
-------------------------------------------------------------------------
---   All SQL functions should be rejected, otherwise BUG (see 18198)
-------------------------------------------------------------------------
-------------------------------------------------------------------------
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
---  ascii(col1)  in partition with coltype  char(30)
-------------------------------------------------------------------------
must all fail!
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(ascii(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(ascii(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(ascii(col1));
Got one of the listed errors
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(ascii(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(ascii(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (ascii('a')),
partition p1 values less than maxvalue);
Got one of the listed errors
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(ascii(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
alter table t22 
partition by list(ascii(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
alter table t33 
partition by hash(ascii(col1));
Got one of the listed errors
alter table t44 
partition by range(colint) 
subpartition by hash(ascii(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
alter table t55 
partition by list(colint)
subpartition by hash(ascii(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
alter table t66  
partition by range(colint) 
(partition p0 values less than (ascii('a')),
partition p1 values less than maxvalue);
Got one of the listed errors
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  ord(col1)  in partition with coltype  char(30)
-------------------------------------------------------------------------
must all fail!
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(ord(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(ord(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(ord(col1));
Got one of the listed errors
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(ord(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(ord(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (ord('a')),
partition p1 values less than maxvalue);
Got one of the listed errors
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(ord(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
alter table t22 
partition by list(ord(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
alter table t33 
partition by hash(ord(col1));
Got one of the listed errors
alter table t44 
partition by range(colint) 
subpartition by hash(ord(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
alter table t55 
partition by list(colint)
subpartition by hash(ord(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
alter table t66  
partition by range(colint) 
(partition p0 values less than (ord('a')),
partition p1 values less than maxvalue);
Got one of the listed errors
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
201 202
---  greatest(col1,15)  in partition with coltype  int
-------------------------------------------------------------------------
203
must all fail!
204 205 206 207 208 209 210 211 212 213
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(greatest(col1,15)) 
(partition p0 values less than (15),
partition p1 values less than (31));
214
Got one of the listed errors
215 216 217 218 219
create table t2 (col1 int) engine='MYISAM' 
partition by list(greatest(col1,15)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
220
Got one of the listed errors
221 222
create table t3 (col1 int) engine='MYISAM' 
partition by hash(greatest(col1,15));
223
Got one of the listed errors
224 225 226 227 228
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(greatest(col1,15)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
229
Got one of the listed errors
230 231 232 233 234 235
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(greatest(col1,15)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
236
Got one of the listed errors
237 238 239 240
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (greatest(1,15)),
partition p1 values less than maxvalue);
241
Got one of the listed errors
242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(greatest(col1,15)) 
(partition p0 values less than (15),
partition p1 values less than (31));
258
Got one of the listed errors
259 260 261 262 263
alter table t22 
partition by list(greatest(col1,15)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
264
Got one of the listed errors
265 266
alter table t33 
partition by hash(greatest(col1,15));
267
Got one of the listed errors
268 269 270 271 272
alter table t44 
partition by range(colint) 
subpartition by hash(greatest(col1,15)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
273
Got one of the listed errors
274 275 276 277 278 279
alter table t55 
partition by list(colint)
subpartition by hash(greatest(col1,15)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
280
Got one of the listed errors
281 282 283 284
alter table t66  
partition by range(colint) 
(partition p0 values less than (greatest(1,15)),
partition p1 values less than maxvalue);
285
Got one of the listed errors
286 287 288 289 290 291 292 293 294 295 296 297 298 299 300
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  isnull(col1)  in partition with coltype  int
-------------------------------------------------------------------------
301
must all fail!
302 303 304 305 306 307 308 309 310 311
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(isnull(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
312
Got one of the listed errors
313 314 315 316 317
create table t2 (col1 int) engine='MYISAM' 
partition by list(isnull(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
318
Got one of the listed errors
319 320
create table t3 (col1 int) engine='MYISAM' 
partition by hash(isnull(col1));
321
Got one of the listed errors
322 323 324 325 326
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(isnull(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
327
Got one of the listed errors
328 329 330 331 332 333
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(isnull(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
334
Got one of the listed errors
335 336 337 338
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (isnull(15)),
partition p1 values less than maxvalue);
339
Got one of the listed errors
340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(isnull(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
356
Got one of the listed errors
357 358 359 360 361
alter table t22 
partition by list(isnull(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
362
Got one of the listed errors
363 364
alter table t33 
partition by hash(isnull(col1));
365
Got one of the listed errors
366 367 368 369 370
alter table t44 
partition by range(colint) 
subpartition by hash(isnull(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
371
Got one of the listed errors
372 373 374 375 376 377
alter table t55 
partition by list(colint)
subpartition by hash(isnull(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
378
Got one of the listed errors
379 380 381 382
alter table t66  
partition by range(colint) 
(partition p0 values less than (isnull(15)),
partition p1 values less than maxvalue);
383
Got one of the listed errors
384 385 386 387 388 389 390 391 392 393 394 395 396 397 398
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  least(col1,15)  in partition with coltype  int
-------------------------------------------------------------------------
399
must all fail!
400 401 402 403 404 405 406 407 408 409
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(least(col1,15)) 
(partition p0 values less than (15),
partition p1 values less than (31));
410
Got one of the listed errors
411 412 413 414 415
create table t2 (col1 int) engine='MYISAM' 
partition by list(least(col1,15)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
416
Got one of the listed errors
417 418
create table t3 (col1 int) engine='MYISAM' 
partition by hash(least(col1,15));
419
Got one of the listed errors
420 421 422 423 424
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(least(col1,15)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
425
Got one of the listed errors
426 427 428 429 430 431
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(least(col1,15)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
432
Got one of the listed errors
433 434 435 436
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (least(15,30)),
partition p1 values less than maxvalue);
437
Got one of the listed errors
438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(least(col1,15)) 
(partition p0 values less than (15),
partition p1 values less than (31));
454
Got one of the listed errors
455 456 457 458 459
alter table t22 
partition by list(least(col1,15)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
460
Got one of the listed errors
461 462
alter table t33 
partition by hash(least(col1,15));
463
Got one of the listed errors
464 465 466 467 468
alter table t44 
partition by range(colint) 
subpartition by hash(least(col1,15)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
469
Got one of the listed errors
470 471 472 473 474 475
alter table t55 
partition by list(colint)
subpartition by hash(least(col1,15)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
476
Got one of the listed errors
477 478 479 480
alter table t66  
partition by range(colint) 
(partition p0 values less than (least(15,30)),
partition p1 values less than maxvalue);
481
Got one of the listed errors
482 483 484 485 486 487 488 489 490 491 492 493 494 495 496
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  case when col1>15 then 20 else 10 end  in partition with coltype  int
-------------------------------------------------------------------------
497
must all fail!
498 499 500 501 502 503 504 505 506 507
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(case when col1>15 then 20 else 10 end) 
(partition p0 values less than (15),
partition p1 values less than (31));
508
Got one of the listed errors
509 510 511 512 513
create table t2 (col1 int) engine='MYISAM' 
partition by list(case when col1>15 then 20 else 10 end) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
514
Got one of the listed errors
515 516
create table t3 (col1 int) engine='MYISAM' 
partition by hash(case when col1>15 then 20 else 10 end);
517
Got one of the listed errors
518 519 520 521 522
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(case when col1>15 then 20 else 10 end) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
523
Got one of the listed errors
524 525 526 527 528 529
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(case when col1>15 then 20 else 10 end) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
530
Got one of the listed errors
531 532 533 534
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (case when 1>30 then 20 else 15 end),
partition p1 values less than maxvalue);
535
Got one of the listed errors
536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(case when col1>15 then 20 else 10 end) 
(partition p0 values less than (15),
partition p1 values less than (31));
552
Got one of the listed errors
553 554 555 556 557
alter table t22 
partition by list(case when col1>15 then 20 else 10 end) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
558
Got one of the listed errors
559 560
alter table t33 
partition by hash(case when col1>15 then 20 else 10 end);
561
Got one of the listed errors
562 563 564 565 566
alter table t44 
partition by range(colint) 
subpartition by hash(case when col1>15 then 20 else 10 end) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
567
Got one of the listed errors
568 569 570 571 572 573
alter table t55 
partition by list(colint)
subpartition by hash(case when col1>15 then 20 else 10 end) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
574
Got one of the listed errors
575 576 577 578
alter table t66  
partition by range(colint) 
(partition p0 values less than (case when 1>30 then 20 else 15 end),
partition p1 values less than maxvalue);
579
Got one of the listed errors
580 581 582 583 584 585 586 587 588 589 590 591 592 593 594
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  ifnull(col1,30)  in partition with coltype  int
-------------------------------------------------------------------------
595
must all fail!
596 597 598 599 600 601 602 603 604 605
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(ifnull(col1,30)) 
(partition p0 values less than (15),
partition p1 values less than (31));
606
Got one of the listed errors
607 608 609 610 611
create table t2 (col1 int) engine='MYISAM' 
partition by list(ifnull(col1,30)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
612
Got one of the listed errors
613 614
create table t3 (col1 int) engine='MYISAM' 
partition by hash(ifnull(col1,30));
615
Got one of the listed errors
616 617 618 619 620
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(ifnull(col1,30)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
621
Got one of the listed errors
622 623 624 625 626 627
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(ifnull(col1,30)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
628
Got one of the listed errors
629 630 631 632
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (ifnull(1,30)),
partition p1 values less than maxvalue);
633
Got one of the listed errors
634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(ifnull(col1,30)) 
(partition p0 values less than (15),
partition p1 values less than (31));
650
Got one of the listed errors
651 652 653 654 655
alter table t22 
partition by list(ifnull(col1,30)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
656
Got one of the listed errors
657 658
alter table t33 
partition by hash(ifnull(col1,30));
659
Got one of the listed errors
660 661 662 663 664
alter table t44 
partition by range(colint) 
subpartition by hash(ifnull(col1,30)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
665
Got one of the listed errors
666 667 668 669 670 671
alter table t55 
partition by list(colint)
subpartition by hash(ifnull(col1,30)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
672
Got one of the listed errors
673 674 675 676
alter table t66  
partition by range(colint) 
(partition p0 values less than (ifnull(1,30)),
partition p1 values less than maxvalue);
677
Got one of the listed errors
678 679 680 681 682 683 684 685 686 687 688 689 690 691 692
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  nullif(col1,30)  in partition with coltype  int
-------------------------------------------------------------------------
693
must all fail!
694 695 696 697 698 699 700 701 702 703
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(nullif(col1,30)) 
(partition p0 values less than (15),
partition p1 values less than (31));
704
Got one of the listed errors
705 706 707 708 709
create table t2 (col1 int) engine='MYISAM' 
partition by list(nullif(col1,30)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
710
Got one of the listed errors
711 712
create table t3 (col1 int) engine='MYISAM' 
partition by hash(nullif(col1,30));
713
Got one of the listed errors
714 715 716 717 718
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(nullif(col1,30)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
719
Got one of the listed errors
720 721 722 723 724 725
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(nullif(col1,30)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
726
Got one of the listed errors
727 728 729 730
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (nullif(1,30)),
partition p1 values less than maxvalue);
731
Got one of the listed errors
732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(nullif(col1,30)) 
(partition p0 values less than (15),
partition p1 values less than (31));
748
Got one of the listed errors
749 750 751 752 753
alter table t22 
partition by list(nullif(col1,30)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
754
Got one of the listed errors
755 756
alter table t33 
partition by hash(nullif(col1,30));
757
Got one of the listed errors
758 759 760 761 762
alter table t44 
partition by range(colint) 
subpartition by hash(nullif(col1,30)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
763
Got one of the listed errors
764 765 766 767 768 769
alter table t55 
partition by list(colint)
subpartition by hash(nullif(col1,30)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
770
Got one of the listed errors
771 772 773 774
alter table t66  
partition by range(colint) 
(partition p0 values less than (nullif(1,30)),
partition p1 values less than maxvalue);
775
Got one of the listed errors
776 777 778 779 780 781 782 783 784 785 786 787 788 789 790
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  bit_length(col1)  in partition with coltype  int
-------------------------------------------------------------------------
791
must all fail!
792 793 794 795 796 797 798 799 800 801
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(bit_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
802
Got one of the listed errors
803 804 805 806 807
create table t2 (col1 int) engine='MYISAM' 
partition by list(bit_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
808
Got one of the listed errors
809 810
create table t3 (col1 int) engine='MYISAM' 
partition by hash(bit_length(col1));
811
Got one of the listed errors
812 813 814 815 816
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(bit_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
817
Got one of the listed errors
818 819 820 821 822 823
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(bit_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
824
Got one of the listed errors
825 826 827 828
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (bit_length(255)),
partition p1 values less than maxvalue);
829
Got one of the listed errors
830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(bit_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
846
Got one of the listed errors
847 848 849 850 851
alter table t22 
partition by list(bit_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
852
Got one of the listed errors
853 854
alter table t33 
partition by hash(bit_length(col1));
855
Got one of the listed errors
856 857 858 859 860
alter table t44 
partition by range(colint) 
subpartition by hash(bit_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
861
Got one of the listed errors
862 863 864 865 866 867
alter table t55 
partition by list(colint)
subpartition by hash(bit_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
868
Got one of the listed errors
869 870 871 872
alter table t66  
partition by range(colint) 
(partition p0 values less than (bit_length(255)),
partition p1 values less than maxvalue);
873
Got one of the listed errors
874 875 876 877 878 879 880 881 882 883 884 885 886 887 888
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  bit_length(col1)  in partition with coltype  char(30)
-------------------------------------------------------------------------
889
must all fail!
890 891 892 893 894 895 896 897 898 899
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(bit_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
900
Got one of the listed errors
901 902 903 904 905
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(bit_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
906
Got one of the listed errors
907 908
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(bit_length(col1));
909
Got one of the listed errors
910 911 912 913 914
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(bit_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
915
Got one of the listed errors
916 917 918 919 920 921
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(bit_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
922
Got one of the listed errors
923 924 925 926
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (bit_length(255)),
partition p1 values less than maxvalue);
927
Got one of the listed errors
928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(bit_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
944
Got one of the listed errors
945 946 947 948 949
alter table t22 
partition by list(bit_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
950
Got one of the listed errors
951 952
alter table t33 
partition by hash(bit_length(col1));
953
Got one of the listed errors
954 955 956 957 958
alter table t44 
partition by range(colint) 
subpartition by hash(bit_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
959
Got one of the listed errors
960 961 962 963 964 965
alter table t55 
partition by list(colint)
subpartition by hash(bit_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
966
Got one of the listed errors
967 968 969 970
alter table t66  
partition by range(colint) 
(partition p0 values less than (bit_length(255)),
partition p1 values less than maxvalue);
971
Got one of the listed errors
972 973 974 975 976 977 978 979 980 981 982 983 984 985 986
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  char_length(col1)  in partition with coltype  char(30)
-------------------------------------------------------------------------
987
must all fail!
988 989 990 991 992 993 994 995 996 997
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(char_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
998
Got one of the listed errors
999 1000 1001 1002 1003
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(char_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1004
Got one of the listed errors
1005 1006
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(char_length(col1));
1007
Got one of the listed errors
1008 1009 1010 1011 1012
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(char_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1013
Got one of the listed errors
1014 1015 1016 1017 1018 1019
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(char_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1020
Got one of the listed errors
1021 1022 1023 1024
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (char_length('a')),
partition p1 values less than maxvalue);
1025
Got one of the listed errors
1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(char_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1042
Got one of the listed errors
1043 1044 1045 1046 1047
alter table t22 
partition by list(char_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1048
Got one of the listed errors
1049 1050
alter table t33 
partition by hash(char_length(col1));
1051
Got one of the listed errors
1052 1053 1054 1055 1056
alter table t44 
partition by range(colint) 
subpartition by hash(char_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1057
Got one of the listed errors
1058 1059 1060 1061 1062 1063
alter table t55 
partition by list(colint)
subpartition by hash(char_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1064
Got one of the listed errors
1065 1066 1067 1068
alter table t66  
partition by range(colint) 
(partition p0 values less than (char_length('a')),
partition p1 values less than maxvalue);
1069
Got one of the listed errors
1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  character_length(col1)  in partition with coltype  int
-------------------------------------------------------------------------
1085
must all fail!
1086 1087 1088 1089 1090 1091 1092 1093 1094 1095
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(character_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1096
Got one of the listed errors
1097 1098 1099 1100 1101
create table t2 (col1 int) engine='MYISAM' 
partition by list(character_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1102
Got one of the listed errors
1103 1104
create table t3 (col1 int) engine='MYISAM' 
partition by hash(character_length(col1));
1105
Got one of the listed errors
1106 1107 1108 1109 1110
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(character_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1111
Got one of the listed errors
1112 1113 1114 1115 1116 1117
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(character_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1118
Got one of the listed errors
1119 1120 1121 1122
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (find_in_set('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1123
Got one of the listed errors
1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(character_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1140
Got one of the listed errors
1141 1142 1143 1144 1145
alter table t22 
partition by list(character_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1146
Got one of the listed errors
1147 1148
alter table t33 
partition by hash(character_length(col1));
1149
Got one of the listed errors
1150 1151 1152 1153 1154
alter table t44 
partition by range(colint) 
subpartition by hash(character_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1155
Got one of the listed errors
1156 1157 1158 1159 1160 1161
alter table t55 
partition by list(colint)
subpartition by hash(character_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1162
Got one of the listed errors
1163 1164 1165 1166
alter table t66  
partition by range(colint) 
(partition p0 values less than (find_in_set('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1167
Got one of the listed errors
1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  character_length(col1)  in partition with coltype  char(30)
-------------------------------------------------------------------------
1183
must all fail!
1184 1185 1186 1187 1188 1189 1190 1191 1192 1193
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(character_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1194
Got one of the listed errors
1195 1196 1197 1198 1199
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(character_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1200
Got one of the listed errors
1201 1202
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(character_length(col1));
1203
Got one of the listed errors
1204 1205 1206 1207 1208
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(character_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1209
Got one of the listed errors
1210 1211 1212 1213 1214 1215
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(character_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1216
Got one of the listed errors
1217 1218 1219 1220
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (find_in_set('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1221
Got one of the listed errors
1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(character_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1238
Got one of the listed errors
1239 1240 1241 1242 1243
alter table t22 
partition by list(character_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1244
Got one of the listed errors
1245 1246
alter table t33 
partition by hash(character_length(col1));
1247
Got one of the listed errors
1248 1249 1250 1251 1252
alter table t44 
partition by range(colint) 
subpartition by hash(character_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1253
Got one of the listed errors
1254 1255 1256 1257 1258 1259
alter table t55 
partition by list(colint)
subpartition by hash(character_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1260
Got one of the listed errors
1261 1262 1263 1264
alter table t66  
partition by range(colint) 
(partition p0 values less than (find_in_set('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1265
Got one of the listed errors
1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  instr(col1,'acb')  in partition with coltype  int
-------------------------------------------------------------------------
1281
must all fail!
1282 1283 1284 1285 1286 1287 1288 1289 1290 1291
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(instr(col1,'acb')) 
(partition p0 values less than (15),
partition p1 values less than (31));
1292
Got one of the listed errors
1293 1294 1295 1296 1297
create table t2 (col1 int) engine='MYISAM' 
partition by list(instr(col1,'acb')) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1298
Got one of the listed errors
1299 1300
create table t3 (col1 int) engine='MYISAM' 
partition by hash(instr(col1,'acb'));
1301
Got one of the listed errors
1302 1303 1304 1305 1306
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(instr(col1,'acb')) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1307
Got one of the listed errors
1308 1309 1310 1311 1312 1313
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(instr(col1,'acb')) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1314
Got one of the listed errors
1315 1316 1317 1318
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (instr('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1319
Got one of the listed errors
1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(instr(col1,'acb')) 
(partition p0 values less than (15),
partition p1 values less than (31));
1336
Got one of the listed errors
1337 1338 1339 1340 1341
alter table t22 
partition by list(instr(col1,'acb')) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1342
Got one of the listed errors
1343 1344
alter table t33 
partition by hash(instr(col1,'acb'));
1345
Got one of the listed errors
1346 1347 1348 1349 1350
alter table t44 
partition by range(colint) 
subpartition by hash(instr(col1,'acb')) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1351
Got one of the listed errors
1352 1353 1354 1355 1356 1357
alter table t55 
partition by list(colint)
subpartition by hash(instr(col1,'acb')) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1358
Got one of the listed errors
1359 1360 1361 1362
alter table t66  
partition by range(colint) 
(partition p0 values less than (instr('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1363
Got one of the listed errors
1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  instr(col1,'acb')  in partition with coltype  char(30)
-------------------------------------------------------------------------
1379
must all fail!
1380 1381 1382 1383 1384 1385 1386 1387 1388 1389
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(instr(col1,'acb')) 
(partition p0 values less than (15),
partition p1 values less than (31));
1390
Got one of the listed errors
1391 1392 1393 1394 1395
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(instr(col1,'acb')) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1396
Got one of the listed errors
1397 1398
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(instr(col1,'acb'));
1399
Got one of the listed errors
1400 1401 1402 1403 1404
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(instr(col1,'acb')) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1405
Got one of the listed errors
1406 1407 1408 1409 1410 1411
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(instr(col1,'acb')) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1412
Got one of the listed errors
1413 1414 1415 1416
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (instr('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1417
Got one of the listed errors
1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(instr(col1,'acb')) 
(partition p0 values less than (15),
partition p1 values less than (31));
1434
Got one of the listed errors
1435 1436 1437 1438 1439
alter table t22 
partition by list(instr(col1,'acb')) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1440
Got one of the listed errors
1441 1442
alter table t33 
partition by hash(instr(col1,'acb'));
1443
Got one of the listed errors
1444 1445 1446 1447 1448
alter table t44 
partition by range(colint) 
subpartition by hash(instr(col1,'acb')) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1449
Got one of the listed errors
1450 1451 1452 1453 1454 1455
alter table t55 
partition by list(colint)
subpartition by hash(instr(col1,'acb')) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1456
Got one of the listed errors
1457 1458 1459 1460
alter table t66  
partition by range(colint) 
(partition p0 values less than (instr('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1461
Got one of the listed errors
1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  length(col1)  in partition with coltype  int
-------------------------------------------------------------------------
1477
must all fail!
1478 1479 1480 1481 1482 1483 1484 1485 1486 1487
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1488
Got one of the listed errors
1489 1490 1491 1492 1493
create table t2 (col1 int) engine='MYISAM' 
partition by list(length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1494
Got one of the listed errors
1495 1496
create table t3 (col1 int) engine='MYISAM' 
partition by hash(length(col1));
1497
Got one of the listed errors
1498 1499 1500 1501 1502
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1503
Got one of the listed errors
1504 1505 1506 1507 1508 1509
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1510
Got one of the listed errors
1511 1512 1513 1514
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (length('a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1515
Got one of the listed errors
1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1532
Got one of the listed errors
1533 1534 1535 1536 1537
alter table t22 
partition by list(length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1538
Got one of the listed errors
1539 1540
alter table t33 
partition by hash(length(col1));
1541
Got one of the listed errors
1542 1543 1544 1545 1546
alter table t44 
partition by range(colint) 
subpartition by hash(length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1547
Got one of the listed errors
1548 1549 1550 1551 1552 1553
alter table t55 
partition by list(colint)
subpartition by hash(length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1554
Got one of the listed errors
1555 1556 1557 1558
alter table t66  
partition by range(colint) 
(partition p0 values less than (length('a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1559
Got one of the listed errors
1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  locate('a',col1)  in partition with coltype  int
-------------------------------------------------------------------------
1575
must all fail!
1576 1577 1578 1579 1580 1581 1582 1583 1584 1585
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(locate('a',col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1586
Got one of the listed errors
1587 1588 1589 1590 1591
create table t2 (col1 int) engine='MYISAM' 
partition by list(locate('a',col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1592
Got one of the listed errors
1593 1594
create table t3 (col1 int) engine='MYISAM' 
partition by hash(locate('a',col1));
1595
Got one of the listed errors
1596 1597 1598 1599 1600
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(locate('a',col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1601
Got one of the listed errors
1602 1603 1604 1605 1606 1607
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(locate('a',col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1608
Got one of the listed errors
1609 1610 1611 1612
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (locate('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1613
Got one of the listed errors
1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(locate('a',col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1630
Got one of the listed errors
1631 1632 1633 1634 1635
alter table t22 
partition by list(locate('a',col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1636
Got one of the listed errors
1637 1638
alter table t33 
partition by hash(locate('a',col1));
1639
Got one of the listed errors
1640 1641 1642 1643 1644
alter table t44 
partition by range(colint) 
subpartition by hash(locate('a',col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1645
Got one of the listed errors
1646 1647 1648 1649 1650 1651
alter table t55 
partition by list(colint)
subpartition by hash(locate('a',col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1652
Got one of the listed errors
1653 1654 1655 1656
alter table t66  
partition by range(colint) 
(partition p0 values less than (locate('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1657
Got one of the listed errors
1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  locate('a',col1)  in partition with coltype  char(30)
-------------------------------------------------------------------------
1673
must all fail!
1674 1675 1676 1677 1678 1679 1680 1681 1682 1683
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(locate('a',col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1684
Got one of the listed errors
1685 1686 1687 1688 1689
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(locate('a',col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1690
Got one of the listed errors
1691 1692
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(locate('a',col1));
1693
Got one of the listed errors
1694 1695 1696 1697 1698
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(locate('a',col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1699
Got one of the listed errors
1700 1701 1702 1703 1704 1705
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(locate('a',col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1706
Got one of the listed errors
1707 1708 1709 1710
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (locate('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1711
Got one of the listed errors
1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(locate('a',col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1728
Got one of the listed errors
1729 1730 1731 1732 1733
alter table t22 
partition by list(locate('a',col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1734
Got one of the listed errors
1735 1736
alter table t33 
partition by hash(locate('a',col1));
1737
Got one of the listed errors
1738 1739 1740 1741 1742
alter table t44 
partition by range(colint) 
subpartition by hash(locate('a',col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1743
Got one of the listed errors
1744 1745 1746 1747 1748 1749
alter table t55 
partition by list(colint)
subpartition by hash(locate('a',col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1750
Got one of the listed errors
1751 1752 1753 1754
alter table t66  
partition by range(colint) 
(partition p0 values less than (locate('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1755
Got one of the listed errors
1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  octet_length(col1)  in partition with coltype  char(30)
-------------------------------------------------------------------------
1771
must all fail!
1772 1773 1774 1775 1776 1777 1778 1779 1780 1781
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(octet_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1782
Got one of the listed errors
1783 1784 1785 1786 1787
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(octet_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1788
Got one of the listed errors
1789 1790
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(octet_length(col1));
1791
Got one of the listed errors
1792 1793 1794 1795 1796
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(octet_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1797
Got one of the listed errors
1798 1799 1800 1801 1802 1803
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(octet_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1804
Got one of the listed errors
1805 1806 1807 1808
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (octet_length('a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1809
Got one of the listed errors
1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(octet_length(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1826
Got one of the listed errors
1827 1828 1829 1830 1831
alter table t22 
partition by list(octet_length(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1832
Got one of the listed errors
1833 1834
alter table t33 
partition by hash(octet_length(col1));
1835
Got one of the listed errors
1836 1837 1838 1839 1840
alter table t44 
partition by range(colint) 
subpartition by hash(octet_length(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1841
Got one of the listed errors
1842 1843 1844 1845 1846 1847
alter table t55 
partition by list(colint)
subpartition by hash(octet_length(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1848
Got one of the listed errors
1849 1850 1851 1852
alter table t66  
partition by range(colint) 
(partition p0 values less than (octet_length('a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1853
Got one of the listed errors
1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  position('a' in col1)  in partition with coltype  int
-------------------------------------------------------------------------
1869
must all fail!
1870 1871 1872 1873 1874 1875 1876 1877 1878 1879
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(position('a' in col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1880
Got one of the listed errors
1881 1882 1883 1884 1885
create table t2 (col1 int) engine='MYISAM' 
partition by list(position('a' in col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1886
Got one of the listed errors
1887 1888
create table t3 (col1 int) engine='MYISAM' 
partition by hash(position('a' in col1));
1889
Got one of the listed errors
1890 1891 1892 1893 1894
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(position('a' in col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1895
Got one of the listed errors
1896 1897 1898 1899 1900 1901
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(position('a' in col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1902
Got one of the listed errors
1903 1904 1905 1906
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (position('i' in 'a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1907
Got one of the listed errors
1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(position('a' in col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1924
Got one of the listed errors
1925 1926 1927 1928 1929
alter table t22 
partition by list(position('a' in col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1930
Got one of the listed errors
1931 1932
alter table t33 
partition by hash(position('a' in col1));
1933
Got one of the listed errors
1934 1935 1936 1937 1938
alter table t44 
partition by range(colint) 
subpartition by hash(position('a' in col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1939
Got one of the listed errors
1940 1941 1942 1943 1944 1945
alter table t55 
partition by list(colint)
subpartition by hash(position('a' in col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1946
Got one of the listed errors
1947 1948 1949 1950
alter table t66  
partition by range(colint) 
(partition p0 values less than (position('i' in 'a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
1951
Got one of the listed errors
1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  position('a' in col1)  in partition with coltype  char(30)
-------------------------------------------------------------------------
1967
must all fail!
1968 1969 1970 1971 1972 1973 1974 1975 1976 1977
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(position('a' in col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
1978
Got one of the listed errors
1979 1980 1981 1982 1983
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(position('a' in col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
1984
Got one of the listed errors
1985 1986
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(position('a' in col1));
1987
Got one of the listed errors
1988 1989 1990 1991 1992
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(position('a' in col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
1993
Got one of the listed errors
1994 1995 1996 1997 1998 1999
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(position('a' in col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2000
Got one of the listed errors
2001 2002 2003 2004
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (position('i' in 'a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
2005
Got one of the listed errors
2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(position('a' in col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2022
Got one of the listed errors
2023 2024 2025 2026 2027
alter table t22 
partition by list(position('a' in col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2028
Got one of the listed errors
2029 2030
alter table t33 
partition by hash(position('a' in col1));
2031
Got one of the listed errors
2032 2033 2034 2035 2036
alter table t44 
partition by range(colint) 
subpartition by hash(position('a' in col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2037
Got one of the listed errors
2038 2039 2040 2041 2042 2043
alter table t55 
partition by list(colint)
subpartition by hash(position('a' in col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2044
Got one of the listed errors
2045 2046 2047 2048
alter table t66  
partition by range(colint) 
(partition p0 values less than (position('i' in 'a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
2049
Got one of the listed errors
2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  strcmp(col1,'acb')  in partition with coltype  int
-------------------------------------------------------------------------
2065
must all fail!
2066 2067 2068 2069 2070 2071 2072 2073 2074 2075
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(strcmp(col1,'acb')) 
(partition p0 values less than (15),
partition p1 values less than (31));
2076
Got one of the listed errors
2077 2078 2079 2080 2081
create table t2 (col1 int) engine='MYISAM' 
partition by list(strcmp(col1,'acb')) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2082
Got one of the listed errors
2083 2084
create table t3 (col1 int) engine='MYISAM' 
partition by hash(strcmp(col1,'acb'));
2085
Got one of the listed errors
2086 2087 2088 2089 2090
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(strcmp(col1,'acb')) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2091
Got one of the listed errors
2092 2093 2094 2095 2096 2097
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(strcmp(col1,'acb')) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2098
Got one of the listed errors
2099 2100 2101 2102
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (strcmp('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
2103
Got one of the listed errors
2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(strcmp(col1,'acb')) 
(partition p0 values less than (15),
partition p1 values less than (31));
2120
Got one of the listed errors
2121 2122 2123 2124 2125
alter table t22 
partition by list(strcmp(col1,'acb')) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2126
Got one of the listed errors
2127 2128
alter table t33 
partition by hash(strcmp(col1,'acb'));
2129
Got one of the listed errors
2130 2131 2132 2133 2134
alter table t44 
partition by range(colint) 
subpartition by hash(strcmp(col1,'acb')) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2135
Got one of the listed errors
2136 2137 2138 2139 2140 2141
alter table t55 
partition by list(colint)
subpartition by hash(strcmp(col1,'acb')) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2142
Got one of the listed errors
2143 2144 2145 2146
alter table t66  
partition by range(colint) 
(partition p0 values less than (strcmp('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
2147
Got one of the listed errors
2148 2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159 2160 2161 2162
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  strcmp(col1,'acb')  in partition with coltype  char(30)
-------------------------------------------------------------------------
2163
must all fail!
2164 2165 2166 2167 2168 2169 2170 2171 2172 2173
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(strcmp(col1,'acb')) 
(partition p0 values less than (15),
partition p1 values less than (31));
2174
Got one of the listed errors
2175 2176 2177 2178 2179
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(strcmp(col1,'acb')) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2180
Got one of the listed errors
2181 2182
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(strcmp(col1,'acb'));
2183
Got one of the listed errors
2184 2185 2186 2187 2188
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(strcmp(col1,'acb')) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2189
Got one of the listed errors
2190 2191 2192 2193 2194 2195
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(strcmp(col1,'acb')) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2196
Got one of the listed errors
2197 2198 2199 2200
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (strcmp('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
2201
Got one of the listed errors
2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(strcmp(col1,'acb')) 
(partition p0 values less than (15),
partition p1 values less than (31));
2218
Got one of the listed errors
2219 2220 2221 2222 2223
alter table t22 
partition by list(strcmp(col1,'acb')) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2224
Got one of the listed errors
2225 2226
alter table t33 
partition by hash(strcmp(col1,'acb'));
2227
Got one of the listed errors
2228 2229 2230 2231 2232
alter table t44 
partition by range(colint) 
subpartition by hash(strcmp(col1,'acb')) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2233
Got one of the listed errors
2234 2235 2236 2237 2238 2239
alter table t55 
partition by list(colint)
subpartition by hash(strcmp(col1,'acb')) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2240
Got one of the listed errors
2241 2242 2243 2244
alter table t66  
partition by range(colint) 
(partition p0 values less than (strcmp('i','a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
2245
Got one of the listed errors
2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  crc32(col1)  in partition with coltype  char(30)
-------------------------------------------------------------------------
2261
must all fail!
2262 2263 2264 2265 2266 2267 2268 2269 2270 2271
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 char(30)) engine='MYISAM' 
partition by range(crc32(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2272
Got one of the listed errors
2273 2274 2275 2276 2277
create table t2 (col1 char(30)) engine='MYISAM' 
partition by list(crc32(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2278
Got one of the listed errors
2279 2280
create table t3 (col1 char(30)) engine='MYISAM' 
partition by hash(crc32(col1));
2281
Got one of the listed errors
2282 2283 2284 2285 2286
create table t4 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(crc32(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2287
Got one of the listed errors
2288 2289 2290 2291 2292 2293
create table t5 (colint int, col1 char(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(crc32(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2294
Got one of the listed errors
2295 2296 2297 2298
create table t6 (colint int, col1 char(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (crc32('a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
2299
Got one of the listed errors
2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 char(30)) engine='MYISAM' ;
create table t22 (col1 char(30)) engine='MYISAM' ;
create table t33 (col1 char(30)) engine='MYISAM' ;
create table t44 (colint int, col1 char(30)) engine='MYISAM' ;
create table t55 (colint int, col1 char(30)) engine='MYISAM' ;
create table t66 (colint int, col1 char(30)) engine='MYISAM' ;
alter table t11  
partition by range(crc32(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2316
Got one of the listed errors
2317 2318 2319 2320 2321
alter table t22 
partition by list(crc32(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2322
Got one of the listed errors
2323 2324
alter table t33 
partition by hash(crc32(col1));
2325
Got one of the listed errors
2326 2327 2328 2329 2330
alter table t44 
partition by range(colint) 
subpartition by hash(crc32(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2331
Got one of the listed errors
2332 2333 2334 2335 2336 2337
alter table t55 
partition by list(colint)
subpartition by hash(crc32(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2338
Got one of the listed errors
2339 2340 2341 2342
alter table t66  
partition by range(colint) 
(partition p0 values less than (crc32('a,b,c,d,e,f,g,h,i')),
partition p1 values less than maxvalue);
2343
Got one of the listed errors
2344 2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 2355 2356 2357 2358
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  round(col1)  in partition with coltype  int
-------------------------------------------------------------------------
2359
must all fail!
2360 2361 2362 2363 2364 2365 2366 2367 2368 2369
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(round(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2370
Got one of the listed errors
2371 2372 2373 2374 2375
create table t2 (col1 int) engine='MYISAM' 
partition by list(round(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2376
Got one of the listed errors
2377 2378
create table t3 (col1 int) engine='MYISAM' 
partition by hash(round(col1));
2379
Got one of the listed errors
2380 2381 2382 2383 2384
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(round(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2385
Got one of the listed errors
2386 2387 2388 2389 2390 2391
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(round(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2392
Got one of the listed errors
2393 2394 2395 2396
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (round(15)),
partition p1 values less than maxvalue);
2397
Got one of the listed errors
2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(round(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2414
Got one of the listed errors
2415 2416 2417 2418 2419
alter table t22 
partition by list(round(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2420
Got one of the listed errors
2421 2422
alter table t33 
partition by hash(round(col1));
2423
Got one of the listed errors
2424 2425 2426 2427 2428
alter table t44 
partition by range(colint) 
subpartition by hash(round(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2429
Got one of the listed errors
2430 2431 2432 2433 2434 2435
alter table t55 
partition by list(colint)
subpartition by hash(round(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2436
Got one of the listed errors
2437 2438 2439 2440
alter table t66  
partition by range(colint) 
(partition p0 values less than (round(15)),
partition p1 values less than maxvalue);
2441
Got one of the listed errors
2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  sign(col1)  in partition with coltype  int
-------------------------------------------------------------------------
2457
must all fail!
2458 2459 2460 2461 2462 2463 2464 2465 2466 2467
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(sign(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2468
Got one of the listed errors
2469 2470 2471 2472 2473
create table t2 (col1 int) engine='MYISAM' 
partition by list(sign(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2474
Got one of the listed errors
2475 2476
create table t3 (col1 int) engine='MYISAM' 
partition by hash(sign(col1));
2477
Got one of the listed errors
2478 2479 2480 2481 2482
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(sign(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2483
Got one of the listed errors
2484 2485 2486 2487 2488 2489
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(sign(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2490
Got one of the listed errors
2491 2492 2493 2494
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (sign(123)),
partition p1 values less than maxvalue);
2495
Got one of the listed errors
2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 2506 2507 2508 2509 2510 2511
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(sign(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2512
Got one of the listed errors
2513 2514 2515 2516 2517
alter table t22 
partition by list(sign(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2518
Got one of the listed errors
2519 2520
alter table t33 
partition by hash(sign(col1));
2521
Got one of the listed errors
2522 2523 2524 2525 2526
alter table t44 
partition by range(colint) 
subpartition by hash(sign(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2527
Got one of the listed errors
2528 2529 2530 2531 2532 2533
alter table t55 
partition by list(colint)
subpartition by hash(sign(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2534
Got one of the listed errors
2535 2536 2537 2538
alter table t66  
partition by range(colint) 
(partition p0 values less than (sign(123)),
partition p1 values less than maxvalue);
2539
Got one of the listed errors
2540 2541 2542 2543 2544 2545 2546 2547 2548 2549 2550 2551 2552 2553 2554
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  period_add(col1,5)  in partition with coltype  datetime
-------------------------------------------------------------------------
2555
must all fail!
2556 2557 2558 2559 2560 2561 2562 2563 2564 2565
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 datetime) engine='MYISAM' 
partition by range(period_add(col1,5)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2566
Got one of the listed errors
2567 2568 2569 2570 2571
create table t2 (col1 datetime) engine='MYISAM' 
partition by list(period_add(col1,5)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2572
Got one of the listed errors
2573 2574
create table t3 (col1 datetime) engine='MYISAM' 
partition by hash(period_add(col1,5));
2575
Got one of the listed errors
2576 2577 2578 2579 2580
create table t4 (colint int, col1 datetime) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(period_add(col1,5)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2581
Got one of the listed errors
2582 2583 2584 2585 2586 2587
create table t5 (colint int, col1 datetime) engine='MYISAM' 
partition by list(colint)
subpartition by hash(period_add(col1,5)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2588
Got one of the listed errors
2589 2590 2591 2592
create table t6 (colint int, col1 datetime) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (period_add(9804,5)),
partition p1 values less than maxvalue);
2593
Got one of the listed errors
2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 datetime) engine='MYISAM' ;
create table t22 (col1 datetime) engine='MYISAM' ;
create table t33 (col1 datetime) engine='MYISAM' ;
create table t44 (colint int, col1 datetime) engine='MYISAM' ;
create table t55 (colint int, col1 datetime) engine='MYISAM' ;
create table t66 (colint int, col1 datetime) engine='MYISAM' ;
alter table t11  
partition by range(period_add(col1,5)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2610
Got one of the listed errors
2611 2612 2613 2614 2615
alter table t22 
partition by list(period_add(col1,5)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2616
Got one of the listed errors
2617 2618
alter table t33 
partition by hash(period_add(col1,5));
2619
Got one of the listed errors
2620 2621 2622 2623 2624
alter table t44 
partition by range(colint) 
subpartition by hash(period_add(col1,5)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2625
Got one of the listed errors
2626 2627 2628 2629 2630 2631
alter table t55 
partition by list(colint)
subpartition by hash(period_add(col1,5)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2632
Got one of the listed errors
2633 2634 2635 2636
alter table t66  
partition by range(colint) 
(partition p0 values less than (period_add(9804,5)),
partition p1 values less than maxvalue);
2637
Got one of the listed errors
2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  period_diff(col1,col2)  in partition with coltype  datetime,col2 datetime
-------------------------------------------------------------------------
2653
must all fail!
2654 2655 2656 2657 2658 2659 2660 2661 2662 2663
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 datetime,col2 datetime) engine='MYISAM' 
partition by range(period_diff(col1,col2)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2664
Got one of the listed errors
2665 2666 2667 2668 2669
create table t2 (col1 datetime,col2 datetime) engine='MYISAM' 
partition by list(period_diff(col1,col2)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2670
Got one of the listed errors
2671 2672
create table t3 (col1 datetime,col2 datetime) engine='MYISAM' 
partition by hash(period_diff(col1,col2));
2673
Got one of the listed errors
2674 2675 2676 2677 2678
create table t4 (colint int, col1 datetime,col2 datetime) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(period_diff(col1,col2)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2679
Got one of the listed errors
2680 2681 2682 2683 2684 2685
create table t5 (colint int, col1 datetime,col2 datetime) engine='MYISAM' 
partition by list(colint)
subpartition by hash(period_diff(col1,col2)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2686
Got one of the listed errors
2687 2688 2689 2690
create table t6 (colint int, col1 datetime,col2 datetime) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (period_diff(9809,199907)),
partition p1 values less than maxvalue);
2691
Got one of the listed errors
2692 2693 2694 2695 2696 2697 2698 2699 2700 2701 2702 2703 2704 2705 2706 2707
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 datetime,col2 datetime) engine='MYISAM' ;
create table t22 (col1 datetime,col2 datetime) engine='MYISAM' ;
create table t33 (col1 datetime,col2 datetime) engine='MYISAM' ;
create table t44 (colint int, col1 datetime,col2 datetime) engine='MYISAM' ;
create table t55 (colint int, col1 datetime,col2 datetime) engine='MYISAM' ;
create table t66 (colint int, col1 datetime,col2 datetime) engine='MYISAM' ;
alter table t11  
partition by range(period_diff(col1,col2)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2708
Got one of the listed errors
2709 2710 2711 2712 2713
alter table t22 
partition by list(period_diff(col1,col2)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2714
Got one of the listed errors
2715 2716
alter table t33 
partition by hash(period_diff(col1,col2));
2717
Got one of the listed errors
2718 2719 2720 2721 2722
alter table t44 
partition by range(colint) 
subpartition by hash(period_diff(col1,col2)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2723
Got one of the listed errors
2724 2725 2726 2727 2728 2729
alter table t55 
partition by list(colint)
subpartition by hash(period_diff(col1,col2)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2730
Got one of the listed errors
2731 2732 2733 2734
alter table t66  
partition by range(colint) 
(partition p0 values less than (period_diff(9809,199907)),
partition p1 values less than maxvalue);
2735
Got one of the listed errors
2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  period_diff(col1,col2)  in partition with coltype  int,col2 int
-------------------------------------------------------------------------
2751
must all fail!
2752 2753 2754 2755 2756 2757 2758 2759 2760 2761
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int,col2 int) engine='MYISAM' 
partition by range(period_diff(col1,col2)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2762
Got one of the listed errors
2763 2764 2765 2766 2767
create table t2 (col1 int,col2 int) engine='MYISAM' 
partition by list(period_diff(col1,col2)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2768
Got one of the listed errors
2769 2770
create table t3 (col1 int,col2 int) engine='MYISAM' 
partition by hash(period_diff(col1,col2));
2771
Got one of the listed errors
2772 2773 2774 2775 2776
create table t4 (colint int, col1 int,col2 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(period_diff(col1,col2)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2777
Got one of the listed errors
2778 2779 2780 2781 2782 2783
create table t5 (colint int, col1 int,col2 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(period_diff(col1,col2)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2784
Got one of the listed errors
2785 2786 2787 2788
create table t6 (colint int, col1 int,col2 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (period_diff(9809,199907)),
partition p1 values less than maxvalue);
2789
Got one of the listed errors
2790 2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int,col2 int) engine='MYISAM' ;
create table t22 (col1 int,col2 int) engine='MYISAM' ;
create table t33 (col1 int,col2 int) engine='MYISAM' ;
create table t44 (colint int, col1 int,col2 int) engine='MYISAM' ;
create table t55 (colint int, col1 int,col2 int) engine='MYISAM' ;
create table t66 (colint int, col1 int,col2 int) engine='MYISAM' ;
alter table t11  
partition by range(period_diff(col1,col2)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2806
Got one of the listed errors
2807 2808 2809 2810 2811
alter table t22 
partition by list(period_diff(col1,col2)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2812
Got one of the listed errors
2813 2814
alter table t33 
partition by hash(period_diff(col1,col2));
2815
Got one of the listed errors
2816 2817 2818 2819 2820
alter table t44 
partition by range(colint) 
subpartition by hash(period_diff(col1,col2)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2821
Got one of the listed errors
2822 2823 2824 2825 2826 2827
alter table t55 
partition by list(colint)
subpartition by hash(period_diff(col1,col2)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2828
Got one of the listed errors
2829 2830 2831 2832
alter table t66  
partition by range(colint) 
(partition p0 values less than (period_diff(9809,199907)),
partition p1 values less than maxvalue);
2833
Got one of the listed errors
2834 2835 2836 2837 2838 2839 2840 2841 2842 2843 2844 2845 2846 2847 2848
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  timestampdiff(day,5,col1)  in partition with coltype  datetime
-------------------------------------------------------------------------
2849
must all fail!
2850 2851 2852 2853 2854 2855 2856 2857 2858 2859
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 datetime) engine='MYISAM' 
partition by range(timestampdiff(day,5,col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2860
Got one of the listed errors
2861 2862 2863 2864 2865
create table t2 (col1 datetime) engine='MYISAM' 
partition by list(timestampdiff(day,5,col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2866
Got one of the listed errors
2867 2868
create table t3 (col1 datetime) engine='MYISAM' 
partition by hash(timestampdiff(day,5,col1));
2869
Got one of the listed errors
2870 2871 2872 2873 2874
create table t4 (colint int, col1 datetime) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(timestampdiff(day,5,col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2875
Got one of the listed errors
2876 2877 2878 2879 2880 2881
create table t5 (colint int, col1 datetime) engine='MYISAM' 
partition by list(colint)
subpartition by hash(timestampdiff(day,5,col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2882
Got one of the listed errors
2883 2884 2885 2886
create table t6 (colint int, col1 datetime) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (timestampdiff(YEAR,'2002-05-01','2001-01-01')),
partition p1 values less than maxvalue);
2887
Got one of the listed errors
2888 2889 2890 2891 2892 2893 2894 2895 2896 2897 2898 2899 2900 2901 2902 2903
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 datetime) engine='MYISAM' ;
create table t22 (col1 datetime) engine='MYISAM' ;
create table t33 (col1 datetime) engine='MYISAM' ;
create table t44 (colint int, col1 datetime) engine='MYISAM' ;
create table t55 (colint int, col1 datetime) engine='MYISAM' ;
create table t66 (colint int, col1 datetime) engine='MYISAM' ;
alter table t11  
partition by range(timestampdiff(day,5,col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2904
Got one of the listed errors
2905 2906 2907 2908 2909
alter table t22 
partition by list(timestampdiff(day,5,col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2910
Got one of the listed errors
2911 2912
alter table t33 
partition by hash(timestampdiff(day,5,col1));
2913
Got one of the listed errors
2914 2915 2916 2917 2918
alter table t44 
partition by range(colint) 
subpartition by hash(timestampdiff(day,5,col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2919
Got one of the listed errors
2920 2921 2922 2923 2924 2925
alter table t55 
partition by list(colint)
subpartition by hash(timestampdiff(day,5,col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2926
Got one of the listed errors
2927 2928 2929 2930
alter table t66  
partition by range(colint) 
(partition p0 values less than (timestampdiff(YEAR,'2002-05-01','2001-01-01')),
partition p1 values less than maxvalue);
2931
Got one of the listed errors
2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  unix_timestamp(col1)  in partition with coltype  date
-------------------------------------------------------------------------
2947
must all fail!
2948 2949 2950 2951 2952 2953 2954 2955 2956 2957
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 date) engine='MYISAM' 
partition by range(unix_timestamp(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
2958
Got one of the listed errors
2959 2960 2961 2962 2963
create table t2 (col1 date) engine='MYISAM' 
partition by list(unix_timestamp(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2964
Got one of the listed errors
2965 2966
create table t3 (col1 date) engine='MYISAM' 
partition by hash(unix_timestamp(col1));
2967
Got one of the listed errors
2968 2969 2970 2971 2972
create table t4 (colint int, col1 date) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(unix_timestamp(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
2973
Got one of the listed errors
2974 2975 2976 2977 2978 2979
create table t5 (colint int, col1 date) engine='MYISAM' 
partition by list(colint)
subpartition by hash(unix_timestamp(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2980
Got one of the listed errors
2981 2982 2983 2984
create table t6 (colint int, col1 date) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (unix_timestamp ('2002-05-01')),
partition p1 values less than maxvalue);
2985
Got one of the listed errors
2986 2987 2988 2989 2990 2991 2992 2993 2994 2995 2996 2997 2998 2999 3000 3001
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 date) engine='MYISAM' ;
create table t22 (col1 date) engine='MYISAM' ;
create table t33 (col1 date) engine='MYISAM' ;
create table t44 (colint int, col1 date) engine='MYISAM' ;
create table t55 (colint int, col1 date) engine='MYISAM' ;
create table t66 (colint int, col1 date) engine='MYISAM' ;
alter table t11  
partition by range(unix_timestamp(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
3002
Got one of the listed errors
3003 3004 3005 3006 3007
alter table t22 
partition by list(unix_timestamp(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3008
Got one of the listed errors
3009 3010
alter table t33 
partition by hash(unix_timestamp(col1));
3011
Got one of the listed errors
3012 3013 3014 3015 3016
alter table t44 
partition by range(colint) 
subpartition by hash(unix_timestamp(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3017
Got one of the listed errors
3018 3019 3020 3021 3022 3023
alter table t55 
partition by list(colint)
subpartition by hash(unix_timestamp(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3024
Got one of the listed errors
3025 3026 3027 3028
alter table t66  
partition by range(colint) 
(partition p0 values less than (unix_timestamp ('2002-05-01')),
partition p1 values less than maxvalue);
3029
Got one of the listed errors
3030 3031 3032 3033 3034 3035 3036 3037 3038 3039 3040 3041 3042 3043 3044
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  week(col1)  in partition with coltype  datetime
-------------------------------------------------------------------------
3045
must all fail!
3046 3047 3048 3049 3050 3051 3052 3053 3054 3055
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 datetime) engine='MYISAM' 
partition by range(week(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
3056
Got one of the listed errors
3057 3058 3059 3060 3061
create table t2 (col1 datetime) engine='MYISAM' 
partition by list(week(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3062
Got one of the listed errors
3063 3064
create table t3 (col1 datetime) engine='MYISAM' 
partition by hash(week(col1));
3065
Got one of the listed errors
3066 3067 3068 3069 3070
create table t4 (colint int, col1 datetime) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(week(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3071
Got one of the listed errors
3072 3073 3074 3075 3076 3077
create table t5 (colint int, col1 datetime) engine='MYISAM' 
partition by list(colint)
subpartition by hash(week(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3078
Got one of the listed errors
3079 3080 3081 3082
create table t6 (colint int, col1 datetime) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (week('2002-05-01')),
partition p1 values less than maxvalue);
3083
Got one of the listed errors
3084 3085 3086 3087 3088 3089 3090 3091 3092 3093 3094 3095 3096 3097 3098 3099
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 datetime) engine='MYISAM' ;
create table t22 (col1 datetime) engine='MYISAM' ;
create table t33 (col1 datetime) engine='MYISAM' ;
create table t44 (colint int, col1 datetime) engine='MYISAM' ;
create table t55 (colint int, col1 datetime) engine='MYISAM' ;
create table t66 (colint int, col1 datetime) engine='MYISAM' ;
alter table t11  
partition by range(week(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
3100
Got one of the listed errors
3101 3102 3103 3104 3105
alter table t22 
partition by list(week(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3106
Got one of the listed errors
3107 3108
alter table t33 
partition by hash(week(col1));
3109
Got one of the listed errors
3110 3111 3112 3113 3114
alter table t44 
partition by range(colint) 
subpartition by hash(week(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3115
Got one of the listed errors
3116 3117 3118 3119 3120 3121
alter table t55 
partition by list(colint)
subpartition by hash(week(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3122
Got one of the listed errors
3123 3124 3125 3126
alter table t66  
partition by range(colint) 
(partition p0 values less than (week('2002-05-01')),
partition p1 values less than maxvalue);
3127 3128 3129 3130 3131 3132 3133 3134 3135 3136 3137 3138 3139 3140 3141 3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152 3153 3154 3155 3156 3157 3158 3159 3160 3161 3162 3163 3164 3165 3166 3167 3168 3169 3170 3171 3172 3173 3174 3175 3176 3177 3178 3179 3180 3181 3182 3183 3184 3185 3186 3187 3188 3189 3190 3191 3192 3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203 3204 3205 3206 3207 3208 3209 3210 3211 3212 3213 3214 3215 3216 3217 3218 3219 3220 3221 3222 3223 3224 3225
Got one of the listed errors
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  weekofyear(col1)  in partition with coltype  datetime
-------------------------------------------------------------------------
must all fail!
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 datetime) engine='MYISAM' 
partition by range(weekofyear(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
create table t2 (col1 datetime) engine='MYISAM' 
partition by list(weekofyear(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
create table t3 (col1 datetime) engine='MYISAM' 
partition by hash(weekofyear(col1));
Got one of the listed errors
create table t4 (colint int, col1 datetime) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(weekofyear(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
create table t5 (colint int, col1 datetime) engine='MYISAM' 
partition by list(colint)
subpartition by hash(weekofyear(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
create table t6 (colint int, col1 datetime) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (weekofyear('2002-05-01')),
partition p1 values less than maxvalue);
Got one of the listed errors
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 datetime) engine='MYISAM' ;
create table t22 (col1 datetime) engine='MYISAM' ;
create table t33 (col1 datetime) engine='MYISAM' ;
create table t44 (colint int, col1 datetime) engine='MYISAM' ;
create table t55 (colint int, col1 datetime) engine='MYISAM' ;
create table t66 (colint int, col1 datetime) engine='MYISAM' ;
alter table t11  
partition by range(weekofyear(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
alter table t22 
partition by list(weekofyear(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
alter table t33 
partition by hash(weekofyear(col1));
Got one of the listed errors
alter table t44 
partition by range(colint) 
subpartition by hash(weekofyear(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
Got one of the listed errors
alter table t55 
partition by list(colint)
subpartition by hash(weekofyear(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
Got one of the listed errors
alter table t66  
partition by range(colint) 
(partition p0 values less than (weekofyear('2002-05-01')),
partition p1 values less than maxvalue);
Got one of the listed errors
3226 3227 3228 3229 3230 3231 3232 3233 3234 3235 3236 3237 3238 3239 3240
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  cast(col1 as signed)  in partition with coltype  varchar(30)
-------------------------------------------------------------------------
3241
must all fail!
3242 3243 3244 3245 3246 3247 3248 3249 3250 3251
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 varchar(30)) engine='MYISAM' 
partition by range(cast(col1 as signed)) 
(partition p0 values less than (15),
partition p1 values less than (31));
3252
Got one of the listed errors
3253 3254 3255 3256 3257
create table t2 (col1 varchar(30)) engine='MYISAM' 
partition by list(cast(col1 as signed)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3258
Got one of the listed errors
3259 3260
create table t3 (col1 varchar(30)) engine='MYISAM' 
partition by hash(cast(col1 as signed));
3261
Got one of the listed errors
3262 3263 3264 3265 3266
create table t4 (colint int, col1 varchar(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(cast(col1 as signed)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3267
Got one of the listed errors
3268 3269 3270 3271 3272 3273
create table t5 (colint int, col1 varchar(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(cast(col1 as signed)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3274
Got one of the listed errors
3275 3276 3277 3278
create table t6 (colint int, col1 varchar(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (cast(123 as signed)),
partition p1 values less than maxvalue);
3279
Got one of the listed errors
3280 3281 3282 3283 3284 3285 3286 3287 3288 3289 3290 3291 3292 3293 3294 3295
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 varchar(30)) engine='MYISAM' ;
create table t22 (col1 varchar(30)) engine='MYISAM' ;
create table t33 (col1 varchar(30)) engine='MYISAM' ;
create table t44 (colint int, col1 varchar(30)) engine='MYISAM' ;
create table t55 (colint int, col1 varchar(30)) engine='MYISAM' ;
create table t66 (colint int, col1 varchar(30)) engine='MYISAM' ;
alter table t11  
partition by range(cast(col1 as signed)) 
(partition p0 values less than (15),
partition p1 values less than (31));
3296
Got one of the listed errors
3297 3298 3299 3300 3301
alter table t22 
partition by list(cast(col1 as signed)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3302
Got one of the listed errors
3303 3304
alter table t33 
partition by hash(cast(col1 as signed));
3305
Got one of the listed errors
3306 3307 3308 3309 3310
alter table t44 
partition by range(colint) 
subpartition by hash(cast(col1 as signed)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3311
Got one of the listed errors
3312 3313 3314 3315 3316 3317
alter table t55 
partition by list(colint)
subpartition by hash(cast(col1 as signed)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3318
Got one of the listed errors
3319 3320 3321 3322
alter table t66  
partition by range(colint) 
(partition p0 values less than (cast(123 as signed)),
partition p1 values less than maxvalue);
3323
Got one of the listed errors
3324 3325 3326 3327 3328 3329 3330 3331 3332 3333 3334 3335 3336 3337 3338
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  convert(col1,unsigned)  in partition with coltype  varchar(30)
-------------------------------------------------------------------------
3339
must all fail!
3340 3341 3342 3343 3344 3345 3346 3347 3348 3349
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 varchar(30)) engine='MYISAM' 
partition by range(convert(col1,unsigned)) 
(partition p0 values less than (15),
partition p1 values less than (31));
3350
Got one of the listed errors
3351 3352 3353 3354 3355
create table t2 (col1 varchar(30)) engine='MYISAM' 
partition by list(convert(col1,unsigned)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3356
Got one of the listed errors
3357 3358
create table t3 (col1 varchar(30)) engine='MYISAM' 
partition by hash(convert(col1,unsigned));
3359
Got one of the listed errors
3360 3361 3362 3363 3364
create table t4 (colint int, col1 varchar(30)) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(convert(col1,unsigned)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3365
Got one of the listed errors
3366 3367 3368 3369 3370 3371
create table t5 (colint int, col1 varchar(30)) engine='MYISAM' 
partition by list(colint)
subpartition by hash(convert(col1,unsigned)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3372
Got one of the listed errors
3373 3374 3375 3376
create table t6 (colint int, col1 varchar(30)) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (convert(123,unsigned)),
partition p1 values less than maxvalue);
3377
Got one of the listed errors
3378 3379 3380 3381 3382 3383 3384 3385 3386 3387 3388 3389 3390 3391 3392 3393
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 varchar(30)) engine='MYISAM' ;
create table t22 (col1 varchar(30)) engine='MYISAM' ;
create table t33 (col1 varchar(30)) engine='MYISAM' ;
create table t44 (colint int, col1 varchar(30)) engine='MYISAM' ;
create table t55 (colint int, col1 varchar(30)) engine='MYISAM' ;
create table t66 (colint int, col1 varchar(30)) engine='MYISAM' ;
alter table t11  
partition by range(convert(col1,unsigned)) 
(partition p0 values less than (15),
partition p1 values less than (31));
3394
Got one of the listed errors
3395 3396 3397 3398 3399
alter table t22 
partition by list(convert(col1,unsigned)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3400
Got one of the listed errors
3401 3402
alter table t33 
partition by hash(convert(col1,unsigned));
3403
Got one of the listed errors
3404 3405 3406 3407 3408
alter table t44 
partition by range(colint) 
subpartition by hash(convert(col1,unsigned)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3409
Got one of the listed errors
3410 3411 3412 3413 3414 3415
alter table t55 
partition by list(colint)
subpartition by hash(convert(col1,unsigned)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3416
Got one of the listed errors
3417 3418 3419 3420
alter table t66  
partition by range(colint) 
(partition p0 values less than (convert(123,unsigned)),
partition p1 values less than maxvalue);
3421
Got one of the listed errors
3422 3423 3424 3425 3426 3427 3428 3429 3430 3431 3432 3433 3434 3435 3436
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  col1 | 20  in partition with coltype  int
-------------------------------------------------------------------------
3437
must all fail!
3438 3439 3440 3441 3442 3443 3444 3445 3446 3447
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(col1 | 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3448
Got one of the listed errors
3449 3450 3451 3452 3453
create table t2 (col1 int) engine='MYISAM' 
partition by list(col1 | 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3454
Got one of the listed errors
3455 3456
create table t3 (col1 int) engine='MYISAM' 
partition by hash(col1 | 20);
3457
Got one of the listed errors
3458 3459 3460 3461 3462
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(col1 | 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3463
Got one of the listed errors
3464 3465 3466 3467 3468 3469
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(col1 | 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3470
Got one of the listed errors
3471 3472 3473 3474
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (10 | 20),
partition p1 values less than maxvalue);
3475
Got one of the listed errors
3476 3477 3478 3479 3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490 3491
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(col1 | 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3492
Got one of the listed errors
3493 3494 3495 3496 3497
alter table t22 
partition by list(col1 | 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3498
Got one of the listed errors
3499 3500
alter table t33 
partition by hash(col1 | 20);
3501
Got one of the listed errors
3502 3503 3504 3505 3506
alter table t44 
partition by range(colint) 
subpartition by hash(col1 | 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3507
Got one of the listed errors
3508 3509 3510 3511 3512 3513
alter table t55 
partition by list(colint)
subpartition by hash(col1 | 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3514
Got one of the listed errors
3515 3516 3517 3518
alter table t66  
partition by range(colint) 
(partition p0 values less than (10 | 20),
partition p1 values less than maxvalue);
3519
Got one of the listed errors
3520 3521 3522 3523 3524 3525 3526 3527 3528 3529 3530 3531 3532 3533 3534
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  col1 & 20  in partition with coltype  int
-------------------------------------------------------------------------
3535
must all fail!
3536 3537 3538 3539 3540 3541 3542 3543 3544 3545
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(col1 & 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3546
Got one of the listed errors
3547 3548 3549 3550 3551
create table t2 (col1 int) engine='MYISAM' 
partition by list(col1 & 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3552
Got one of the listed errors
3553 3554
create table t3 (col1 int) engine='MYISAM' 
partition by hash(col1 & 20);
3555
Got one of the listed errors
3556 3557 3558 3559 3560
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(col1 & 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3561
Got one of the listed errors
3562 3563 3564 3565 3566 3567
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(col1 & 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3568
Got one of the listed errors
3569 3570 3571 3572
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (10 & 20),
partition p1 values less than maxvalue);
3573
Got one of the listed errors
3574 3575 3576 3577 3578 3579 3580 3581 3582 3583 3584 3585 3586 3587 3588 3589
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(col1 & 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3590
Got one of the listed errors
3591 3592 3593 3594 3595
alter table t22 
partition by list(col1 & 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3596
Got one of the listed errors
3597 3598
alter table t33 
partition by hash(col1 & 20);
3599
Got one of the listed errors
3600 3601 3602 3603 3604
alter table t44 
partition by range(colint) 
subpartition by hash(col1 & 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3605
Got one of the listed errors
3606 3607 3608 3609 3610 3611
alter table t55 
partition by list(colint)
subpartition by hash(col1 & 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3612
Got one of the listed errors
3613 3614 3615 3616
alter table t66  
partition by range(colint) 
(partition p0 values less than (10 & 20),
partition p1 values less than maxvalue);
3617
Got one of the listed errors
3618 3619 3620 3621 3622 3623 3624 3625 3626 3627 3628 3629 3630 3631 3632
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  col1 ^ 20  in partition with coltype  int
-------------------------------------------------------------------------
3633
must all fail!
3634 3635 3636 3637 3638 3639 3640 3641 3642 3643
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(col1 ^ 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3644
Got one of the listed errors
3645 3646 3647 3648 3649
create table t2 (col1 int) engine='MYISAM' 
partition by list(col1 ^ 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3650
Got one of the listed errors
3651 3652
create table t3 (col1 int) engine='MYISAM' 
partition by hash(col1 ^ 20);
3653
Got one of the listed errors
3654 3655 3656 3657 3658
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(col1 ^ 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3659
Got one of the listed errors
3660 3661 3662 3663 3664 3665
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(col1 ^ 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3666
Got one of the listed errors
3667 3668 3669 3670
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (10 ^ 20),
partition p1 values less than maxvalue);
3671
Got one of the listed errors
3672 3673 3674 3675 3676 3677 3678 3679 3680 3681 3682 3683 3684 3685 3686 3687
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(col1 ^ 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3688
Got one of the listed errors
3689 3690 3691 3692 3693
alter table t22 
partition by list(col1 ^ 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3694
Got one of the listed errors
3695 3696
alter table t33 
partition by hash(col1 ^ 20);
3697
Got one of the listed errors
3698 3699 3700 3701 3702
alter table t44 
partition by range(colint) 
subpartition by hash(col1 ^ 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3703
Got one of the listed errors
3704 3705 3706 3707 3708 3709
alter table t55 
partition by list(colint)
subpartition by hash(col1 ^ 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3710
Got one of the listed errors
3711 3712 3713 3714
alter table t66  
partition by range(colint) 
(partition p0 values less than (10 ^ 20),
partition p1 values less than maxvalue);
3715
Got one of the listed errors
3716 3717 3718 3719 3720 3721 3722 3723 3724 3725 3726 3727 3728 3729 3730
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  col1 << 20  in partition with coltype  int
-------------------------------------------------------------------------
3731
must all fail!
3732 3733 3734 3735 3736 3737 3738 3739 3740 3741
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(col1 << 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3742
Got one of the listed errors
3743 3744 3745 3746 3747
create table t2 (col1 int) engine='MYISAM' 
partition by list(col1 << 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3748
Got one of the listed errors
3749 3750
create table t3 (col1 int) engine='MYISAM' 
partition by hash(col1 << 20);
3751
Got one of the listed errors
3752 3753 3754 3755 3756
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(col1 << 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3757
Got one of the listed errors
3758 3759 3760 3761 3762 3763
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(col1 << 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3764
Got one of the listed errors
3765 3766 3767 3768
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (10 << 20),
partition p1 values less than maxvalue);
3769
Got one of the listed errors
3770 3771 3772 3773 3774 3775 3776 3777 3778 3779 3780 3781 3782 3783 3784 3785
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(col1 << 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3786
Got one of the listed errors
3787 3788 3789 3790 3791
alter table t22 
partition by list(col1 << 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3792
Got one of the listed errors
3793 3794
alter table t33 
partition by hash(col1 << 20);
3795
Got one of the listed errors
3796 3797 3798 3799 3800
alter table t44 
partition by range(colint) 
subpartition by hash(col1 << 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3801
Got one of the listed errors
3802 3803 3804 3805 3806 3807
alter table t55 
partition by list(colint)
subpartition by hash(col1 << 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3808
Got one of the listed errors
3809 3810 3811 3812
alter table t66  
partition by range(colint) 
(partition p0 values less than (10 << 20),
partition p1 values less than maxvalue);
3813
Got one of the listed errors
3814 3815 3816 3817 3818 3819 3820 3821 3822 3823 3824 3825 3826 3827 3828
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  col1 >> 20  in partition with coltype  int
-------------------------------------------------------------------------
3829
must all fail!
3830 3831 3832 3833 3834 3835 3836 3837 3838 3839
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(col1 >> 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3840
Got one of the listed errors
3841 3842 3843 3844 3845
create table t2 (col1 int) engine='MYISAM' 
partition by list(col1 >> 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3846
Got one of the listed errors
3847 3848
create table t3 (col1 int) engine='MYISAM' 
partition by hash(col1 >> 20);
3849
Got one of the listed errors
3850 3851 3852 3853 3854
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(col1 >> 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3855
Got one of the listed errors
3856 3857 3858 3859 3860 3861
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(col1 >> 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3862
Got one of the listed errors
3863 3864 3865 3866
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (10 >> 20),
partition p1 values less than maxvalue);
3867
Got one of the listed errors
3868 3869 3870 3871 3872 3873 3874 3875 3876 3877 3878 3879 3880 3881 3882 3883
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(col1 >> 20) 
(partition p0 values less than (15),
partition p1 values less than (31));
3884
Got one of the listed errors
3885 3886 3887 3888 3889
alter table t22 
partition by list(col1 >> 20) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3890
Got one of the listed errors
3891 3892
alter table t33 
partition by hash(col1 >> 20);
3893
Got one of the listed errors
3894 3895 3896 3897 3898
alter table t44 
partition by range(colint) 
subpartition by hash(col1 >> 20) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3899
Got one of the listed errors
3900 3901 3902 3903 3904 3905
alter table t55 
partition by list(colint)
subpartition by hash(col1 >> 20) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3906
Got one of the listed errors
3907 3908 3909 3910
alter table t66  
partition by range(colint) 
(partition p0 values less than (10 >> 20),
partition p1 values less than maxvalue);
3911
Got one of the listed errors
3912 3913 3914 3915 3916 3917 3918 3919 3920 3921 3922 3923 3924 3925 3926
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  ~col1  in partition with coltype  int
-------------------------------------------------------------------------
3927
must all fail!
3928 3929 3930 3931 3932 3933 3934 3935 3936 3937
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(~col1) 
(partition p0 values less than (15),
partition p1 values less than (31));
3938
Got one of the listed errors
3939 3940 3941 3942 3943
create table t2 (col1 int) engine='MYISAM' 
partition by list(~col1) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3944
Got one of the listed errors
3945 3946
create table t3 (col1 int) engine='MYISAM' 
partition by hash(~col1);
3947
Got one of the listed errors
3948 3949 3950 3951 3952
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(~col1) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3953
Got one of the listed errors
3954 3955 3956 3957 3958 3959
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(~col1) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3960
Got one of the listed errors
3961 3962 3963 3964
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (~20),
partition p1 values less than maxvalue);
3965
Got one of the listed errors
3966 3967 3968 3969 3970 3971 3972 3973 3974 3975 3976 3977 3978 3979 3980 3981
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(~col1) 
(partition p0 values less than (15),
partition p1 values less than (31));
3982
Got one of the listed errors
3983 3984 3985 3986 3987
alter table t22 
partition by list(~col1) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3988
Got one of the listed errors
3989 3990
alter table t33 
partition by hash(~col1);
3991
Got one of the listed errors
3992 3993 3994 3995 3996
alter table t44 
partition by range(colint) 
subpartition by hash(~col1) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
3997
Got one of the listed errors
3998 3999 4000 4001 4002 4003
alter table t55 
partition by list(colint)
subpartition by hash(~col1) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4004
Got one of the listed errors
4005 4006 4007 4008
alter table t66  
partition by range(colint) 
(partition p0 values less than (~20),
partition p1 values less than maxvalue);
4009
Got one of the listed errors
4010 4011 4012 4013 4014 4015 4016 4017 4018 4019 4020 4021 4022 4023 4024
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  bit_count(col1)  in partition with coltype  int
-------------------------------------------------------------------------
4025
must all fail!
4026 4027 4028 4029 4030 4031 4032 4033 4034 4035
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(bit_count(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
4036
Got one of the listed errors
4037 4038 4039 4040 4041
create table t2 (col1 int) engine='MYISAM' 
partition by list(bit_count(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4042
Got one of the listed errors
4043 4044
create table t3 (col1 int) engine='MYISAM' 
partition by hash(bit_count(col1));
4045
Got one of the listed errors
4046 4047 4048 4049 4050
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(bit_count(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
4051
Got one of the listed errors
4052 4053 4054 4055 4056 4057
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(bit_count(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4058
Got one of the listed errors
4059 4060 4061 4062
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (bit_count(20)),
partition p1 values less than maxvalue);
4063
Got one of the listed errors
4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(bit_count(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
4080
Got one of the listed errors
4081 4082 4083 4084 4085
alter table t22 
partition by list(bit_count(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4086
Got one of the listed errors
4087 4088
alter table t33 
partition by hash(bit_count(col1));
4089
Got one of the listed errors
4090 4091 4092 4093 4094
alter table t44 
partition by range(colint) 
subpartition by hash(bit_count(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
4095
Got one of the listed errors
4096 4097 4098 4099 4100 4101
alter table t55 
partition by list(colint)
subpartition by hash(bit_count(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4102
Got one of the listed errors
4103 4104 4105 4106
alter table t66  
partition by range(colint) 
(partition p0 values less than (bit_count(20)),
partition p1 values less than maxvalue);
4107
Got one of the listed errors
4108 4109 4110 4111 4112 4113 4114 4115 4116 4117 4118 4119 4120 4121 4122
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
-------------------------------------------------------------------------
---  inet_aton(col1)  in partition with coltype  int
-------------------------------------------------------------------------
4123
must all fail!
4124 4125 4126 4127 4128 4129 4130 4131 4132 4133
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(inet_aton(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
4134
Got one of the listed errors
4135 4136 4137 4138 4139
create table t2 (col1 int) engine='MYISAM' 
partition by list(inet_aton(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4140
Got one of the listed errors
4141 4142
create table t3 (col1 int) engine='MYISAM' 
partition by hash(inet_aton(col1));
4143
Got one of the listed errors
4144 4145 4146 4147 4148
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(inet_aton(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
4149
Got one of the listed errors
4150 4151 4152 4153 4154 4155
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(inet_aton(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4156
Got one of the listed errors
4157 4158 4159 4160
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (inet_aton('192.168.1.1')),
partition p1 values less than maxvalue);
4161
Got one of the listed errors
4162 4163 4164 4165 4166 4167 4168 4169 4170 4171 4172 4173 4174 4175 4176 4177
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(inet_aton(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
4178
Got one of the listed errors
4179 4180 4181 4182 4183
alter table t22 
partition by list(inet_aton(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4184
Got one of the listed errors
4185 4186
alter table t33 
partition by hash(inet_aton(col1));
4187
Got one of the listed errors
4188 4189 4190 4191 4192
alter table t44 
partition by range(colint) 
subpartition by hash(inet_aton(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
4193
Got one of the listed errors
4194 4195 4196 4197 4198 4199
alter table t55 
partition by list(colint)
subpartition by hash(inet_aton(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4200
Got one of the listed errors
4201 4202 4203 4204
alter table t66  
partition by range(colint) 
(partition p0 values less than (inet_aton('192.168.1.1')),
partition p1 values less than maxvalue);
4205
Got one of the listed errors
4206 4207 4208 4209 4210 4211 4212 4213 4214 4215 4216 4217 4218 4219 4220 4221
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
set @var =20;
-------------------------------------------------------------------------
---  bit_length(col1)+@var-@var  in partition with coltype  int
-------------------------------------------------------------------------
4222
must all fail!
4223 4224 4225 4226 4227 4228 4229 4230 4231 4232
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(bit_length(col1)+@var-@var) 
(partition p0 values less than (15),
partition p1 values less than (31));
4233
Got one of the listed errors
4234 4235 4236 4237 4238
create table t2 (col1 int) engine='MYISAM' 
partition by list(bit_length(col1)+@var-@var) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4239
Got one of the listed errors
4240 4241
create table t3 (col1 int) engine='MYISAM' 
partition by hash(bit_length(col1)+@var-@var);
4242
Got one of the listed errors
4243 4244 4245 4246 4247
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(bit_length(col1)+@var-@var) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
4248
Got one of the listed errors
4249 4250 4251 4252 4253 4254
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(bit_length(col1)+@var-@var) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4255
Got one of the listed errors
4256 4257 4258 4259
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (bit_length(20)+@var-@var),
partition p1 values less than maxvalue);
4260
Got one of the listed errors
4261 4262 4263 4264 4265 4266 4267 4268 4269 4270 4271 4272 4273 4274 4275 4276
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(bit_length(col1)+@var-@var) 
(partition p0 values less than (15),
partition p1 values less than (31));
4277
Got one of the listed errors
4278 4279 4280 4281 4282
alter table t22 
partition by list(bit_length(col1)+@var-@var) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4283
Got one of the listed errors
4284 4285
alter table t33 
partition by hash(bit_length(col1)+@var-@var);
4286
Got one of the listed errors
4287 4288 4289 4290 4291
alter table t44 
partition by range(colint) 
subpartition by hash(bit_length(col1)+@var-@var) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
4292
Got one of the listed errors
4293 4294 4295 4296 4297 4298
alter table t55 
partition by list(colint)
subpartition by hash(bit_length(col1)+@var-@var) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4299
Got one of the listed errors
4300 4301 4302 4303
alter table t66  
partition by range(colint) 
(partition p0 values less than (bit_length(20)+@var-@var),
partition p1 values less than maxvalue);
4304
Got one of the listed errors
4305 4306 4307 4308 4309 4310 4311 4312 4313 4314 4315 4316 4317 4318 4319 4320 4321 4322 4323 4324 4325 4326 4327 4328 4329 4330 4331 4332 4333 4334 4335 4336 4337 4338 4339 4340
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create function getmaxsigned_t1(col int) returns int
begin
declare done int default 0;
declare v4 int;
declare max int;
declare cur1 cursor for 
select col from t1; 
declare continue handler for sqlstate '01000' set done = 1;
declare continue handler for sqlstate '02000' set done = 1;
open cur1;
set max = 0;
fetch cur1 into v4;
wl_loop: WHILE NOT done DO
fetch cur1 into v4;
IF v4 > max
then set max = v4;
END IF;
END WHILE wl_loop;
close cur1;
return max;
end//
-------------------------------------------------------------------------
---  getmaxsigned_t1(col1)  in partition with coltype  int
-------------------------------------------------------------------------
4341
must all fail!
4342 4343 4344 4345 4346 4347 4348 4349 4350 4351
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
create table t1 (col1 int) engine='MYISAM' 
partition by range(getmaxsigned_t1(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
4352
Got one of the listed errors
4353 4354 4355 4356 4357
create table t2 (col1 int) engine='MYISAM' 
partition by list(getmaxsigned_t1(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4358
Got one of the listed errors
4359 4360
create table t3 (col1 int) engine='MYISAM' 
partition by hash(getmaxsigned_t1(col1));
4361
Got one of the listed errors
4362 4363 4364 4365 4366
create table t4 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
subpartition by hash(getmaxsigned_t1(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
4367
Got one of the listed errors
4368 4369 4370 4371 4372 4373
create table t5 (colint int, col1 int) engine='MYISAM' 
partition by list(colint)
subpartition by hash(getmaxsigned_t1(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4374
Got one of the listed errors
4375 4376 4377 4378
create table t6 (colint int, col1 int) engine='MYISAM' 
partition by range(colint) 
(partition p0 values less than (getmaxsigned(10)),
partition p1 values less than maxvalue);
4379
Got one of the listed errors
4380 4381 4382 4383 4384 4385 4386 4387 4388 4389 4390 4391 4392 4393 4394 4395
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
create table t11 (col1 int) engine='MYISAM' ;
create table t22 (col1 int) engine='MYISAM' ;
create table t33 (col1 int) engine='MYISAM' ;
create table t44 (colint int, col1 int) engine='MYISAM' ;
create table t55 (colint int, col1 int) engine='MYISAM' ;
create table t66 (colint int, col1 int) engine='MYISAM' ;
alter table t11  
partition by range(getmaxsigned_t1(col1)) 
(partition p0 values less than (15),
partition p1 values less than (31));
4396
Got one of the listed errors
4397 4398 4399 4400 4401
alter table t22 
partition by list(getmaxsigned_t1(col1)) 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4402
Got one of the listed errors
4403 4404
alter table t33 
partition by hash(getmaxsigned_t1(col1));
4405
Got one of the listed errors
4406 4407 4408 4409 4410
alter table t44 
partition by range(colint) 
subpartition by hash(getmaxsigned_t1(col1)) subpartitions 2 
(partition p0 values less than (15),
partition p1 values less than (31));
4411
Got one of the listed errors
4412 4413 4414 4415 4416 4417
alter table t55 
partition by list(colint)
subpartition by hash(getmaxsigned_t1(col1)) subpartitions 2 
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
4418
Got one of the listed errors
4419 4420 4421 4422
alter table t66  
partition by range(colint) 
(partition p0 values less than (getmaxsigned(10)),
partition p1 values less than maxvalue);
4423
Got one of the listed errors
4424 4425 4426 4427 4428 4429 4430 4431 4432 4433 4434 4435 4436
drop table if exists t1 ;
drop table if exists t2 ;
drop table if exists t3 ;
drop table if exists t4 ;
drop table if exists t5 ;
drop table if exists t6 ;
drop table if exists t11 ;
drop table if exists t22 ;
drop table if exists t33 ;
drop table if exists t44 ;
drop table if exists t55 ;
drop table if exists t66 ;
drop function if exists getmaxsigned_t1;