1create table t1 (a timestamp not null, primary key(a)) engine='TokuDB' 2partition by key (a) ( 3partition pa1 max_rows=20 min_rows=2, 4partition pa2 max_rows=30 min_rows=3, 5partition pa3 max_rows=30 min_rows=4, 6partition pa4 max_rows=40 min_rows=2); 7show create table t1; 8Table Create Table 9t1 CREATE TABLE `t1` ( 10 `a` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 11 PRIMARY KEY (`a`) 12) ENGINE=TokuDB DEFAULT CHARSET=latin1 13/*!50100 PARTITION BY KEY (a) 14(PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = TokuDB, 15 PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = TokuDB, 16 PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = TokuDB, 17 PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = TokuDB) */ 18insert into t1 values ('1975-01-01 21:21:21'), ('2020-12-31 12:10:30'), ('1980-10-14 03:03'), ('2000-06-15 23:59'); 19select * from t1; 20a 212000-06-15 23:59:00 222020-12-31 12:10:30 231975-01-01 21:21:21 241980-10-14 03:03:00 25select * from t1 where a=19801014030300; 26a 271980-10-14 03:03:00 28delete from t1 where a=19801014030300; 29select * from t1; 30a 312000-06-15 23:59:00 322020-12-31 12:10:30 331975-01-01 21:21:21 34drop table t1; 35create table t2 (a timestamp not null, primary key(a)) engine='TokuDB' 36partition by key (a) partitions 12; 37show create table t2; 38Table Create Table 39t2 CREATE TABLE `t2` ( 40 `a` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 41 PRIMARY KEY (`a`) 42) ENGINE=TokuDB DEFAULT CHARSET=latin1 43/*!50100 PARTITION BY KEY (a) 44PARTITIONS 12 */ 45insert into t2 values ('1975-01-01 0:1:1'), ('2020-12-31 10:11:12'), ('1980-10-14 13:14:15'), ('2000-06-15 14:15:16'); 46select * from t2; 47a 481980-10-14 13:14:15 492000-06-15 14:15:16 502020-12-31 10:11:12 511975-01-01 00:01:01 52select * from t2 where a='1980-10-14 13:14:15'; 53a 541980-10-14 13:14:15 55delete from t2 where a='1980-10-14 13:14:15'; 56select * from t2; 57a 582000-06-15 14:15:16 592020-12-31 10:11:12 601975-01-01 00:01:01 61delete from t2; 6259 inserts; 63insert into t2 values (19710101000000+59); 64insert into t2 values (19710101000000+58); 65insert into t2 values (19710101000000+57); 66insert into t2 values (19710101000000+56); 67insert into t2 values (19710101000000+55); 68insert into t2 values (19710101000000+54); 69insert into t2 values (19710101000000+53); 70insert into t2 values (19710101000000+52); 71insert into t2 values (19710101000000+51); 72insert into t2 values (19710101000000+50); 73insert into t2 values (19710101000000+49); 74insert into t2 values (19710101000000+48); 75insert into t2 values (19710101000000+47); 76insert into t2 values (19710101000000+46); 77insert into t2 values (19710101000000+45); 78insert into t2 values (19710101000000+44); 79insert into t2 values (19710101000000+43); 80insert into t2 values (19710101000000+42); 81insert into t2 values (19710101000000+41); 82insert into t2 values (19710101000000+40); 83insert into t2 values (19710101000000+39); 84insert into t2 values (19710101000000+38); 85insert into t2 values (19710101000000+37); 86insert into t2 values (19710101000000+36); 87insert into t2 values (19710101000000+35); 88insert into t2 values (19710101000000+34); 89insert into t2 values (19710101000000+33); 90insert into t2 values (19710101000000+32); 91insert into t2 values (19710101000000+31); 92insert into t2 values (19710101000000+30); 93insert into t2 values (19710101000000+29); 94insert into t2 values (19710101000000+28); 95insert into t2 values (19710101000000+27); 96insert into t2 values (19710101000000+26); 97insert into t2 values (19710101000000+25); 98insert into t2 values (19710101000000+24); 99insert into t2 values (19710101000000+23); 100insert into t2 values (19710101000000+22); 101insert into t2 values (19710101000000+21); 102insert into t2 values (19710101000000+20); 103insert into t2 values (19710101000000+19); 104insert into t2 values (19710101000000+18); 105insert into t2 values (19710101000000+17); 106insert into t2 values (19710101000000+16); 107insert into t2 values (19710101000000+15); 108insert into t2 values (19710101000000+14); 109insert into t2 values (19710101000000+13); 110insert into t2 values (19710101000000+12); 111insert into t2 values (19710101000000+11); 112insert into t2 values (19710101000000+10); 113insert into t2 values (19710101000000+9); 114insert into t2 values (19710101000000+8); 115insert into t2 values (19710101000000+7); 116insert into t2 values (19710101000000+6); 117insert into t2 values (19710101000000+5); 118insert into t2 values (19710101000000+4); 119insert into t2 values (19710101000000+3); 120insert into t2 values (19710101000000+2); 121insert into t2 values (19710101000000+1); 122select count(*) from t2; 123count(*) 12459 125select * from t2; 126a 1271971-01-01 00:00:14 1281971-01-01 00:00:34 1291971-01-01 00:00:42 1301971-01-01 00:00:58 1311971-01-01 00:00:21 1321971-01-01 00:00:29 1331971-01-01 00:00:37 1341971-01-01 00:00:53 1351971-01-01 00:00:57 1361971-01-01 00:00:04 1371971-01-01 00:00:08 1381971-01-01 00:00:20 1391971-01-01 00:00:36 1401971-01-01 00:00:44 1411971-01-01 00:00:11 1421971-01-01 00:00:23 1431971-01-01 00:00:27 1441971-01-01 00:00:31 1451971-01-01 00:00:02 1461971-01-01 00:00:06 1471971-01-01 00:00:10 1481971-01-01 00:00:22 1491971-01-01 00:00:38 1501971-01-01 00:00:50 1511971-01-01 00:00:17 1521971-01-01 00:00:33 1531971-01-01 00:00:45 1541971-01-01 00:00:12 1551971-01-01 00:00:52 1561971-01-01 00:00:56 1571971-01-01 00:00:07 1581971-01-01 00:00:19 1591971-01-01 00:00:35 1601971-01-01 00:00:39 1611971-01-01 00:00:47 1621971-01-01 00:00:51 1631971-01-01 00:00:18 1641971-01-01 00:00:26 1651971-01-01 00:00:30 1661971-01-01 00:00:46 1671971-01-01 00:00:54 1681971-01-01 00:00:01 1691971-01-01 00:00:05 1701971-01-01 00:00:09 1711971-01-01 00:00:13 1721971-01-01 00:00:25 1731971-01-01 00:00:41 1741971-01-01 00:00:49 1751971-01-01 00:00:16 1761971-01-01 00:00:24 1771971-01-01 00:00:28 1781971-01-01 00:00:32 1791971-01-01 00:00:40 1801971-01-01 00:00:48 1811971-01-01 00:00:03 1821971-01-01 00:00:15 1831971-01-01 00:00:43 1841971-01-01 00:00:55 1851971-01-01 00:00:59 186drop table t2; 187create table t1 (a date not null, primary key(a)) engine='TokuDB' 188partition by key (a) ( 189partition pa1 max_rows=20 min_rows=2, 190partition pa2 max_rows=30 min_rows=3, 191partition pa3 max_rows=30 min_rows=4, 192partition pa4 max_rows=40 min_rows=2); 193show create table t1; 194Table Create Table 195t1 CREATE TABLE `t1` ( 196 `a` date NOT NULL, 197 PRIMARY KEY (`a`) 198) ENGINE=TokuDB DEFAULT CHARSET=latin1 199/*!50100 PARTITION BY KEY (a) 200(PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = TokuDB, 201 PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = TokuDB, 202 PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = TokuDB, 203 PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = TokuDB) */ 204insert into t1 values ('1975-01-01'), ('2020-12-31'), ('1980-10-14'), ('2000-06-15'); 205select * from t1; 206a 2071980-10-14 2082020-12-31 2091975-01-01 2102000-06-15 211select * from t1 where a=19801014; 212a 2131980-10-14 214delete from t1 where a=19801014; 215select * from t1; 216a 2172020-12-31 2181975-01-01 2192000-06-15 220drop table t1; 221create table t2 (a date not null, primary key(a)) engine='TokuDB' 222partition by key (a) partitions 12; 223show create table t2; 224Table Create Table 225t2 CREATE TABLE `t2` ( 226 `a` date NOT NULL, 227 PRIMARY KEY (`a`) 228) ENGINE=TokuDB DEFAULT CHARSET=latin1 229/*!50100 PARTITION BY KEY (a) 230PARTITIONS 12 */ 231insert into t2 values ('1975-01-01'), ('2020-12-31'), ('1980-10-14'), ('2000-06-15'); 232select * from t2; 233a 2341980-10-14 2351975-01-01 2362020-12-31 2372000-06-15 238select * from t2 where a='1980-10-14'; 239a 2401980-10-14 241delete from t2 where a='1980-10-14'; 242select * from t2; 243a 2441975-01-01 2452020-12-31 2462000-06-15 247delete from t2; 24828 inserts; 249insert into t2 values (19700101+28-1); 250insert into t2 values (19700201+28-1); 251insert into t2 values (19700301+28-1); 252insert into t2 values (19700101+27-1); 253insert into t2 values (19700201+27-1); 254insert into t2 values (19700301+27-1); 255insert into t2 values (19700101+26-1); 256insert into t2 values (19700201+26-1); 257insert into t2 values (19700301+26-1); 258insert into t2 values (19700101+25-1); 259insert into t2 values (19700201+25-1); 260insert into t2 values (19700301+25-1); 261insert into t2 values (19700101+24-1); 262insert into t2 values (19700201+24-1); 263insert into t2 values (19700301+24-1); 264insert into t2 values (19700101+23-1); 265insert into t2 values (19700201+23-1); 266insert into t2 values (19700301+23-1); 267insert into t2 values (19700101+22-1); 268insert into t2 values (19700201+22-1); 269insert into t2 values (19700301+22-1); 270insert into t2 values (19700101+21-1); 271insert into t2 values (19700201+21-1); 272insert into t2 values (19700301+21-1); 273insert into t2 values (19700101+20-1); 274insert into t2 values (19700201+20-1); 275insert into t2 values (19700301+20-1); 276insert into t2 values (19700101+19-1); 277insert into t2 values (19700201+19-1); 278insert into t2 values (19700301+19-1); 279insert into t2 values (19700101+18-1); 280insert into t2 values (19700201+18-1); 281insert into t2 values (19700301+18-1); 282insert into t2 values (19700101+17-1); 283insert into t2 values (19700201+17-1); 284insert into t2 values (19700301+17-1); 285insert into t2 values (19700101+16-1); 286insert into t2 values (19700201+16-1); 287insert into t2 values (19700301+16-1); 288insert into t2 values (19700101+15-1); 289insert into t2 values (19700201+15-1); 290insert into t2 values (19700301+15-1); 291insert into t2 values (19700101+14-1); 292insert into t2 values (19700201+14-1); 293insert into t2 values (19700301+14-1); 294insert into t2 values (19700101+13-1); 295insert into t2 values (19700201+13-1); 296insert into t2 values (19700301+13-1); 297insert into t2 values (19700101+12-1); 298insert into t2 values (19700201+12-1); 299insert into t2 values (19700301+12-1); 300insert into t2 values (19700101+11-1); 301insert into t2 values (19700201+11-1); 302insert into t2 values (19700301+11-1); 303insert into t2 values (19700101+10-1); 304insert into t2 values (19700201+10-1); 305insert into t2 values (19700301+10-1); 306insert into t2 values (19700101+9-1); 307insert into t2 values (19700201+9-1); 308insert into t2 values (19700301+9-1); 309insert into t2 values (19700101+8-1); 310insert into t2 values (19700201+8-1); 311insert into t2 values (19700301+8-1); 312insert into t2 values (19700101+7-1); 313insert into t2 values (19700201+7-1); 314insert into t2 values (19700301+7-1); 315insert into t2 values (19700101+6-1); 316insert into t2 values (19700201+6-1); 317insert into t2 values (19700301+6-1); 318insert into t2 values (19700101+5-1); 319insert into t2 values (19700201+5-1); 320insert into t2 values (19700301+5-1); 321insert into t2 values (19700101+4-1); 322insert into t2 values (19700201+4-1); 323insert into t2 values (19700301+4-1); 324insert into t2 values (19700101+3-1); 325insert into t2 values (19700201+3-1); 326insert into t2 values (19700301+3-1); 327insert into t2 values (19700101+2-1); 328insert into t2 values (19700201+2-1); 329insert into t2 values (19700301+2-1); 330insert into t2 values (19700101+1-1); 331insert into t2 values (19700201+1-1); 332insert into t2 values (19700301+1-1); 333select count(*) from t2; 334count(*) 33584 336select * from t2; 337a 3381970-01-04 3391970-01-12 3401970-01-14 3411970-01-16 3421970-01-20 3431970-01-28 3441970-02-02 3451970-02-08 3461970-02-26 3471970-03-02 3481970-03-08 3491970-03-26 3501970-01-05 3511970-01-21 3521970-01-25 3531970-02-01 3541970-02-15 3551970-02-17 3561970-02-19 3571970-02-27 3581970-03-01 3591970-03-15 3601970-03-17 3611970-03-19 3621970-03-27 3631970-01-08 3641970-01-18 3651970-01-24 3661970-02-10 3671970-02-14 3681970-02-16 3691970-02-20 3701970-02-22 3711970-03-10 3721970-03-14 3731970-03-16 3741970-03-20 3751970-03-22 3761970-03-28 3771970-01-01 3781970-01-09 3791970-01-13 3801970-01-19 3811970-01-27 3821970-02-09 3831970-02-21 3841970-02-25 3851970-03-09 3861970-03-21 3871970-03-25 3881970-01-02 3891970-01-06 3901970-01-10 3911970-01-22 3921970-01-26 3931970-02-04 3941970-02-06 3951970-02-12 3961970-02-18 3971970-02-24 3981970-02-28 3991970-03-04 4001970-03-06 4011970-03-12 4021970-03-18 4031970-03-24 4041970-01-03 4051970-01-07 4061970-01-11 4071970-01-15 4081970-01-17 4091970-01-23 4101970-02-03 4111970-02-05 4121970-02-07 4131970-02-11 4141970-02-13 4151970-02-23 4161970-03-03 4171970-03-05 4181970-03-07 4191970-03-11 4201970-03-13 4211970-03-23 422drop table t2; 423create table t3 (a date not null, primary key(a)) engine='TokuDB' 424partition by range (month(a)) subpartition by key (a) 425subpartitions 3 ( 426partition quarter1 values less than (4), 427partition quarter2 values less than (7), 428partition quarter3 values less than (10), 429partition quarter4 values less than (13) 430); 431show create table t3; 432Table Create Table 433t3 CREATE TABLE `t3` ( 434 `a` date NOT NULL, 435 PRIMARY KEY (`a`) 436) ENGINE=TokuDB DEFAULT CHARSET=latin1 437/*!50100 PARTITION BY RANGE (month(a)) 438SUBPARTITION BY KEY (a) 439SUBPARTITIONS 3 440(PARTITION quarter1 VALUES LESS THAN (4) ENGINE = TokuDB, 441 PARTITION quarter2 VALUES LESS THAN (7) ENGINE = TokuDB, 442 PARTITION quarter3 VALUES LESS THAN (10) ENGINE = TokuDB, 443 PARTITION quarter4 VALUES LESS THAN (13) ENGINE = TokuDB) */ 44412 inserts; 445insert into t3 values (adddate(19700101,interval 12-1 month)); 446insert into t3 values (adddate(19700101,interval 11-1 month)); 447insert into t3 values (adddate(19700101,interval 10-1 month)); 448insert into t3 values (adddate(19700101,interval 9-1 month)); 449insert into t3 values (adddate(19700101,interval 8-1 month)); 450insert into t3 values (adddate(19700101,interval 7-1 month)); 451insert into t3 values (adddate(19700101,interval 6-1 month)); 452insert into t3 values (adddate(19700101,interval 5-1 month)); 453insert into t3 values (adddate(19700101,interval 4-1 month)); 454insert into t3 values (adddate(19700101,interval 3-1 month)); 455insert into t3 values (adddate(19700101,interval 2-1 month)); 456insert into t3 values (adddate(19700101,interval 1-1 month)); 457select count(*) from t3; 458count(*) 45912 460select * from t3; 461a 4621970-01-01 4631970-02-01 4641970-03-01 4651970-04-01 4661970-05-01 4671970-06-01 4681970-07-01 4691970-08-01 4701970-09-01 4711970-10-01 4721970-11-01 4731970-12-01 474drop table t3; 475create table t4 (a date not null, primary key(a)) engine='TokuDB' 476partition by list (month(a)) subpartition by key (a) 477subpartitions 3 ( 478partition quarter1 values in (1,2,3), 479partition quarter2 values in (4,5,6), 480partition quarter3 values in (7,8,9), 481partition quarter4 values in (10,11,12) 482); 483show create table t4; 484Table Create Table 485t4 CREATE TABLE `t4` ( 486 `a` date NOT NULL, 487 PRIMARY KEY (`a`) 488) ENGINE=TokuDB DEFAULT CHARSET=latin1 489/*!50100 PARTITION BY LIST (month(a)) 490SUBPARTITION BY KEY (a) 491SUBPARTITIONS 3 492(PARTITION quarter1 VALUES IN (1,2,3) ENGINE = TokuDB, 493 PARTITION quarter2 VALUES IN (4,5,6) ENGINE = TokuDB, 494 PARTITION quarter3 VALUES IN (7,8,9) ENGINE = TokuDB, 495 PARTITION quarter4 VALUES IN (10,11,12) ENGINE = TokuDB) */ 49612 inserts; 497insert into t4 values (adddate(19700101,interval 12-1 month)); 498insert into t4 values (adddate(19700101,interval 11-1 month)); 499insert into t4 values (adddate(19700101,interval 10-1 month)); 500insert into t4 values (adddate(19700101,interval 9-1 month)); 501insert into t4 values (adddate(19700101,interval 8-1 month)); 502insert into t4 values (adddate(19700101,interval 7-1 month)); 503insert into t4 values (adddate(19700101,interval 6-1 month)); 504insert into t4 values (adddate(19700101,interval 5-1 month)); 505insert into t4 values (adddate(19700101,interval 4-1 month)); 506insert into t4 values (adddate(19700101,interval 3-1 month)); 507insert into t4 values (adddate(19700101,interval 2-1 month)); 508insert into t4 values (adddate(19700101,interval 1-1 month)); 509select count(*) from t4; 510count(*) 51112 512select * from t4; 513a 5141970-01-01 5151970-02-01 5161970-03-01 5171970-04-01 5181970-05-01 5191970-06-01 5201970-07-01 5211970-08-01 5221970-09-01 5231970-10-01 5241970-11-01 5251970-12-01 526drop table t4; 527create table t1 (a time not null, primary key(a)) engine='TokuDB' 528partition by key (a) ( 529partition pa1 max_rows=20 min_rows=2, 530partition pa2 max_rows=30 min_rows=3, 531partition pa3 max_rows=30 min_rows=4, 532partition pa4 max_rows=40 min_rows=2); 533show create table t1; 534Table Create Table 535t1 CREATE TABLE `t1` ( 536 `a` time NOT NULL, 537 PRIMARY KEY (`a`) 538) ENGINE=TokuDB DEFAULT CHARSET=latin1 539/*!50100 PARTITION BY KEY (a) 540(PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = TokuDB, 541 PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = TokuDB, 542 PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = TokuDB, 543 PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = TokuDB) */ 544insert into t1 values ('21:21:21'), ('12:10:30'), ('03:03:03'), ('23:59'); 545select * from t1; 546a 54703:03:03 54821:21:21 54923:59:00 55012:10:30 551select * from t1 where a=030303; 552a 55303:03:03 554delete from t1 where a=030303; 555select * from t1; 556a 55721:21:21 55823:59:00 55912:10:30 560drop table t1; 561create table t2 (a time not null, primary key(a)) engine='TokuDB' 562partition by key (a) partitions 12; 563show create table t2; 564Table Create Table 565t2 CREATE TABLE `t2` ( 566 `a` time NOT NULL, 567 PRIMARY KEY (`a`) 568) ENGINE=TokuDB DEFAULT CHARSET=latin1 569/*!50100 PARTITION BY KEY (a) 570PARTITIONS 12 */ 571insert into t2 values ('0:1:1'), ('10:11:12'), ('13:14:15'), ('14:15:16'); 572select * from t2; 573a 57410:11:12 57513:14:15 57614:15:16 57700:01:01 578select * from t2 where a='13:14:15'; 579a 58013:14:15 581delete from t2 where a='13:14:15'; 582select * from t2; 583a 58410:11:12 58514:15:16 58600:01:01 587delete from t2; 58859 inserts; 589insert into t2 values (000100+59); 590insert into t2 values (000100+58); 591insert into t2 values (000100+57); 592insert into t2 values (000100+56); 593insert into t2 values (000100+55); 594insert into t2 values (000100+54); 595insert into t2 values (000100+53); 596insert into t2 values (000100+52); 597insert into t2 values (000100+51); 598insert into t2 values (000100+50); 599insert into t2 values (000100+49); 600insert into t2 values (000100+48); 601insert into t2 values (000100+47); 602insert into t2 values (000100+46); 603insert into t2 values (000100+45); 604insert into t2 values (000100+44); 605insert into t2 values (000100+43); 606insert into t2 values (000100+42); 607insert into t2 values (000100+41); 608insert into t2 values (000100+40); 609insert into t2 values (000100+39); 610insert into t2 values (000100+38); 611insert into t2 values (000100+37); 612insert into t2 values (000100+36); 613insert into t2 values (000100+35); 614insert into t2 values (000100+34); 615insert into t2 values (000100+33); 616insert into t2 values (000100+32); 617insert into t2 values (000100+31); 618insert into t2 values (000100+30); 619insert into t2 values (000100+29); 620insert into t2 values (000100+28); 621insert into t2 values (000100+27); 622insert into t2 values (000100+26); 623insert into t2 values (000100+25); 624insert into t2 values (000100+24); 625insert into t2 values (000100+23); 626insert into t2 values (000100+22); 627insert into t2 values (000100+21); 628insert into t2 values (000100+20); 629insert into t2 values (000100+19); 630insert into t2 values (000100+18); 631insert into t2 values (000100+17); 632insert into t2 values (000100+16); 633insert into t2 values (000100+15); 634insert into t2 values (000100+14); 635insert into t2 values (000100+13); 636insert into t2 values (000100+12); 637insert into t2 values (000100+11); 638insert into t2 values (000100+10); 639insert into t2 values (000100+9); 640insert into t2 values (000100+8); 641insert into t2 values (000100+7); 642insert into t2 values (000100+6); 643insert into t2 values (000100+5); 644insert into t2 values (000100+4); 645insert into t2 values (000100+3); 646insert into t2 values (000100+2); 647insert into t2 values (000100+1); 648select count(*) from t2; 649count(*) 65059 651select * from t2; 652a 65300:01:15 65400:01:23 65500:01:39 65600:01:47 65700:01:59 65800:01:16 65900:01:24 66000:01:40 66100:01:48 66200:01:05 66300:01:13 66400:01:21 66500:01:37 66600:01:45 66700:01:57 66800:01:14 66900:01:22 67000:01:38 67100:01:46 67200:01:58 67300:01:03 67400:01:11 67500:01:19 67600:01:35 67700:01:43 67800:01:55 67900:01:04 68000:01:12 68100:01:20 68200:01:36 68300:01:44 68400:01:56 68500:01:01 68600:01:09 68700:01:29 68800:01:33 68900:01:41 69000:01:53 69100:01:02 69200:01:10 69300:01:18 69400:01:34 69500:01:42 69600:01:54 69700:01:07 69800:01:27 69900:01:31 70000:01:51 70100:01:08 70200:01:28 70300:01:32 70400:01:52 70500:01:17 70600:01:25 70700:01:49 70800:01:06 70900:01:26 71000:01:30 71100:01:50 712drop table t2; 713create table t3 (a time not null, primary key(a)) engine='TokuDB' 714partition by range (second(a)) subpartition by key (a) 715subpartitions 3 ( 716partition quarter1 values less than (16), 717partition quarter2 values less than (31), 718partition quarter3 values less than (46), 719partition quarter4 values less than (61) 720); 721show create table t3; 722Table Create Table 723t3 CREATE TABLE `t3` ( 724 `a` time NOT NULL, 725 PRIMARY KEY (`a`) 726) ENGINE=TokuDB DEFAULT CHARSET=latin1 727/*!50100 PARTITION BY RANGE (second(a)) 728SUBPARTITION BY KEY (a) 729SUBPARTITIONS 3 730(PARTITION quarter1 VALUES LESS THAN (16) ENGINE = TokuDB, 731 PARTITION quarter2 VALUES LESS THAN (31) ENGINE = TokuDB, 732 PARTITION quarter3 VALUES LESS THAN (46) ENGINE = TokuDB, 733 PARTITION quarter4 VALUES LESS THAN (61) ENGINE = TokuDB) */ 73459 inserts; 735insert into t3 values (100000+59); 736insert into t3 values (100000+58); 737insert into t3 values (100000+57); 738insert into t3 values (100000+56); 739insert into t3 values (100000+55); 740insert into t3 values (100000+54); 741insert into t3 values (100000+53); 742insert into t3 values (100000+52); 743insert into t3 values (100000+51); 744insert into t3 values (100000+50); 745insert into t3 values (100000+49); 746insert into t3 values (100000+48); 747insert into t3 values (100000+47); 748insert into t3 values (100000+46); 749insert into t3 values (100000+45); 750insert into t3 values (100000+44); 751insert into t3 values (100000+43); 752insert into t3 values (100000+42); 753insert into t3 values (100000+41); 754insert into t3 values (100000+40); 755insert into t3 values (100000+39); 756insert into t3 values (100000+38); 757insert into t3 values (100000+37); 758insert into t3 values (100000+36); 759insert into t3 values (100000+35); 760insert into t3 values (100000+34); 761insert into t3 values (100000+33); 762insert into t3 values (100000+32); 763insert into t3 values (100000+31); 764insert into t3 values (100000+30); 765insert into t3 values (100000+29); 766insert into t3 values (100000+28); 767insert into t3 values (100000+27); 768insert into t3 values (100000+26); 769insert into t3 values (100000+25); 770insert into t3 values (100000+24); 771insert into t3 values (100000+23); 772insert into t3 values (100000+22); 773insert into t3 values (100000+21); 774insert into t3 values (100000+20); 775insert into t3 values (100000+19); 776insert into t3 values (100000+18); 777insert into t3 values (100000+17); 778insert into t3 values (100000+16); 779insert into t3 values (100000+15); 780insert into t3 values (100000+14); 781insert into t3 values (100000+13); 782insert into t3 values (100000+12); 783insert into t3 values (100000+11); 784insert into t3 values (100000+10); 785insert into t3 values (100000+9); 786insert into t3 values (100000+8); 787insert into t3 values (100000+7); 788insert into t3 values (100000+6); 789insert into t3 values (100000+5); 790insert into t3 values (100000+4); 791insert into t3 values (100000+3); 792insert into t3 values (100000+2); 793insert into t3 values (100000+1); 794select count(*) from t3; 795count(*) 79659 797select * from t3; 798a 79910:00:01 80010:00:06 80110:00:07 80210:00:14 80310:00:15 80410:00:02 80510:00:03 80610:00:08 80710:00:09 80810:00:04 80910:00:05 81010:00:10 81110:00:11 81210:00:12 81310:00:13 81410:00:20 81510:00:21 81610:00:26 81710:00:27 81810:00:16 81910:00:17 82010:00:22 82110:00:23 82210:00:28 82310:00:29 82410:00:18 82510:00:19 82610:00:24 82710:00:25 82810:00:30 82910:00:32 83010:00:33 83110:00:35 83210:00:40 83310:00:41 83410:00:34 83510:00:36 83610:00:37 83710:00:42 83810:00:43 83910:00:31 84010:00:38 84110:00:39 84210:00:44 84310:00:45 84410:00:46 84510:00:48 84610:00:49 84710:00:54 84810:00:55 84910:00:50 85010:00:51 85110:00:56 85210:00:57 85310:00:59 85410:00:47 85510:00:52 85610:00:53 85710:00:58 858drop table t3; 859create table t4 (a time not null, primary key(a)) engine='TokuDB' 860partition by list (second(a)) subpartition by key (a) 861subpartitions 3 ( 862partition quarter1 values in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15), 863partition quarter2 values in (16,17,18,19,20,21,22,23,24,25,26,27,28,29,30), 864partition quarter3 values in (31,32,33,34,35,36,37,38,39,40,41,42,43,44,45), 865partition quarter4 values in (46,47,48,49,50,51,52,53,54,55,56,57,58,59,60) 866); 867show create table t4; 868Table Create Table 869t4 CREATE TABLE `t4` ( 870 `a` time NOT NULL, 871 PRIMARY KEY (`a`) 872) ENGINE=TokuDB DEFAULT CHARSET=latin1 873/*!50100 PARTITION BY LIST (second(a)) 874SUBPARTITION BY KEY (a) 875SUBPARTITIONS 3 876(PARTITION quarter1 VALUES IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15) ENGINE = TokuDB, 877 PARTITION quarter2 VALUES IN (16,17,18,19,20,21,22,23,24,25,26,27,28,29,30) ENGINE = TokuDB, 878 PARTITION quarter3 VALUES IN (31,32,33,34,35,36,37,38,39,40,41,42,43,44,45) ENGINE = TokuDB, 879 PARTITION quarter4 VALUES IN (46,47,48,49,50,51,52,53,54,55,56,57,58,59,60) ENGINE = TokuDB) */ 88059 inserts; 881insert into t4 values (100000+59); 882insert into t4 values (100000+58); 883insert into t4 values (100000+57); 884insert into t4 values (100000+56); 885insert into t4 values (100000+55); 886insert into t4 values (100000+54); 887insert into t4 values (100000+53); 888insert into t4 values (100000+52); 889insert into t4 values (100000+51); 890insert into t4 values (100000+50); 891insert into t4 values (100000+49); 892insert into t4 values (100000+48); 893insert into t4 values (100000+47); 894insert into t4 values (100000+46); 895insert into t4 values (100000+45); 896insert into t4 values (100000+44); 897insert into t4 values (100000+43); 898insert into t4 values (100000+42); 899insert into t4 values (100000+41); 900insert into t4 values (100000+40); 901insert into t4 values (100000+39); 902insert into t4 values (100000+38); 903insert into t4 values (100000+37); 904insert into t4 values (100000+36); 905insert into t4 values (100000+35); 906insert into t4 values (100000+34); 907insert into t4 values (100000+33); 908insert into t4 values (100000+32); 909insert into t4 values (100000+31); 910insert into t4 values (100000+30); 911insert into t4 values (100000+29); 912insert into t4 values (100000+28); 913insert into t4 values (100000+27); 914insert into t4 values (100000+26); 915insert into t4 values (100000+25); 916insert into t4 values (100000+24); 917insert into t4 values (100000+23); 918insert into t4 values (100000+22); 919insert into t4 values (100000+21); 920insert into t4 values (100000+20); 921insert into t4 values (100000+19); 922insert into t4 values (100000+18); 923insert into t4 values (100000+17); 924insert into t4 values (100000+16); 925insert into t4 values (100000+15); 926insert into t4 values (100000+14); 927insert into t4 values (100000+13); 928insert into t4 values (100000+12); 929insert into t4 values (100000+11); 930insert into t4 values (100000+10); 931insert into t4 values (100000+9); 932insert into t4 values (100000+8); 933insert into t4 values (100000+7); 934insert into t4 values (100000+6); 935insert into t4 values (100000+5); 936insert into t4 values (100000+4); 937insert into t4 values (100000+3); 938insert into t4 values (100000+2); 939insert into t4 values (100000+1); 940select count(*) from t4; 941count(*) 94259 943select * from t4; 944a 94510:00:01 94610:00:06 94710:00:07 94810:00:14 94910:00:15 95010:00:02 95110:00:03 95210:00:08 95310:00:09 95410:00:04 95510:00:05 95610:00:10 95710:00:11 95810:00:12 95910:00:13 96010:00:20 96110:00:21 96210:00:26 96310:00:27 96410:00:16 96510:00:17 96610:00:22 96710:00:23 96810:00:28 96910:00:29 97010:00:18 97110:00:19 97210:00:24 97310:00:25 97410:00:30 97510:00:32 97610:00:33 97710:00:35 97810:00:40 97910:00:41 98010:00:34 98110:00:36 98210:00:37 98310:00:42 98410:00:43 98510:00:31 98610:00:38 98710:00:39 98810:00:44 98910:00:45 99010:00:46 99110:00:48 99210:00:49 99310:00:54 99410:00:55 99510:00:50 99610:00:51 99710:00:56 99810:00:57 99910:00:59 100010:00:47 100110:00:52 100210:00:53 100310:00:58 1004drop table t4; 1005create table t1 (a datetime not null, primary key(a)) engine='TokuDB' 1006partition by key (a) ( 1007partition pa1 max_rows=20 min_rows=2, 1008partition pa2 max_rows=30 min_rows=3, 1009partition pa3 max_rows=30 min_rows=4, 1010partition pa4 max_rows=40 min_rows=2); 1011show create table t1; 1012Table Create Table 1013t1 CREATE TABLE `t1` ( 1014 `a` datetime NOT NULL, 1015 PRIMARY KEY (`a`) 1016) ENGINE=TokuDB DEFAULT CHARSET=latin1 1017/*!50100 PARTITION BY KEY (a) 1018(PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = TokuDB, 1019 PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = TokuDB, 1020 PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = TokuDB, 1021 PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = TokuDB) */ 1022insert into t1 values ('1975-01-01 21:21:21'), ('2020-12-31 12:10:30'), ('1980-10-14 03:03'), ('2000-06-15 23:59'); 1023select * from t1; 1024a 10251975-01-01 21:21:21 10262000-06-15 23:59:00 10272020-12-31 12:10:30 10281980-10-14 03:03:00 1029select * from t1 where a=19801014030300; 1030a 10311980-10-14 03:03:00 1032delete from t1 where a=19801014030300; 1033select * from t1; 1034a 10351975-01-01 21:21:21 10362000-06-15 23:59:00 10372020-12-31 12:10:30 1038drop table t1; 1039create table t2 (a datetime not null, primary key(a)) engine='TokuDB' 1040partition by key (a) partitions 12; 1041show create table t2; 1042Table Create Table 1043t2 CREATE TABLE `t2` ( 1044 `a` datetime NOT NULL, 1045 PRIMARY KEY (`a`) 1046) ENGINE=TokuDB DEFAULT CHARSET=latin1 1047/*!50100 PARTITION BY KEY (a) 1048PARTITIONS 12 */ 1049insert into t2 values ('1975-01-01 0:1:1'), ('2020-12-31 10:11:12'), ('1980-10-14 13:14:15'), ('2000-06-15 14:15:16'); 1050select * from t2; 1051a 10522020-12-31 10:11:12 10532000-06-15 14:15:16 10541980-10-14 13:14:15 10551975-01-01 00:01:01 1056select * from t2 where a='1980-10-14 13:14:15'; 1057a 10581980-10-14 13:14:15 1059delete from t2 where a='1980-10-14 13:14:15'; 1060select * from t2; 1061a 10622020-12-31 10:11:12 10632000-06-15 14:15:16 10641975-01-01 00:01:01 1065delete from t2; 106659 inserts; 1067insert into t2 values (19700101000000+59); 1068insert into t2 values (19700101000000+58); 1069insert into t2 values (19700101000000+57); 1070insert into t2 values (19700101000000+56); 1071insert into t2 values (19700101000000+55); 1072insert into t2 values (19700101000000+54); 1073insert into t2 values (19700101000000+53); 1074insert into t2 values (19700101000000+52); 1075insert into t2 values (19700101000000+51); 1076insert into t2 values (19700101000000+50); 1077insert into t2 values (19700101000000+49); 1078insert into t2 values (19700101000000+48); 1079insert into t2 values (19700101000000+47); 1080insert into t2 values (19700101000000+46); 1081insert into t2 values (19700101000000+45); 1082insert into t2 values (19700101000000+44); 1083insert into t2 values (19700101000000+43); 1084insert into t2 values (19700101000000+42); 1085insert into t2 values (19700101000000+41); 1086insert into t2 values (19700101000000+40); 1087insert into t2 values (19700101000000+39); 1088insert into t2 values (19700101000000+38); 1089insert into t2 values (19700101000000+37); 1090insert into t2 values (19700101000000+36); 1091insert into t2 values (19700101000000+35); 1092insert into t2 values (19700101000000+34); 1093insert into t2 values (19700101000000+33); 1094insert into t2 values (19700101000000+32); 1095insert into t2 values (19700101000000+31); 1096insert into t2 values (19700101000000+30); 1097insert into t2 values (19700101000000+29); 1098insert into t2 values (19700101000000+28); 1099insert into t2 values (19700101000000+27); 1100insert into t2 values (19700101000000+26); 1101insert into t2 values (19700101000000+25); 1102insert into t2 values (19700101000000+24); 1103insert into t2 values (19700101000000+23); 1104insert into t2 values (19700101000000+22); 1105insert into t2 values (19700101000000+21); 1106insert into t2 values (19700101000000+20); 1107insert into t2 values (19700101000000+19); 1108insert into t2 values (19700101000000+18); 1109insert into t2 values (19700101000000+17); 1110insert into t2 values (19700101000000+16); 1111insert into t2 values (19700101000000+15); 1112insert into t2 values (19700101000000+14); 1113insert into t2 values (19700101000000+13); 1114insert into t2 values (19700101000000+12); 1115insert into t2 values (19700101000000+11); 1116insert into t2 values (19700101000000+10); 1117insert into t2 values (19700101000000+9); 1118insert into t2 values (19700101000000+8); 1119insert into t2 values (19700101000000+7); 1120insert into t2 values (19700101000000+6); 1121insert into t2 values (19700101000000+5); 1122insert into t2 values (19700101000000+4); 1123insert into t2 values (19700101000000+3); 1124insert into t2 values (19700101000000+2); 1125insert into t2 values (19700101000000+1); 1126select count(*) from t2; 1127count(*) 112859 1129select * from t2; 1130a 11311970-01-01 00:00:09 11321970-01-01 00:00:13 11331970-01-01 00:00:19 11341970-01-01 00:00:23 11351970-01-01 00:00:33 11361970-01-01 00:00:37 11371970-01-01 00:00:51 11381970-01-01 00:00:59 11391970-01-01 00:00:04 11401970-01-01 00:00:10 11411970-01-01 00:00:14 11421970-01-01 00:00:24 11431970-01-01 00:00:28 11441970-01-01 00:00:34 11451970-01-01 00:00:38 11461970-01-01 00:00:48 11471970-01-01 00:00:52 11481970-01-01 00:00:56 11491970-01-01 00:00:03 11501970-01-01 00:00:07 11511970-01-01 00:00:17 11521970-01-01 00:00:21 11531970-01-01 00:00:27 11541970-01-01 00:00:31 11551970-01-01 00:00:35 11561970-01-01 00:00:39 11571970-01-01 00:00:41 11581970-01-01 00:00:45 11591970-01-01 00:00:08 11601970-01-01 00:00:12 11611970-01-01 00:00:18 11621970-01-01 00:00:22 11631970-01-01 00:00:32 11641970-01-01 00:00:36 11651970-01-01 00:00:42 11661970-01-01 00:00:46 11671970-01-01 00:00:01 11681970-01-01 00:00:05 11691970-01-01 00:00:11 11701970-01-01 00:00:15 11711970-01-01 00:00:25 11721970-01-01 00:00:29 11731970-01-01 00:00:43 11741970-01-01 00:00:47 11751970-01-01 00:00:49 11761970-01-01 00:00:53 11771970-01-01 00:00:55 11781970-01-01 00:00:57 11791970-01-01 00:00:02 11801970-01-01 00:00:06 11811970-01-01 00:00:16 11821970-01-01 00:00:20 11831970-01-01 00:00:26 11841970-01-01 00:00:30 11851970-01-01 00:00:40 11861970-01-01 00:00:44 11871970-01-01 00:00:50 11881970-01-01 00:00:54 11891970-01-01 00:00:58 1190drop table t2; 1191create table t3 (a datetime not null, primary key(a)) engine='TokuDB' 1192partition by range (month(a)) subpartition by key (a) 1193subpartitions 3 ( 1194partition quarter1 values less than (4), 1195partition quarter2 values less than (7), 1196partition quarter3 values less than (10), 1197partition quarter4 values less than (13) 1198); 1199show create table t3; 1200Table Create Table 1201t3 CREATE TABLE `t3` ( 1202 `a` datetime NOT NULL, 1203 PRIMARY KEY (`a`) 1204) ENGINE=TokuDB DEFAULT CHARSET=latin1 1205/*!50100 PARTITION BY RANGE (month(a)) 1206SUBPARTITION BY KEY (a) 1207SUBPARTITIONS 3 1208(PARTITION quarter1 VALUES LESS THAN (4) ENGINE = TokuDB, 1209 PARTITION quarter2 VALUES LESS THAN (7) ENGINE = TokuDB, 1210 PARTITION quarter3 VALUES LESS THAN (10) ENGINE = TokuDB, 1211 PARTITION quarter4 VALUES LESS THAN (13) ENGINE = TokuDB) */ 121212 inserts; 1213insert into t3 values (adddate(19700101000000,interval 12-1 month)); 1214insert into t3 values (adddate(19700101000000,interval 11-1 month)); 1215insert into t3 values (adddate(19700101000000,interval 10-1 month)); 1216insert into t3 values (adddate(19700101000000,interval 9-1 month)); 1217insert into t3 values (adddate(19700101000000,interval 8-1 month)); 1218insert into t3 values (adddate(19700101000000,interval 7-1 month)); 1219insert into t3 values (adddate(19700101000000,interval 6-1 month)); 1220insert into t3 values (adddate(19700101000000,interval 5-1 month)); 1221insert into t3 values (adddate(19700101000000,interval 4-1 month)); 1222insert into t3 values (adddate(19700101000000,interval 3-1 month)); 1223insert into t3 values (adddate(19700101000000,interval 2-1 month)); 1224insert into t3 values (adddate(19700101000000,interval 1-1 month)); 1225select count(*) from t3; 1226count(*) 122712 1228select * from t3; 1229a 12301970-02-01 00:00:00 12311970-01-01 00:00:00 12321970-03-01 00:00:00 12331970-04-01 00:00:00 12341970-05-01 00:00:00 12351970-06-01 00:00:00 12361970-08-01 00:00:00 12371970-09-01 00:00:00 12381970-07-01 00:00:00 12391970-10-01 00:00:00 12401970-11-01 00:00:00 12411970-12-01 00:00:00 1242drop table t3; 1243create table t4 (a datetime not null, primary key(a)) engine='TokuDB' 1244partition by list (month(a)) subpartition by key (a) 1245subpartitions 3 ( 1246partition quarter1 values in (1,2,3), 1247partition quarter2 values in (4,5,6), 1248partition quarter3 values in (7,8,9), 1249partition quarter4 values in (10,11,12) 1250); 1251show create table t4; 1252Table Create Table 1253t4 CREATE TABLE `t4` ( 1254 `a` datetime NOT NULL, 1255 PRIMARY KEY (`a`) 1256) ENGINE=TokuDB DEFAULT CHARSET=latin1 1257/*!50100 PARTITION BY LIST (month(a)) 1258SUBPARTITION BY KEY (a) 1259SUBPARTITIONS 3 1260(PARTITION quarter1 VALUES IN (1,2,3) ENGINE = TokuDB, 1261 PARTITION quarter2 VALUES IN (4,5,6) ENGINE = TokuDB, 1262 PARTITION quarter3 VALUES IN (7,8,9) ENGINE = TokuDB, 1263 PARTITION quarter4 VALUES IN (10,11,12) ENGINE = TokuDB) */ 126412 inserts; 1265insert into t4 values (adddate(19700101000000,interval 12-1 month)); 1266insert into t4 values (adddate(19700101000000,interval 11-1 month)); 1267insert into t4 values (adddate(19700101000000,interval 10-1 month)); 1268insert into t4 values (adddate(19700101000000,interval 9-1 month)); 1269insert into t4 values (adddate(19700101000000,interval 8-1 month)); 1270insert into t4 values (adddate(19700101000000,interval 7-1 month)); 1271insert into t4 values (adddate(19700101000000,interval 6-1 month)); 1272insert into t4 values (adddate(19700101000000,interval 5-1 month)); 1273insert into t4 values (adddate(19700101000000,interval 4-1 month)); 1274insert into t4 values (adddate(19700101000000,interval 3-1 month)); 1275insert into t4 values (adddate(19700101000000,interval 2-1 month)); 1276insert into t4 values (adddate(19700101000000,interval 1-1 month)); 1277select count(*) from t4; 1278count(*) 127912 1280select * from t4; 1281a 12821970-02-01 00:00:00 12831970-01-01 00:00:00 12841970-03-01 00:00:00 12851970-04-01 00:00:00 12861970-05-01 00:00:00 12871970-06-01 00:00:00 12881970-08-01 00:00:00 12891970-09-01 00:00:00 12901970-07-01 00:00:00 12911970-10-01 00:00:00 12921970-11-01 00:00:00 12931970-12-01 00:00:00 1294drop table t4; 1295create table t1 (a year not null, primary key(a)) engine='TokuDB' 1296partition by key (a) ( 1297partition pa1 max_rows=20 min_rows=2, 1298partition pa2 max_rows=30 min_rows=3, 1299partition pa3 max_rows=30 min_rows=4, 1300partition pa4 max_rows=40 min_rows=2); 1301show create table t1; 1302Table Create Table 1303t1 CREATE TABLE `t1` ( 1304 `a` year(4) NOT NULL, 1305 PRIMARY KEY (`a`) 1306) ENGINE=TokuDB DEFAULT CHARSET=latin1 1307/*!50100 PARTITION BY KEY (a) 1308(PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = TokuDB, 1309 PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = TokuDB, 1310 PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = TokuDB, 1311 PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = TokuDB) */ 1312insert into t1 values ('1975'), (2020), ('1980'), ('2000'); 1313select * from t1; 1314a 13151980 13162000 13172020 13181975 1319select * from t1 where a=1980; 1320a 13211980 1322delete from t1 where a=1980; 1323select * from t1; 1324a 13252000 13262020 13271975 1328drop table t1; 1329create table t2 (a year not null, primary key(a)) engine='TokuDB' 1330partition by key (a) partitions 12; 1331show create table t2; 1332Table Create Table 1333t2 CREATE TABLE `t2` ( 1334 `a` year(4) NOT NULL, 1335 PRIMARY KEY (`a`) 1336) ENGINE=TokuDB DEFAULT CHARSET=latin1 1337/*!50100 PARTITION BY KEY (a) 1338PARTITIONS 12 */ 1339insert into t2 values ('1975'), ('2020'), ('1980'), ('2000'); 1340select * from t2; 1341a 13422020 13431975 13441980 13452000 1346select * from t2 where a='1980'; 1347a 13481980 1349delete from t2 where a='1980'; 1350select * from t2; 1351a 13522020 13531975 13542000 1355delete from t2; 1356255 inserts; 1357Warnings: 1358Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. 1359Warnings: 1360Warning 1264 Out of range value for column 'a' at row 1 1361select count(*) from t2; 1362count(*) 1363255 1364select * from t2; 1365a 13661909 13671921 13681933 13691945 13701957 13711969 13721981 13731993 13742001 13752013 13762029 13772041 13782053 13792065 13802077 13812089 13822100 13832101 13842102 13852103 13862114 13872132 13882133 13892134 13902135 13912146 13921904 13931916 13941928 13951932 13961940 13971952 13981964 13991976 14001988 14012008 14022020 14032024 14042036 14052048 14062060 14072072 14082084 14091907 14101919 14111931 14121943 14131955 14141967 14151979 14161991 14171999 14182011 14192027 14202039 14212051 14222063 14232075 14242087 14252097 14262099 14272110 14282111 14292112 14302113 14312123 14322129 14332131 14342142 14352143 14362144 14372145 14382147 14391902 14401914 14411926 14421938 14431950 14441962 14451974 14461986 14472006 14482018 14492034 14502046 14512058 14522070 14532082 14541905 14551917 14561929 14571941 14581953 14591965 14601977 14611989 14621997 14632009 14642021 14652025 14662037 14672049 14682061 14692073 14702085 14712092 14722093 14732094 14742095 14752120 14762121 14772124 14782125 14792126 14802127 14812152 14822153 14830000 14841912 14851924 14861936 14871948 14881960 14891972 14901984 14911996 14922004 14932016 14942032 14952044 14962056 14972068 14982080 14992116 15002148 15011903 15021915 15031927 15041939 15051951 15061963 15071975 15081987 15092007 15102019 15112023 15122035 15132047 15142059 15152071 15162083 15172155 15181910 15191922 15201934 15211946 15221958 15231970 15241982 15251994 15262002 15272014 15282030 15292042 15302054 15312066 15322078 15332090 15341913 15351925 15361937 15371949 15381961 15391973 15401985 15412005 15422017 15432033 15442045 15452057 15462069 15472081 15482104 15492105 15502106 15512107 15522117 15532118 15542119 15552136 15562137 15572138 15582139 15592149 15602150 15612151 15621908 15631920 15641944 15651956 15661968 15671980 15681992 15692000 15702012 15712028 15722040 15732052 15742064 15752076 15762088 15772096 15782098 15792108 15802128 15812130 15822140 15831911 15841923 15851935 15861947 15871959 15881971 15891983 15901995 15912003 15922015 15932031 15942043 15952055 15962067 15972079 15982091 15992115 16001906 16011918 16021930 16031942 16041954 16051966 16061978 16071990 16081998 16092010 16102022 16112026 16122038 16132050 16142062 16152074 16162086 16172109 16182122 16192141 16202154 1621drop table t2; 1622