Debian Codegraph @

mysql-test/suite/parts/r/partition_value_error.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
3 PARTITION p0 VALUES LESS THAN (10),
4 PARTITION p1 VALUES LESS THAN (20),
5 PARTITION p1 VALUES LESS THAN (30),
6 PARTITION p3 VALUES LESS THAN MAXVALUE
7 );
8 ERROR HY000: Duplicate partition name p1
9 CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
10 PARTITION p0 VALUES LESS THAN (10),
11 PARTITION p1 VALUES LESS THAN (10),
12 PARTITION p2 VALUES LESS THAN (30),
13 PARTITION p3 VALUES LESS THAN MAXVALUE
14 );
15 ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition
16 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
17 PARTITION p0 VALUES LESS THAN (10),
18 PARTITION p1 VALUES LESS THAN (20),
19 PARTITION p1 VALUES LESS THAN (30),
20 PARTITION p3 VALUES LESS THAN MAXVALUE
21 );
22 ERROR HY000: Duplicate partition name p1
23 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
24 PARTITION p0 VALUES LESS THAN (10),
25 PARTITION p1 VALUES LESS THAN (10),
26 PARTITION p2 VALUES LESS THAN (30),
27 PARTITION p3 VALUES LESS THAN MAXVALUE
28 );
29 ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition
30 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
31 PARTITION p0 VALUES LESS THAN (10),
32 PARTITION p1 VALUES LESS THAN (20),
33 PARTITION p1 VALUES LESS THAN (30),
34 PARTITION p3 VALUES LESS THAN MAXVALUE
35 );
36 ERROR HY000: Duplicate partition name p1
37 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
38 PARTITION p0 VALUES LESS THAN (10),
39 PARTITION p1 VALUES LESS THAN (10),
40 PARTITION p2 VALUES LESS THAN (30),
41 PARTITION p3 VALUES LESS THAN MAXVALUE
42 );
43 ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition
44 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
45 PARTITION p0 VALUES LESS THAN (10),
46 PARTITION p1 VALUES LESS THAN (20),
47 PARTITION p1 VALUES LESS THAN (30),
48 PARTITION p3 VALUES LESS THAN MAXVALUE
49 );
50 ERROR HY000: Duplicate partition name p1
51 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
52 PARTITION p0 VALUES LESS THAN (10),
53 PARTITION p1 VALUES LESS THAN (10),
54 PARTITION p2 VALUES LESS THAN (30),
55 PARTITION p3 VALUES LESS THAN MAXVALUE
56 );
57 ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition
58 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
59 PARTITION p0 VALUES LESS THAN (10),
60 PARTITION p1 VALUES LESS THAN (20),
61 PARTITION p1 VALUES LESS THAN (30),
62 PARTITION p3 VALUES LESS THAN MAXVALUE
63 );
64 ERROR HY000: Duplicate partition name p1
65 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
66 PARTITION p0 VALUES LESS THAN (10),
67 PARTITION p1 VALUES LESS THAN (10),
68 PARTITION p2 VALUES LESS THAN (30),
69 PARTITION p3 VALUES LESS THAN MAXVALUE
70 );
71 ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition