2 DROP TABLE IF EXISTS t1;
4 --error ER_SAME_NAME_PARTITION
5 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
6 PARTITION p0 VALUES LESS THAN (10),
7 PARTITION p1 VALUES LESS THAN (20),
8 PARTITION p1 VALUES LESS THAN (30),
9 PARTITION p3 VALUES LESS THAN MAXVALUE
11 --error ER_RANGE_NOT_INCREASING_ERROR
12 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
13 PARTITION p0 VALUES LESS THAN (10),
14 PARTITION p1 VALUES LESS THAN (10),
15 PARTITION p2 VALUES LESS THAN (30),
16 PARTITION p3 VALUES LESS THAN MAXVALUE
18 --error ER_SAME_NAME_PARTITION
19 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
20 PARTITION p0 VALUES LESS THAN (10),
21 PARTITION p1 VALUES LESS THAN (20),
22 PARTITION p1 VALUES LESS THAN (30),
23 PARTITION p3 VALUES LESS THAN MAXVALUE
25 --error ER_RANGE_NOT_INCREASING_ERROR
26 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
27 PARTITION p0 VALUES LESS THAN (10),
28 PARTITION p1 VALUES LESS THAN (10),
29 PARTITION p2 VALUES LESS THAN (30),
30 PARTITION p3 VALUES LESS THAN MAXVALUE
32 --error ER_SAME_NAME_PARTITION
33 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
34 PARTITION p0 VALUES LESS THAN (10),
35 PARTITION p1 VALUES LESS THAN (20),
36 PARTITION p1 VALUES LESS THAN (30),
37 PARTITION p3 VALUES LESS THAN MAXVALUE
39 --error ER_RANGE_NOT_INCREASING_ERROR
40 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
41 PARTITION p0 VALUES LESS THAN (10),
42 PARTITION p1 VALUES LESS THAN (10),
43 PARTITION p2 VALUES LESS THAN (30),
44 PARTITION p3 VALUES LESS THAN MAXVALUE
46 --error ER_SAME_NAME_PARTITION
47 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
48 PARTITION p0 VALUES LESS THAN (10),
49 PARTITION p1 VALUES LESS THAN (20),
50 PARTITION p1 VALUES LESS THAN (30),
51 PARTITION p3 VALUES LESS THAN MAXVALUE
53 --error ER_RANGE_NOT_INCREASING_ERROR
54 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
55 PARTITION p0 VALUES LESS THAN (10),
56 PARTITION p1 VALUES LESS THAN (10),
57 PARTITION p2 VALUES LESS THAN (30),
58 PARTITION p3 VALUES LESS THAN MAXVALUE
60 --error ER_SAME_NAME_PARTITION
61 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
62 PARTITION p0 VALUES LESS THAN (10),
63 PARTITION p1 VALUES LESS THAN (20),
64 PARTITION p1 VALUES LESS THAN (30),
65 PARTITION p3 VALUES LESS THAN MAXVALUE
67 --error ER_RANGE_NOT_INCREASING_ERROR
68 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
69 PARTITION p0 VALUES LESS THAN (10),
70 PARTITION p1 VALUES LESS THAN (10),
71 PARTITION p2 VALUES LESS THAN (30),
72 PARTITION p3 VALUES LESS THAN MAXVALUE