2
DROP TABLE IF EXISTS t1;
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))
14
PARTITION p1 VALUES IN (1995, 1999, 2003),
15
PARTITION p1 VALUES IN (1996, 2000, 2004)
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))
27
PARTITION p1 VALUES IN (1995, 1999, 2003),
28
PARTITION p1 VALUES IN (1996, 2000, 2004)
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))
40
PARTITION p1 VALUES IN (1995, 1999, 2003),
41
PARTITION p1 VALUES IN (1996, 2000, 2004)
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))
53
PARTITION p1 VALUES IN (1995, 1999, 2003),
54
PARTITION p1 VALUES IN (1996, 2000, 2004)
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))
66
PARTITION p1 VALUES IN (1995, 1999, 2003),
67
PARTITION p1 VALUES IN (1996, 2000, 2004)