DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
CREATE TABLE t1 (a INT(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1 PARTITION BY LIST (a)(PARTITION p0 VALUES IN (0,1,2,3) ENGINE = InnoDB, PARTITION p1 VALUES IN (4,5,6,7) ENGINE = InnoDB, PARTITION p2 VALUES IN (8,9,10,11) ENGINE = InnoDB, PARTITION p3 VALUES IN (12,13,14,15) ENGINE = InnoDB, PARTITION p4 VALUES IN (16,17,18,19) ENGINE = InnoDB, PARTITION p5 VALUES IN (20,21,22,23) ENGINE = InnoDB);
CREATE TABLE t2 (a INT(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1 PARTITION BY LIST (a)(PARTITION p0 VALUES IN (0,1,2,3) ENGINE = InnoDB, PARTITION p1 VALUES IN (4,5,6,7) ENGINE = InnoDB, PARTITION p2 VALUES IN (8,9,10,11) ENGINE = InnoDB, PARTITION p3 VALUES IN (12,13,14,15) ENGINE = InnoDB, PARTITION p4 VALUES IN (16,17,18,19) ENGINE = InnoDB, PARTITION p5 VALUES IN (20,21,22,23) ENGINE = InnoDB);
INSERT INTO t1 VALUES (0);
INSERT INTO t1 VALUES (1);
INSERT INTO t1 VALUES (2);
INSERT INTO t1 VALUES (3);
INSERT INTO t1 VALUES (4);
INSERT INTO t1 VALUES (5);
INSERT INTO t1 VALUES (6);
INSERT INTO t1 VALUES (7);
INSERT INTO t1 VALUES (8);
INSERT INTO t1 VALUES (9);
INSERT INTO t1 VALUES (10);
INSERT INTO t1 VALUES (11);
INSERT INTO t1 VALUES (12);
INSERT INTO t1 VALUES (13);
INSERT INTO t1 VALUES (14);
INSERT INTO t1 VALUES (15);
INSERT INTO t1 VALUES (16);
INSERT INTO t1 VALUES (17);
INSERT INTO t1 VALUES (18);
INSERT INTO t1 VALUES (19);
INSERT INTO t1 VALUES (20);
INSERT INTO t1 VALUES (21);
INSERT INTO t1 VALUES (23);
INSERT INTO t2 VALUES (0);
INSERT INTO t2 VALUES (1);
INSERT INTO t2 VALUES (2);
INSERT INTO t2 VALUES (3);
INSERT INTO t2 VALUES (4);
INSERT INTO t2 VALUES (5);
INSERT INTO t2 VALUES (6);
INSERT INTO t2 VALUES (7);
INSERT INTO t2 VALUES (8);
INSERT INTO t2 VALUES (9);
INSERT INTO t2 VALUES (10);
INSERT INTO t2 VALUES (11);
INSERT INTO t2 VALUES (12);
INSERT INTO t2 VALUES (13);
INSERT INTO t2 VALUES (14);
INSERT INTO t2 VALUES (15);
INSERT INTO t2 VALUES (16);
INSERT INTO t2 VALUES (17);
INSERT INTO t2 VALUES (18);
INSERT INTO t2 VALUES (19);
INSERT INTO t2 VALUES (20);
INSERT INTO t2 VALUES (21);
INSERT INTO t2 VALUES (23);
SELECT * FROM t1;
SELECT * FROM t2;
