Debian Codegraph @

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

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