1DROP TABLE IF EXISTS t1; 2DROP TABLE IF EXISTS VAR_POP; 3DROP TABLE IF EXISTS TEMP0; 4DROP TABLE IF EXISTS VAR_SAMP; 5DROP TABLE IF EXISTS ti; 6DROP TABLE IF EXISTS members; 7DROP TABLE IF EXISTS members_2; 8DROP TABLE IF EXISTS employees; 9DROP TABLE IF EXISTS employees_2; 10DROP TABLE IF EXISTS employees_3; 11DROP TABLE IF EXISTS quarterly_report_status; 12DROP TABLE IF EXISTS employees_4; 13DROP TABLE IF EXISTS h2; 14DROP TABLE IF EXISTS rcx; 15DROP TABLE IF EXISTS r1; 16DROP TABLE IF EXISTS rc1; 17DROP TABLE IF EXISTS rx; 18DROP TABLE IF EXISTS rc2; 19DROP TABLE IF EXISTS rc3; 20DROP TABLE IF EXISTS rc4; 21DROP TABLE IF EXISTS employees_by_lname; 22DROP TABLE IF EXISTS customers_1; 23DROP TABLE IF EXISTS customers_2; 24DROP TABLE IF EXISTS customers_3; 25DROP TABLE IF EXISTS employees_hash; 26DROP TABLE IF EXISTS employees_hash_1; 27DROP TABLE IF EXISTS t1_hash; 28DROP TABLE IF EXISTS employees_linear_hash; 29DROP TABLE IF EXISTS t1_linear_hash; 30DROP TABLE IF EXISTS k1; 31DROP TABLE IF EXISTS k2; 32DROP TABLE IF EXISTS tm1; 33DROP TABLE IF EXISTS tk; 34DROP TABLE IF EXISTS ts; 35DROP TABLE IF EXISTS ts_1; 36DROP TABLE IF EXISTS ts_3; 37DROP TABLE IF EXISTS ts_4; 38DROP TABLE IF EXISTS ts_5; 39DROP TABLE IF EXISTS trb3; 40DROP TABLE IF EXISTS tr; 41DROP TABLE IF EXISTS members_3; 42DROP TABLE IF EXISTS clients; 43DROP TABLE IF EXISTS clients_lk; 44DROP TABLE IF EXISTS trb1; 45CREATE TABLE t1 (i INT, j INT, k INT, PRIMARY KEY (i)) ENGINE = ROCKSDB PARTITION BY KEY(i) PARTITIONS 4; 46Table Op Msg_type Msg_text 47test.t1 optimize status OK 48Table Op Msg_type Msg_text 49test.t1 analyze status Engine-independent statistics collected 50test.t1 analyze status OK 51Table Op Msg_type Msg_text 52test.t1 repair status OK 53Table Op Msg_type Msg_text 54test.t1 check status OK 55select lower(table_name) as tname 56from information_schema.tables 57where table_schema=database() 58order by tname; 59tname 60t1 61temp0 62var_pop 63var_samp 64SELECT * FROM t1 ORDER BY i LIMIT 10; 65i j k 661 1 1 672 2 2 683 3 3 694 4 4 705 5 5 716 6 6 727 7 7 738 8 8 749 9 9 7510 10 10 76SELECT COUNT(*) FROM t1; 77COUNT(*) 781000 79CREATE TABLE ti( 80id INT, 81amount DECIMAL(7,2), 82tr_date DATE 83) ENGINE=ROCKSDB 84PARTITION BY HASH(MONTH(tr_date)) 85PARTITIONS 6; 86CREATE TABLE members ( 87firstname VARCHAR(25) NOT NULL, 88lastname VARCHAR(25) NOT NULL, 89username VARCHAR(16) NOT NULL, 90email VARCHAR(35), 91joined DATE NOT NULL 92) ENGINE=ROCKSDB 93PARTITION BY KEY(joined) 94PARTITIONS 6; 95CREATE TABLE members_2 ( 96firstname VARCHAR(25) NOT NULL, 97lastname VARCHAR(25) NOT NULL, 98username VARCHAR(16) NOT NULL, 99email VARCHAR(35), 100joined DATE NOT NULL 101) ENGINE=ROCKSDB 102PARTITION BY RANGE(YEAR(joined)) ( 103PARTITION p0 VALUES LESS THAN (1960), 104PARTITION p1 VALUES LESS THAN (1970), 105PARTITION p2 VALUES LESS THAN (1980), 106PARTITION p3 VALUES LESS THAN (1990), 107PARTITION p4 VALUES LESS THAN MAXVALUE 108); 109CREATE TABLE t2 (val INT) 110ENGINE=ROCKSDB 111PARTITION BY LIST(val)( 112PARTITION mypart VALUES IN (1,3,5), 113PARTITION MyPart VALUES IN (2,4,6) 114); 115ERROR HY000: Duplicate partition name MyPart 116CREATE TABLE employees ( 117id INT NOT NULL, 118fname VARCHAR(30), 119lname VARCHAR(30), 120hired DATE NOT NULL DEFAULT '1970-01-01', 121separated DATE NOT NULL DEFAULT '9999-12-31', 122job_code INT NOT NULL, 123store_id INT NOT NULL 124) ENGINE=ROCKSDB 125PARTITION BY RANGE (store_id) ( 126PARTITION p0 VALUES LESS THAN (6), 127PARTITION p1 VALUES LESS THAN (11), 128PARTITION p2 VALUES LESS THAN (16), 129PARTITION p3 VALUES LESS THAN MAXVALUE 130); 131CREATE TABLE employees_2 ( 132id INT NOT NULL, 133fname VARCHAR(30), 134lname VARCHAR(30), 135hired DATE NOT NULL DEFAULT '1970-01-01', 136separated DATE NOT NULL DEFAULT '9999-12-31', 137job_code INT NOT NULL, 138store_id INT NOT NULL 139) ENGINE=ROCKSDB 140PARTITION BY RANGE (job_code) ( 141PARTITION p0 VALUES LESS THAN (100), 142PARTITION p1 VALUES LESS THAN (1000), 143PARTITION p2 VALUES LESS THAN (10000) 144); 145CREATE TABLE employees_3 ( 146id INT NOT NULL, 147fname VARCHAR(30), 148lname VARCHAR(30), 149hired DATE NOT NULL DEFAULT '1970-01-01', 150separated DATE NOT NULL DEFAULT '9999-12-31', 151job_code INT, 152store_id INT 153) ENGINE=ROCKSDB 154PARTITION BY RANGE (YEAR(separated)) ( 155PARTITION p0 VALUES LESS THAN (1991), 156PARTITION p1 VALUES LESS THAN (1996), 157PARTITION p2 VALUES LESS THAN (2001), 158PARTITION p3 VALUES LESS THAN MAXVALUE 159); 160CREATE TABLE quarterly_report_status ( 161report_id INT NOT NULL, 162report_status VARCHAR(20) NOT NULL, 163report_updated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP 164) ENGINE=ROCKSDB 165PARTITION BY RANGE (UNIX_TIMESTAMP(report_updated)) ( 166PARTITION p0 VALUES LESS THAN ( UNIX_TIMESTAMP('2008-01-01 00:00:00') ), 167PARTITION p1 VALUES LESS THAN ( UNIX_TIMESTAMP('2008-04-01 00:00:00') ), 168PARTITION p2 VALUES LESS THAN ( UNIX_TIMESTAMP('2008-07-01 00:00:00') ), 169PARTITION p3 VALUES LESS THAN ( UNIX_TIMESTAMP('2008-10-01 00:00:00') ), 170PARTITION p4 VALUES LESS THAN ( UNIX_TIMESTAMP('2009-01-01 00:00:00') ), 171PARTITION p5 VALUES LESS THAN ( UNIX_TIMESTAMP('2009-04-01 00:00:00') ), 172PARTITION p6 VALUES LESS THAN ( UNIX_TIMESTAMP('2009-07-01 00:00:00') ), 173PARTITION p7 VALUES LESS THAN ( UNIX_TIMESTAMP('2009-10-01 00:00:00') ), 174PARTITION p8 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-01-01 00:00:00') ), 175PARTITION p9 VALUES LESS THAN (MAXVALUE) 176); 177CREATE TABLE employees_4 ( 178id INT NOT NULL, 179fname VARCHAR(30), 180lname VARCHAR(30), 181hired DATE NOT NULL DEFAULT '1970-01-01', 182separated DATE NOT NULL DEFAULT '9999-12-31', 183job_code INT, 184store_id INT 185) ENGINE=ROCKSDB 186PARTITION BY LIST(store_id) ( 187PARTITION pNorth VALUES IN (3,5,6,9,17), 188PARTITION pEast VALUES IN (1,2,10,11,19,20), 189PARTITION pWest VALUES IN (4,12,13,14,18), 190PARTITION pCentral VALUES IN (7,8,15,16) 191); 192CREATE TABLE h2 ( 193c1 INT, 194c2 INT 195) ENGINE=ROCKSDB 196PARTITION BY LIST(c1) ( 197PARTITION p0 VALUES IN (1, 4, 7), 198PARTITION p1 VALUES IN (2, 5, 8) 199); 200INSERT INTO h2 VALUES (3, 5); 201ERROR HY000: Table has no partition for value 3 202CREATE TABLE rcx ( 203a INT, 204b INT, 205c CHAR(3), 206d INT 207) ENGINE=ROCKSDB 208PARTITION BY RANGE COLUMNS(a,d,c) ( 209PARTITION p0 VALUES LESS THAN (5,10,'ggg'), 210PARTITION p1 VALUES LESS THAN (10,20,'mmm'), 211PARTITION p2 VALUES LESS THAN (15,30,'sss'), 212PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE) 213); 214CREATE TABLE r1 ( 215a INT, 216b INT 217) ENGINE=ROCKSDB 218PARTITION BY RANGE (a) ( 219PARTITION p0 VALUES LESS THAN (5), 220PARTITION p1 VALUES LESS THAN (MAXVALUE) 221); 222INSERT INTO r1 VALUES (5,10), (5,11), (5,12); 223CREATE TABLE rc1 ( 224a INT, 225b INT 226) ENGINE=ROCKSDB 227PARTITION BY RANGE COLUMNS(a, b) ( 228PARTITION p0 VALUES LESS THAN (5, 12), 229PARTITION p3 VALUES LESS THAN (MAXVALUE, MAXVALUE) 230); 231INSERT INTO rc1 VALUES (5,10), (5,11), (5,12); 232SELECT (5,10) < (5,12), (5,11) < (5,12), (5,12) < (5,12); 233(5,10) < (5,12) (5,11) < (5,12) (5,12) < (5,12) 2341 1 0 235CREATE TABLE rx ( 236a INT, 237b INT 238) ENGINE=ROCKSDB 239PARTITION BY RANGE COLUMNS (a) ( 240PARTITION p0 VALUES LESS THAN (5), 241PARTITION p1 VALUES LESS THAN (MAXVALUE) 242); 243INSERT INTO rx VALUES (5,10), (5,11), (5,12); 244CREATE TABLE rc2 ( 245a INT, 246b INT 247) ENGINE=ROCKSDB 248PARTITION BY RANGE COLUMNS(a,b) ( 249PARTITION p0 VALUES LESS THAN (0,10), 250PARTITION p1 VALUES LESS THAN (10,20), 251PARTITION p2 VALUES LESS THAN (10,30), 252PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE) 253); 254CREATE TABLE rc3 ( 255a INT, 256b INT 257) ENGINE=ROCKSDB 258PARTITION BY RANGE COLUMNS(a,b) ( 259PARTITION p0 VALUES LESS THAN (0,10), 260PARTITION p1 VALUES LESS THAN (10,20), 261PARTITION p2 VALUES LESS THAN (10,30), 262PARTITION p3 VALUES LESS THAN (10,35), 263PARTITION p4 VALUES LESS THAN (20,40), 264PARTITION p5 VALUES LESS THAN (MAXVALUE,MAXVALUE) 265); 266CREATE TABLE rc4 ( 267a INT, 268b INT, 269c INT 270) ENGINE=ROCKSDB 271PARTITION BY RANGE COLUMNS(a,b,c) ( 272PARTITION p0 VALUES LESS THAN (0,25,50), 273PARTITION p1 VALUES LESS THAN (10,20,100), 274PARTITION p2 VALUES LESS THAN (10,30,50), 275PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE) 276); 277SELECT (0,25,50) < (10,20,100), (10,20,100) < (10,30,50); 278(0,25,50) < (10,20,100) (10,20,100) < (10,30,50) 2791 1 280CREATE TABLE rcf ( 281a INT, 282b INT, 283c INT 284) ENGINE=ROCKSDB 285PARTITION BY RANGE COLUMNS(a,b,c) ( 286PARTITION p0 VALUES LESS THAN (0,25,50), 287PARTITION p1 VALUES LESS THAN (20,20,100), 288PARTITION p2 VALUES LESS THAN (10,30,50), 289PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE) 290); 291ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition 292CREATE TABLE employees_by_lname ( 293id INT NOT NULL, 294fname VARCHAR(30), 295lname VARCHAR(30), 296hired DATE NOT NULL DEFAULT '1970-01-01', 297separated DATE NOT NULL DEFAULT '9999-12-31', 298job_code INT NOT NULL, 299store_id INT NOT NULL 300) ENGINE=ROCKSDB 301PARTITION BY RANGE COLUMNS (lname) ( 302PARTITION p0 VALUES LESS THAN ('g'), 303PARTITION p1 VALUES LESS THAN ('m'), 304PARTITION p2 VALUES LESS THAN ('t'), 305PARTITION p3 VALUES LESS THAN (MAXVALUE) 306); 307ALTER TABLE employees_by_lname PARTITION BY RANGE COLUMNS (lname) ( 308PARTITION p0 VALUES LESS THAN ('g'), 309PARTITION p1 VALUES LESS THAN ('m'), 310PARTITION p2 VALUES LESS THAN ('t'), 311PARTITION p3 VALUES LESS THAN (MAXVALUE) 312); 313ALTER TABLE employees_by_lname PARTITION BY RANGE COLUMNS (hired) ( 314PARTITION p0 VALUES LESS THAN ('1970-01-01'), 315PARTITION p1 VALUES LESS THAN ('1980-01-01'), 316PARTITION p2 VALUES LESS THAN ('1990-01-01'), 317PARTITION p3 VALUES LESS THAN ('2000-01-01'), 318PARTITION p4 VALUES LESS THAN ('2010-01-01'), 319PARTITION p5 VALUES LESS THAN (MAXVALUE) 320); 321CREATE TABLE customers_1 ( 322first_name VARCHAR(25), 323last_name VARCHAR(25), 324street_1 VARCHAR(30), 325street_2 VARCHAR(30), 326city VARCHAR(15), 327renewal DATE 328) ENGINE=ROCKSDB 329PARTITION BY LIST COLUMNS(city) ( 330PARTITION pRegion_1 VALUES IN('Oskarshamn', 'Högsby', 'Mönsterås'), 331PARTITION pRegion_2 VALUES IN('Vimmerby', 'Hultsfred', 'Västervik'), 332PARTITION pRegion_3 VALUES IN('Nässjö', 'Eksjö', 'Vetlanda'), 333PARTITION pRegion_4 VALUES IN('Uppvidinge', 'Alvesta', 'Växjo') 334); 335CREATE TABLE customers_2 ( 336first_name VARCHAR(25), 337last_name VARCHAR(25), 338street_1 VARCHAR(30), 339street_2 VARCHAR(30), 340city VARCHAR(15), 341renewal DATE 342) ENGINE=ROCKSDB 343PARTITION BY LIST COLUMNS(renewal) ( 344PARTITION pWeek_1 VALUES IN('2010-02-01', '2010-02-02', '2010-02-03', 345'2010-02-04', '2010-02-05', '2010-02-06', '2010-02-07'), 346PARTITION pWeek_2 VALUES IN('2010-02-08', '2010-02-09', '2010-02-10', 347'2010-02-11', '2010-02-12', '2010-02-13', '2010-02-14'), 348PARTITION pWeek_3 VALUES IN('2010-02-15', '2010-02-16', '2010-02-17', 349'2010-02-18', '2010-02-19', '2010-02-20', '2010-02-21'), 350PARTITION pWeek_4 VALUES IN('2010-02-22', '2010-02-23', '2010-02-24', 351'2010-02-25', '2010-02-26', '2010-02-27', '2010-02-28') 352); 353CREATE TABLE customers_3 ( 354first_name VARCHAR(25), 355last_name VARCHAR(25), 356street_1 VARCHAR(30), 357street_2 VARCHAR(30), 358city VARCHAR(15), 359renewal DATE 360) ENGINE=ROCKSDB 361PARTITION BY RANGE COLUMNS(renewal) ( 362PARTITION pWeek_1 VALUES LESS THAN('2010-02-09'), 363PARTITION pWeek_2 VALUES LESS THAN('2010-02-15'), 364PARTITION pWeek_3 VALUES LESS THAN('2010-02-22'), 365PARTITION pWeek_4 VALUES LESS THAN('2010-03-01') 366); 367CREATE TABLE employees_hash ( 368id INT NOT NULL, 369fname VARCHAR(30), 370lname VARCHAR(30), 371hired DATE NOT NULL DEFAULT '1970-01-01', 372separated DATE NOT NULL DEFAULT '9999-12-31', 373job_code INT, 374store_id INT 375) ENGINE=ROCKSDB 376PARTITION BY HASH(store_id) 377PARTITIONS 4; 378CREATE TABLE employees_hash_1 ( 379id INT NOT NULL, 380fname VARCHAR(30), 381lname VARCHAR(30), 382hired DATE NOT NULL DEFAULT '1970-01-01', 383separated DATE NOT NULL DEFAULT '9999-12-31', 384job_code INT, 385store_id INT 386) ENGINE=ROCKSDB 387PARTITION BY HASH( YEAR(hired) ) 388PARTITIONS 4; 389CREATE TABLE t1_hash ( 390col1 INT, 391col2 CHAR(5), 392col3 DATE 393) ENGINE=ROCKSDB 394PARTITION BY HASH( YEAR(col3) ) 395PARTITIONS 4; 396CREATE TABLE employees_linear_hash ( 397id INT NOT NULL, 398fname VARCHAR(30), 399lname VARCHAR(30), 400hired DATE NOT NULL DEFAULT '1970-01-01', 401separated DATE NOT NULL DEFAULT '9999-12-31', 402job_code INT, 403store_id INT 404) ENGINE=ROCKSDB 405PARTITION BY LINEAR HASH( YEAR(hired) ) 406PARTITIONS 4; 407CREATE TABLE t1_linear_hash ( 408col1 INT, 409col2 CHAR(5), 410col3 DATE 411) ENGINE=ROCKSDB 412PARTITION BY LINEAR HASH( YEAR(col3) ) 413PARTITIONS 6; 414CREATE TABLE k1 ( 415id INT NOT NULL PRIMARY KEY, 416name VARCHAR(20) 417) ENGINE=ROCKSDB 418PARTITION BY KEY() 419PARTITIONS 2; 420CREATE TABLE k2 ( 421id INT NOT NULL, 422name VARCHAR(20), 423UNIQUE KEY (id) 424) ENGINE=ROCKSDB 425PARTITION BY KEY() 426PARTITIONS 2; 427CREATE TABLE tm1 ( 428s1 CHAR(32) PRIMARY KEY 429) ENGINE=ROCKSDB 430PARTITION BY KEY(s1) 431PARTITIONS 10; 432CREATE TABLE tk ( 433col1 INT NOT NULL, 434col2 CHAR(5), 435col3 DATE 436) ENGINE=ROCKSDB 437PARTITION BY LINEAR KEY (col1) 438PARTITIONS 3; 439CREATE TABLE ts ( 440id INT, 441purchased DATE 442) ENGINE=ROCKSDB 443PARTITION BY RANGE( YEAR(purchased) ) 444SUBPARTITION BY HASH( TO_DAYS(purchased) ) 445SUBPARTITIONS 2 ( 446PARTITION p0 VALUES LESS THAN (1990), 447PARTITION p1 VALUES LESS THAN (2000), 448PARTITION p2 VALUES LESS THAN MAXVALUE 449); 450CREATE TABLE ts_1 ( 451id INT, 452purchased DATE 453) ENGINE=ROCKSDB 454PARTITION BY RANGE( YEAR(purchased) ) 455SUBPARTITION BY HASH( TO_DAYS(purchased) ) ( 456PARTITION p0 VALUES LESS THAN (1990) ( 457SUBPARTITION s0, 458SUBPARTITION s1 459), 460PARTITION p1 VALUES LESS THAN (2000) ( 461SUBPARTITION s2, 462SUBPARTITION s3 463), 464PARTITION p2 VALUES LESS THAN MAXVALUE ( 465SUBPARTITION s4, 466SUBPARTITION s5 467) 468); 469CREATE TABLE ts_2 ( 470id INT, 471purchased DATE 472) ENGINE=ROCKSDB 473PARTITION BY RANGE( YEAR(purchased) ) 474SUBPARTITION BY HASH( TO_DAYS(purchased) ) ( 475PARTITION p0 VALUES LESS THAN (1990) ( 476SUBPARTITION s0, 477SUBPARTITION s1 478), 479PARTITION p1 VALUES LESS THAN (2000), 480PARTITION p2 VALUES LESS THAN MAXVALUE ( 481SUBPARTITION s2, 482SUBPARTITION s3 483) 484); 485ERROR 42000: Wrong number of subpartitions defined, mismatch with previous setting near ' 486PARTITION p2 VALUES LESS THAN MAXVALUE ( 487SUBPARTITION s2, 488SUBPARTITION s3 489) 490)' at line 11 491CREATE TABLE ts_3 ( 492id INT, 493purchased DATE 494) ENGINE=ROCKSDB 495PARTITION BY RANGE( YEAR(purchased) ) 496SUBPARTITION BY HASH( TO_DAYS(purchased) ) ( 497PARTITION p0 VALUES LESS THAN (1990) ( 498SUBPARTITION s0, 499SUBPARTITION s1 500), 501PARTITION p1 VALUES LESS THAN (2000) ( 502SUBPARTITION s2, 503SUBPARTITION s3 504), 505PARTITION p2 VALUES LESS THAN MAXVALUE ( 506SUBPARTITION s4, 507SUBPARTITION s5 508) 509); 510CREATE TABLE ts_4 ( 511id INT, 512purchased DATE 513) ENGINE=ROCKSDB 514PARTITION BY RANGE( YEAR(purchased) ) 515SUBPARTITION BY HASH( TO_DAYS(purchased) ) ( 516PARTITION p0 VALUES LESS THAN (1990) ( 517SUBPARTITION s0, 518SUBPARTITION s1 519), 520PARTITION p1 VALUES LESS THAN (2000) ( 521SUBPARTITION s2, 522SUBPARTITION s3 523), 524PARTITION p2 VALUES LESS THAN MAXVALUE ( 525SUBPARTITION s4, 526SUBPARTITION s5 527) 528); 529CREATE TABLE ts_5 ( 530id INT, 531purchased DATE 532) ENGINE=ROCKSDB 533PARTITION BY RANGE(YEAR(purchased)) 534SUBPARTITION BY HASH( TO_DAYS(purchased) ) ( 535PARTITION p0 VALUES LESS THAN (1990) ( 536SUBPARTITION s0a, 537SUBPARTITION s0b 538), 539PARTITION p1 VALUES LESS THAN (2000) ( 540SUBPARTITION s1a, 541SUBPARTITION s1b 542), 543PARTITION p2 VALUES LESS THAN MAXVALUE ( 544SUBPARTITION s2a, 545SUBPARTITION s2b 546) 547); 548CREATE TABLE trb3 ( 549id INT, 550name VARCHAR(50), 551purchased DATE 552) ENGINE=ROCKSDB 553PARTITION BY RANGE( YEAR(purchased) ) ( 554PARTITION p0 VALUES LESS THAN (1990), 555PARTITION p1 VALUES LESS THAN (1995), 556PARTITION p2 VALUES LESS THAN (2000), 557PARTITION p3 VALUES LESS THAN (2005) 558); 559ALTER TABLE trb3 PARTITION BY KEY(id) PARTITIONS 2; 560CREATE TABLE tr ( 561id INT, 562name VARCHAR(50), 563purchased DATE 564) ENGINE=ROCKSDB 565PARTITION BY RANGE( YEAR(purchased) ) ( 566PARTITION p0 VALUES LESS THAN (1990), 567PARTITION p1 VALUES LESS THAN (1995), 568PARTITION p2 VALUES LESS THAN (2000), 569PARTITION p3 VALUES LESS THAN (2005) 570); 571INSERT INTO tr VALUES 572(1, 'desk organiser', '2003-10-15'), 573(2, 'CD player', '1993-11-05'), 574(3, 'TV set', '1996-03-10'), 575(4, 'bookcase', '1982-01-10'), 576(5, 'exercise bike', '2004-05-09'), 577(6, 'sofa', '1987-06-05'), 578(7, 'popcorn maker', '2001-11-22'), 579(8, 'aquarium', '1992-08-04'), 580(9, 'study desk', '1984-09-16'), 581(10, 'lava lamp', '1998-12-25'); 582SELECT * FROM tr WHERE purchased BETWEEN '1995-01-01' AND '1999-12-31'; 583id name purchased 5843 TV set 1996-03-10 58510 lava lamp 1998-12-25 586ALTER TABLE tr DROP PARTITION p2; 587SELECT * FROM tr WHERE purchased BETWEEN '1995-01-01' AND '1999-12-31'; 588id name purchased 589CREATE TABLE members_3 ( 590id INT, 591fname VARCHAR(25), 592lname VARCHAR(25), 593dob DATE 594) ENGINE=ROCKSDB 595PARTITION BY RANGE( YEAR(dob) ) ( 596PARTITION p0 VALUES LESS THAN (1970), 597PARTITION p1 VALUES LESS THAN (1980), 598PARTITION p2 VALUES LESS THAN (1990) 599); 600ALTER TABLE members_3 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2000)); 601ALTER TABLE members_3 ADD PARTITION (PARTITION n VALUES LESS THAN (1960)); 602ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition 603CREATE TABLE clients ( 604id INT, 605fname VARCHAR(30), 606lname VARCHAR(30), 607signed DATE 608) ENGINE=ROCKSDB 609PARTITION BY HASH( MONTH(signed) ) 610PARTITIONS 12; 611ALTER TABLE clients COALESCE PARTITION 4; 612CREATE TABLE clients_lk ( 613id INT, 614fname VARCHAR(30), 615lname VARCHAR(30), 616signed DATE 617) ENGINE=ROCKSDB 618PARTITION BY LINEAR KEY(signed) 619PARTITIONS 12; 620ALTER TABLE clients COALESCE PARTITION 18; 621ERROR HY000: Cannot remove all partitions, use DROP TABLE instead 622ALTER TABLE clients ADD PARTITION PARTITIONS 6; 623CREATE TABLE trb1 ( 624id INT, 625name VARCHAR(50), 626purchased DATE 627) ENGINE=ROCKSDB 628PARTITION BY RANGE(id) ( 629PARTITION p0 VALUES LESS THAN (3), 630PARTITION p1 VALUES LESS THAN (7), 631PARTITION p2 VALUES LESS THAN (9), 632PARTITION p3 VALUES LESS THAN (11) 633); 634INSERT INTO trb1 VALUES 635(1, 'desk organiser', '2003-10-15'), 636(2, 'CD player', '1993-11-05'), 637(3, 'TV set', '1996-03-10'), 638(4, 'bookcase', '1982-01-10'), 639(5, 'exercise bike', '2004-05-09'), 640(6, 'sofa', '1987-06-05'), 641(7, 'popcorn maker', '2001-11-22'), 642(8, 'aquarium', '1992-08-04'), 643(9, 'study desk', '1984-09-16'), 644(10, 'lava lamp', '1998-12-25'); 645ALTER TABLE trb1 ADD PRIMARY KEY (id); 646DROP TABLE IF EXISTS t1; 647DROP TABLE IF EXISTS VAR_POP; 648DROP TABLE IF EXISTS TEMP0; 649DROP TABLE IF EXISTS VAR_SAMP; 650DROP TABLE IF EXISTS ti; 651DROP TABLE IF EXISTS members; 652DROP TABLE IF EXISTS members_2; 653DROP TABLE IF EXISTS employees; 654DROP TABLE IF EXISTS employees_2; 655DROP TABLE IF EXISTS employees_3; 656DROP TABLE IF EXISTS quarterly_report_status; 657DROP TABLE IF EXISTS employees_4; 658DROP TABLE IF EXISTS h2; 659DROP TABLE IF EXISTS rcx; 660DROP TABLE IF EXISTS r1; 661DROP TABLE IF EXISTS rc1; 662DROP TABLE IF EXISTS rx; 663DROP TABLE IF EXISTS rc2; 664DROP TABLE IF EXISTS rc3; 665DROP TABLE IF EXISTS rc4; 666DROP TABLE IF EXISTS employees_by_lname; 667DROP TABLE IF EXISTS customers_1; 668DROP TABLE IF EXISTS customers_2; 669DROP TABLE IF EXISTS customers_3; 670DROP TABLE IF EXISTS employees_hash; 671DROP TABLE IF EXISTS employees_hash_1; 672DROP TABLE IF EXISTS t1_hash; 673DROP TABLE IF EXISTS employees_linear_hash; 674DROP TABLE IF EXISTS t1_linear_hash; 675DROP TABLE IF EXISTS k1; 676DROP TABLE IF EXISTS k2; 677DROP TABLE IF EXISTS tm1; 678DROP TABLE IF EXISTS tk; 679DROP TABLE IF EXISTS ts; 680DROP TABLE IF EXISTS ts_1; 681DROP TABLE IF EXISTS ts_3; 682DROP TABLE IF EXISTS ts_4; 683DROP TABLE IF EXISTS ts_5; 684DROP TABLE IF EXISTS trb3; 685DROP TABLE IF EXISTS tr; 686DROP TABLE IF EXISTS members_3; 687DROP TABLE IF EXISTS clients; 688DROP TABLE IF EXISTS clients_lk; 689DROP TABLE IF EXISTS trb1; 690