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