Debian Codegraph @

mysql-test/suite/parts/t/partition_value_error.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
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
10 );
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
17 );
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
24 );
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
31 );
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
38 );
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
45 );
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
52 );
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
59 );
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
66 );
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
73 );
74