Debian Codegraph @

mysql-test/suite/engines/funcs/t/ta_rename.test

raw
1 --disable_warnings
2 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3 --enable_warnings
4
5 --disable_warnings
6 DROP TABLE IF EXISTS t1;
7 --enable_warnings
8 SET sql_mode='NO_ENGINE_SUBSTITUTION';
9 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
10 SHOW TABLES;
11 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
12 SHOW CREATE TABLE t1;
13 ALTER TABLE t1 RENAME t2;
14 SHOW TABLES;
15 --error 1051
16 DROP TABLE t1;
17 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
18 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
19 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
20 SHOW TABLES;
21 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
22 SHOW CREATE TABLE t1;
23 ALTER TABLE t1 RENAME t2;
24 SHOW TABLES;
25 --error 1051
26 DROP TABLE t1;
27 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
28 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
29 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
30 SHOW TABLES;
31 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
32 SHOW CREATE TABLE t1;
33 ALTER TABLE t1 RENAME t2;
34 SHOW TABLES;
35 --error 1051
36 DROP TABLE t1;
37 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
38 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
39 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
40 SHOW TABLES;
41 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
42 SHOW CREATE TABLE t1;
43 ALTER TABLE t1 RENAME t2;
44 SHOW TABLES;
45 --error 1051
46 DROP TABLE t1;
47 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
49 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
50 SHOW TABLES;
51 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
52 SHOW CREATE TABLE t1;
53 ALTER TABLE t1 RENAME t2;
54 SHOW TABLES;
55 --error 1051
56 DROP TABLE t1;
57 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
58 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
59 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
60 SHOW TABLES;
61 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
62 SHOW CREATE TABLE t1;
63 ALTER TABLE t1 RENAME t2;
64 SHOW TABLES;
65 --error 1051
66 DROP TABLE t1;
67 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
68 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
69 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
70 SHOW TABLES;
71 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
72 SHOW CREATE TABLE t1;
73 ALTER TABLE t1 RENAME t2;
74 SHOW TABLES;
75 --error 1051
76 DROP TABLE t1;
77 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
78 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
79 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
80 SHOW TABLES;
81 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
82 SHOW CREATE TABLE t1;
83 ALTER TABLE t1 RENAME t2;
84 SHOW TABLES;
85 --error 1051
86 DROP TABLE t1;
87 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
88 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
89 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
90 SHOW TABLES;
91 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
92 SHOW CREATE TABLE t1;
93 ALTER TABLE t1 RENAME t2;
94 SHOW TABLES;
95 --error 1051
96 DROP TABLE t1;
97 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
98 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
99 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
100 SHOW TABLES;
101 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
102 SHOW CREATE TABLE t1;
103 ALTER TABLE t1 RENAME t2;
104 SHOW TABLES;
105 --error 1051
106 DROP TABLE t1;
107 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
108 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
109 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
110 SHOW TABLES;
111 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
112 SHOW CREATE TABLE t1;
113 ALTER TABLE t1 RENAME t2;
114 SHOW TABLES;
115 --error 1051
116 DROP TABLE t1;
117 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
118 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
119 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
120 SHOW TABLES;
121 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
122 SHOW CREATE TABLE t1;
123 ALTER TABLE t1 RENAME t2;
124 SHOW TABLES;
125 --error 1051
126 DROP TABLE t1;
127 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
128 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
129 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
130 SHOW TABLES;
131 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
132 SHOW CREATE TABLE t1;
133 ALTER TABLE t1 RENAME t2;
134 SHOW TABLES;
135 --error 1051
136 DROP TABLE t1;
137 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
138 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
139 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
140 SHOW TABLES;
141 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
142 SHOW CREATE TABLE t1;
143 ALTER TABLE t1 RENAME t2;
144 SHOW TABLES;
145 --error 1051
146 DROP TABLE t1;
147 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
148 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
149 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
150 SHOW TABLES;
151 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
152 SHOW CREATE TABLE t1;
153 ALTER TABLE t1 RENAME t2;
154 SHOW TABLES;
155 --error 1051
156 DROP TABLE t1;
157 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
158 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
159 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
160 SHOW TABLES;
161 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
162 SHOW CREATE TABLE t1;
163 ALTER TABLE t1 RENAME t2;
164 SHOW TABLES;
165 --error 1051
166 DROP TABLE t1;
167 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
168 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
169 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT);
170 SHOW TABLES;
171 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
172 SHOW CREATE TABLE t1;
173 ALTER TABLE t1 RENAME TO t2;
174 SHOW TABLES;
175 --error 1051
176 DROP TABLE t1;
177 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
178 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
179 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT);
180 SHOW TABLES;
181 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
182 SHOW CREATE TABLE t1;
183 ALTER TABLE t1 RENAME TO t2;
184 SHOW TABLES;
185 --error 1051
186 DROP TABLE t1;
187 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
188 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
189 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT);
190 SHOW TABLES;
191 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
192 SHOW CREATE TABLE t1;
193 ALTER TABLE t1 RENAME TO t2;
194 SHOW TABLES;
195 --error 1051
196 DROP TABLE t1;
197 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
198 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
199 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT);
200 SHOW TABLES;
201 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
202 SHOW CREATE TABLE t1;
203 ALTER TABLE t1 RENAME TO t2;
204 SHOW TABLES;
205 --error 1051
206 DROP TABLE t1;
207 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
208 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
209 CREATE TABLE t1(c1 INT NOT NULL, c2 INT);
210 SHOW TABLES;
211 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
212 SHOW CREATE TABLE t1;
213 ALTER TABLE t1 RENAME TO t2;
214 SHOW TABLES;
215 --error 1051
216 DROP TABLE t1;
217 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
218 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
219 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER);
220 SHOW TABLES;
221 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
222 SHOW CREATE TABLE t1;
223 ALTER TABLE t1 RENAME TO t2;
224 SHOW TABLES;
225 --error 1051
226 DROP TABLE t1;
227 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
228 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
229 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT);
230 SHOW TABLES;
231 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
232 SHOW CREATE TABLE t1;
233 ALTER TABLE t1 RENAME TO t2;
234 SHOW TABLES;
235 --error 1051
236 DROP TABLE t1;
237 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
238 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
239 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL);
240 SHOW TABLES;
241 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
242 SHOW CREATE TABLE t1;
243 ALTER TABLE t1 RENAME TO t2;
244 SHOW TABLES;
245 --error 1051
246 DROP TABLE t1;
247 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
248 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
249 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE);
250 SHOW TABLES;
251 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
252 SHOW CREATE TABLE t1;
253 ALTER TABLE t1 RENAME TO t2;
254 SHOW TABLES;
255 --error 1051
256 DROP TABLE t1;
257 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
258 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
259 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT);
260 SHOW TABLES;
261 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
262 SHOW CREATE TABLE t1;
263 ALTER TABLE t1 RENAME TO t2;
264 SHOW TABLES;
265 --error 1051
266 DROP TABLE t1;
267 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
268 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
269 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL);
270 SHOW TABLES;
271 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
272 SHOW CREATE TABLE t1;
273 ALTER TABLE t1 RENAME TO t2;
274 SHOW TABLES;
275 --error 1051
276 DROP TABLE t1;
277 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
278 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
279 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC);
280 SHOW TABLES;
281 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
282 SHOW CREATE TABLE t1;
283 ALTER TABLE t1 RENAME TO t2;
284 SHOW TABLES;
285 --error 1051
286 DROP TABLE t1;
287 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
288 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
289 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE);
290 SHOW TABLES;
291 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
292 SHOW CREATE TABLE t1;
293 ALTER TABLE t1 RENAME TO t2;
294 SHOW TABLES;
295 --error 1051
296 DROP TABLE t1;
297 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
298 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
299 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME);
300 SHOW TABLES;
301 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
302 SHOW CREATE TABLE t1;
303 ALTER TABLE t1 RENAME TO t2;
304 SHOW TABLES;
305 --error 1051
306 DROP TABLE t1;
307 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
308 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
309 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP);
310 SHOW TABLES;
311 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
312 SHOW CREATE TABLE t1;
313 ALTER TABLE t1 RENAME TO t2;
314 SHOW TABLES;
315 --error 1051
316 DROP TABLE t1;
317 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
318 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
319 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR);
320 SHOW TABLES;
321 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
322 SHOW CREATE TABLE t1;
323 ALTER TABLE t1 RENAME TO t2;
324 SHOW TABLES;
325 --error 1051
326 DROP TABLE t1;
327 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
328 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
329 SET sql_mode=default;