-
Notifications
You must be signed in to change notification settings - Fork 4k
/
Copy pathpartition_list_error.result
66 lines (66 loc) · 2.68 KB
/
partition_list_error.result
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 ( c1 SMALLINT, c2 INT) PARTITION BY LIST (c1) (
PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
ERROR HY000: Multiple definition of same constant in list partitioning
CREATE TABLE t1 (id SMALLINT, name VARCHAR(30), adate DATE)
PARTITION BY LIST(YEAR(adate))
(
PARTITION p1 VALUES IN (1995, 1999, 2003),
PARTITION p1 VALUES IN (1996, 2000, 2004)
);
ERROR HY000: Duplicate partition name p1
CREATE TABLE t1 ( c1 MEDIUMINT, c2 INT) PARTITION BY LIST (c1) (
PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
ERROR HY000: Multiple definition of same constant in list partitioning
CREATE TABLE t1 (id MEDIUMINT, name VARCHAR(30), adate DATE)
PARTITION BY LIST(YEAR(adate))
(
PARTITION p1 VALUES IN (1995, 1999, 2003),
PARTITION p1 VALUES IN (1996, 2000, 2004)
);
ERROR HY000: Duplicate partition name p1
CREATE TABLE t1 ( c1 INT, c2 INT) PARTITION BY LIST (c1) (
PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
ERROR HY000: Multiple definition of same constant in list partitioning
CREATE TABLE t1 (id INT, name VARCHAR(30), adate DATE)
PARTITION BY LIST(YEAR(adate))
(
PARTITION p1 VALUES IN (1995, 1999, 2003),
PARTITION p1 VALUES IN (1996, 2000, 2004)
);
ERROR HY000: Duplicate partition name p1
CREATE TABLE t1 ( c1 INTEGER, c2 INT) PARTITION BY LIST (c1) (
PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
ERROR HY000: Multiple definition of same constant in list partitioning
CREATE TABLE t1 (id INTEGER, name VARCHAR(30), adate DATE)
PARTITION BY LIST(YEAR(adate))
(
PARTITION p1 VALUES IN (1995, 1999, 2003),
PARTITION p1 VALUES IN (1996, 2000, 2004)
);
ERROR HY000: Duplicate partition name p1
CREATE TABLE t1 ( c1 BIGINT, c2 INT) PARTITION BY LIST (c1) (
PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 21),
PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
ERROR HY000: Multiple definition of same constant in list partitioning
CREATE TABLE t1 (id BIGINT, name VARCHAR(30), adate DATE)
PARTITION BY LIST(YEAR(adate))
(
PARTITION p1 VALUES IN (1995, 1999, 2003),
PARTITION p1 VALUES IN (1996, 2000, 2004)
);
ERROR HY000: Duplicate partition name p1