Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 --error ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR
5 CREATE TABLE t1 ( c1 SMALLINT, c2 INT) PARTITION BY LIST (c1) (
6 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
7 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
8 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
9 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
10 --error ER_SAME_NAME_PARTITION
11 CREATE TABLE t1 (id SMALLINT, name VARCHAR(30), adate DATE)
12 PARTITION BY LIST(YEAR(adate))
13 (
14 PARTITION p1 VALUES IN (1995, 1999, 2003),
15 PARTITION p1 VALUES IN (1996, 2000, 2004)
16 );
17 --error ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR
18 CREATE TABLE t1 ( c1 MEDIUMINT, c2 INT) PARTITION BY LIST (c1) (
19 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
20 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
21 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
22 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
23 --error ER_SAME_NAME_PARTITION
24 CREATE TABLE t1 (id MEDIUMINT, name VARCHAR(30), adate DATE)
25 PARTITION BY LIST(YEAR(adate))
26 (
27 PARTITION p1 VALUES IN (1995, 1999, 2003),
28 PARTITION p1 VALUES IN (1996, 2000, 2004)
29 );
30 --error ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR
31 CREATE TABLE t1 ( c1 INT, c2 INT) PARTITION BY LIST (c1) (
32 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
33 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
34 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
35 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
36 --error ER_SAME_NAME_PARTITION
37 CREATE TABLE t1 (id INT, name VARCHAR(30), adate DATE)
38 PARTITION BY LIST(YEAR(adate))
39 (
40 PARTITION p1 VALUES IN (1995, 1999, 2003),
41 PARTITION p1 VALUES IN (1996, 2000, 2004)
42 );
43 --error ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR
44 CREATE TABLE t1 ( c1 INTEGER, c2 INT) PARTITION BY LIST (c1) (
45 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
46 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
47 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
48 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
49 --error ER_SAME_NAME_PARTITION
50 CREATE TABLE t1 (id INTEGER, name VARCHAR(30), adate DATE)
51 PARTITION BY LIST(YEAR(adate))
52 (
53 PARTITION p1 VALUES IN (1995, 1999, 2003),
54 PARTITION p1 VALUES IN (1996, 2000, 2004)
55 );
56 --error ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR
57 CREATE TABLE t1 ( c1 BIGINT, c2 INT) PARTITION BY LIST (c1) (
58 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
59 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
60 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
61 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
62 --error ER_SAME_NAME_PARTITION
63 CREATE TABLE t1 (id BIGINT, name VARCHAR(30), adate DATE)
64 PARTITION BY LIST(YEAR(adate))
65 (
66 PARTITION p1 VALUES IN (1995, 1999, 2003),
67 PARTITION p1 VALUES IN (1996, 2000, 2004)
68 );
69