Debian Codegraph @

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

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