Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t2;
3 --enable_warnings
4 CREATE TABLE t2 (c1 TINYINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
5 SHOW TABLES;
6 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
7 CREATE TABLE t2 (c1 SMALLINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
8 SHOW TABLES;
9 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
10 CREATE TABLE t2 (c1 MEDIUMINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
11 SHOW TABLES;
12 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
13 CREATE TABLE t2 (c1 INT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
14 SHOW TABLES;
15 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
16 CREATE TABLE t2 (c1 INTEGER NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
17 SHOW TABLES;
18 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
19 CREATE TABLE t2 (c1 BIGINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
20 SHOW TABLES;
21 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
22 CREATE TABLE t2 (c1 TINYINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
23 SHOW TABLES;
24 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
25 CREATE TABLE t2 (c1 SMALLINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
26 SHOW TABLES;
27 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
28 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
29 SHOW TABLES;
30 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
31 CREATE TABLE t2 (c1 INT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
32 SHOW TABLES;
33 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
34 CREATE TABLE t2 (c1 INTEGER NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
35 SHOW TABLES;
36 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
37 CREATE TABLE t2 (c1 BIGINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
38 SHOW TABLES;
39 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
40 CREATE TABLE t2 (c1 TINYINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
41 SHOW TABLES;
42 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
43 CREATE TABLE t2 (c1 SMALLINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
44 SHOW TABLES;
45 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
46 CREATE TABLE t2 (c1 MEDIUMINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
47 SHOW TABLES;
48 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
49 CREATE TABLE t2 (c1 INT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
50 SHOW TABLES;
51 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
52 CREATE TABLE t2 (c1 INTEGER NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
53 SHOW TABLES;
54 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
55 CREATE TABLE t2 (c1 BIGINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
56 SHOW TABLES;
57 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
58 CREATE TABLE t2 (c1 TINYINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
59 SHOW TABLES;
60 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
61 CREATE TABLE t2 (c1 SMALLINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
62 SHOW TABLES;
63 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
64 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
65 SHOW TABLES;
66 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
67 CREATE TABLE t2 (c1 INT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
68 SHOW TABLES;
69 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
70 CREATE TABLE t2 (c1 INTEGER NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
71 SHOW TABLES;
72 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
73 CREATE TABLE t2 (c1 BIGINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
74 SHOW TABLES;
75 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
76 CREATE TABLE t2 (c1 TINYINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
77 SHOW TABLES;
78 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
79 CREATE TABLE t2 (c1 SMALLINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
80 SHOW TABLES;
81 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
82 CREATE TABLE t2 (c1 MEDIUMINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
83 SHOW TABLES;
84 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
85 CREATE TABLE t2 (c1 INT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
86 SHOW TABLES;
87 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
88 CREATE TABLE t2 (c1 INTEGER NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
89 SHOW TABLES;
90 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
91 CREATE TABLE t2 (c1 BIGINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
92 SHOW TABLES;
93 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
94 CREATE TABLE t2 (c1 TINYINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
95 SHOW TABLES;
96 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
97 CREATE TABLE t2 (c1 SMALLINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
98 SHOW TABLES;
99 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
100 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
101 SHOW TABLES;
102 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
103 CREATE TABLE t2 (c1 INT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
104 SHOW TABLES;
105 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
106 CREATE TABLE t2 (c1 INTEGER NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
107 SHOW TABLES;
108 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
109 CREATE TABLE t2 (c1 BIGINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
110 SHOW TABLES;
111 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
112 CREATE TABLE t2 (c1 TINYINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
113 SHOW TABLES;
114 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
115 CREATE TABLE t2 (c1 SMALLINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
116 SHOW TABLES;
117 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
118 CREATE TABLE t2 (c1 MEDIUMINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
119 SHOW TABLES;
120 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
121 CREATE TABLE t2 (c1 INT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
122 SHOW TABLES;
123 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
124 CREATE TABLE t2 (c1 INTEGER NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
125 SHOW TABLES;
126 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
127 CREATE TABLE t2 (c1 BIGINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
128 SHOW TABLES;
129 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
130 CREATE TABLE t2 (c1 TINYINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
131 SHOW TABLES;
132 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
133 CREATE TABLE t2 (c1 SMALLINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
134 SHOW TABLES;
135 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
136 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
137 SHOW TABLES;
138 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
139 CREATE TABLE t2 (c1 INT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
140 SHOW TABLES;
141 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
142 CREATE TABLE t2 (c1 INTEGER NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
143 SHOW TABLES;
144 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
145 CREATE TABLE t2 (c1 BIGINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
146 SHOW TABLES;
147 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;