Debian Codegraph @

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

raw
1 --source include/no_valgrind_without_big.inc
2
3 --disable_warnings
4 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
5 --enable_warnings
6
7 --disable_warnings
8 DROP TABLE IF EXISTS t1;
9 --enable_warnings
10 SET sql_mode='NO_ENGINE_SUBSTITUTION';
11 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
12 SHOW TABLES;
13 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
14 SHOW CREATE TABLE t1;
15 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
16 SHOW TABLES;
17 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
18 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
19 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
20 SHOW TABLES;
21 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
22 SHOW CREATE TABLE t1;
23 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
24 SHOW TABLES;
25 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
26 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
27 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
28 SHOW TABLES;
29 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
30 SHOW CREATE TABLE t1;
31 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
32 SHOW TABLES;
33 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
34 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
35 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
36 SHOW TABLES;
37 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
38 SHOW CREATE TABLE t1;
39 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
40 SHOW TABLES;
41 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
42 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
43 CREATE TABLE t1(c1 INT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
44 SHOW TABLES;
45 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
46 SHOW CREATE TABLE t1;
47 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
48 SHOW TABLES;
49 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
50 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
51 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
52 SHOW TABLES;
53 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
54 SHOW CREATE TABLE t1;
55 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
56 SHOW TABLES;
57 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
58 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
59 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
60 SHOW TABLES;
61 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
62 SHOW CREATE TABLE t1;
63 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
64 SHOW TABLES;
65 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
66 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
67 CREATE TABLE t1(c1 REAL NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
68 SHOW TABLES;
69 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
70 SHOW CREATE TABLE t1;
71 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
72 SHOW TABLES;
73 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
74 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
75 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
76 SHOW TABLES;
77 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
78 SHOW CREATE TABLE t1;
79 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
80 SHOW TABLES;
81 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
82 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
83 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
84 SHOW TABLES;
85 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
86 SHOW CREATE TABLE t1;
87 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
88 SHOW TABLES;
89 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
90 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
91 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
92 SHOW TABLES;
93 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
94 SHOW CREATE TABLE t1;
95 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
96 SHOW TABLES;
97 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
98 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
99 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
100 SHOW TABLES;
101 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
102 SHOW CREATE TABLE t1;
103 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
104 SHOW TABLES;
105 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
106 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
107 CREATE TABLE t1(c1 DATE NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
108 SHOW TABLES;
109 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
110 SHOW CREATE TABLE t1;
111 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
112 SHOW TABLES;
113 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
114 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
115 CREATE TABLE t1(c1 TIME NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
116 SHOW TABLES;
117 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
118 SHOW CREATE TABLE t1;
119 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
120 SHOW TABLES;
121 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
122 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
123 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
124 SHOW TABLES;
125 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
126 SHOW CREATE TABLE t1;
127 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
128 SHOW TABLES;
129 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
130 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
131 CREATE TABLE t1(c1 YEAR NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
132 SHOW TABLES;
133 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
134 SHOW CREATE TABLE t1;
135 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
136 SHOW TABLES;
137 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
138 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
139 CREATE TABLE t1(c1 BIT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
140 SHOW TABLES;
141 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
142 SHOW CREATE TABLE t1;
143 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
144 SHOW TABLES;
145 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
146 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
147 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
148 SHOW TABLES;
149 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
150 SHOW CREATE TABLE t1;
151 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
152 SHOW TABLES;
153 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
154 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
155 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
156 SHOW TABLES;
157 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
158 SHOW CREATE TABLE t1;
159 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
160 SHOW TABLES;
161 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
162 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
163 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
164 SHOW TABLES;
165 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
166 SHOW CREATE TABLE t1;
167 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
168 SHOW TABLES;
169 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
170 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
171 CREATE TABLE t1(c1 INT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
172 SHOW TABLES;
173 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
174 SHOW CREATE TABLE t1;
175 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
176 SHOW TABLES;
177 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
178 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
179 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
180 SHOW TABLES;
181 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
182 SHOW CREATE TABLE t1;
183 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
184 SHOW TABLES;
185 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
186 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
187 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
188 SHOW TABLES;
189 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
190 SHOW CREATE TABLE t1;
191 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
192 SHOW TABLES;
193 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
194 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
195 CREATE TABLE t1(c1 REAL NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
196 SHOW TABLES;
197 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
198 SHOW CREATE TABLE t1;
199 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
200 SHOW TABLES;
201 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
202 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
203 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
204 SHOW TABLES;
205 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
206 SHOW CREATE TABLE t1;
207 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
208 SHOW TABLES;
209 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
210 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
211 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
212 SHOW TABLES;
213 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
214 SHOW CREATE TABLE t1;
215 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
216 SHOW TABLES;
217 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
218 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
219 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
220 SHOW TABLES;
221 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
222 SHOW CREATE TABLE t1;
223 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
224 SHOW TABLES;
225 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
226 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
227 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
228 SHOW TABLES;
229 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
230 SHOW CREATE TABLE t1;
231 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
232 SHOW TABLES;
233 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
234 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
235 CREATE TABLE t1(c1 DATE NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
236 SHOW TABLES;
237 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
238 SHOW CREATE TABLE t1;
239 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
240 SHOW TABLES;
241 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
242 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
243 CREATE TABLE t1(c1 TIME NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
244 SHOW TABLES;
245 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
246 SHOW CREATE TABLE t1;
247 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
248 SHOW TABLES;
249 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
250 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
251 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
252 SHOW TABLES;
253 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
254 SHOW CREATE TABLE t1;
255 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
256 SHOW TABLES;
257 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
258 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
259 CREATE TABLE t1(c1 YEAR NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
260 SHOW TABLES;
261 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
262 SHOW CREATE TABLE t1;
263 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
264 SHOW TABLES;
265 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
266 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
267 CREATE TABLE t1(c1 BIT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
268 SHOW TABLES;
269 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
270 SHOW CREATE TABLE t1;
271 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
272 SHOW TABLES;
273 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
274 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
275 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
276 SHOW TABLES;
277 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
278 SHOW CREATE TABLE t1;
279 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
280 SHOW TABLES;
281 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
282 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
283 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
284 SHOW TABLES;
285 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
286 SHOW CREATE TABLE t1;
287 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
288 SHOW TABLES;
289 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
290 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
291 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
292 SHOW TABLES;
293 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
294 SHOW CREATE TABLE t1;
295 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
296 SHOW TABLES;
297 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
298 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
299 CREATE TABLE t1(c1 INT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
300 SHOW TABLES;
301 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
302 SHOW CREATE TABLE t1;
303 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
304 SHOW TABLES;
305 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
306 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
307 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
308 SHOW TABLES;
309 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
310 SHOW CREATE TABLE t1;
311 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
312 SHOW TABLES;
313 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
314 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
315 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
316 SHOW TABLES;
317 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
318 SHOW CREATE TABLE t1;
319 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
320 SHOW TABLES;
321 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
322 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
323 CREATE TABLE t1(c1 REAL NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
324 SHOW TABLES;
325 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
326 SHOW CREATE TABLE t1;
327 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
328 SHOW TABLES;
329 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
330 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
331 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
332 SHOW TABLES;
333 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
334 SHOW CREATE TABLE t1;
335 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
336 SHOW TABLES;
337 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
338 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
339 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
340 SHOW TABLES;
341 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
342 SHOW CREATE TABLE t1;
343 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
344 SHOW TABLES;
345 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
346 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
347 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
348 SHOW TABLES;
349 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
350 SHOW CREATE TABLE t1;
351 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
352 SHOW TABLES;
353 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
354 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
355 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
356 SHOW TABLES;
357 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
358 SHOW CREATE TABLE t1;
359 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
360 SHOW TABLES;
361 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
362 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
363 CREATE TABLE t1(c1 DATE NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
364 SHOW TABLES;
365 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
366 SHOW CREATE TABLE t1;
367 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
368 SHOW TABLES;
369 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
370 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
371 CREATE TABLE t1(c1 TIME NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
372 SHOW TABLES;
373 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
374 SHOW CREATE TABLE t1;
375 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
376 SHOW TABLES;
377 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
378 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
379 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
380 SHOW TABLES;
381 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
382 SHOW CREATE TABLE t1;
383 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
384 SHOW TABLES;
385 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
386 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
387 CREATE TABLE t1(c1 YEAR NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
388 SHOW TABLES;
389 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
390 SHOW CREATE TABLE t1;
391 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
392 SHOW TABLES;
393 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
394 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
395 CREATE TABLE t1(c1 BIT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
396 SHOW TABLES;
397 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
398 SHOW CREATE TABLE t1;
399 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
400 SHOW TABLES;
401 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
402 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
403 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
404 SHOW TABLES;
405 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
406 SHOW CREATE TABLE t1;
407 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
408 SHOW TABLES;
409 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
410 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
411 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
412 SHOW TABLES;
413 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
414 SHOW CREATE TABLE t1;
415 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
416 SHOW TABLES;
417 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
418 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
419 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
420 SHOW TABLES;
421 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
422 SHOW CREATE TABLE t1;
423 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
424 SHOW TABLES;
425 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
426 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
427 CREATE TABLE t1(c1 INT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
428 SHOW TABLES;
429 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
430 SHOW CREATE TABLE t1;
431 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
432 SHOW TABLES;
433 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
434 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
435 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
436 SHOW TABLES;
437 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
438 SHOW CREATE TABLE t1;
439 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
440 SHOW TABLES;
441 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
442 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
443 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
444 SHOW TABLES;
445 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
446 SHOW CREATE TABLE t1;
447 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
448 SHOW TABLES;
449 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
450 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
451 CREATE TABLE t1(c1 REAL NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
452 SHOW TABLES;
453 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
454 SHOW CREATE TABLE t1;
455 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
456 SHOW TABLES;
457 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
458 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
459 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
460 SHOW TABLES;
461 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
462 SHOW CREATE TABLE t1;
463 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
464 SHOW TABLES;
465 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
466 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
467 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
468 SHOW TABLES;
469 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
470 SHOW CREATE TABLE t1;
471 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
472 SHOW TABLES;
473 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
474 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
475 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
476 SHOW TABLES;
477 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
478 SHOW CREATE TABLE t1;
479 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
480 SHOW TABLES;
481 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
482 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
483 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
484 SHOW TABLES;
485 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
486 SHOW CREATE TABLE t1;
487 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
488 SHOW TABLES;
489 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
490 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
491 CREATE TABLE t1(c1 DATE NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
492 SHOW TABLES;
493 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
494 SHOW CREATE TABLE t1;
495 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
496 SHOW TABLES;
497 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
498 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
499 CREATE TABLE t1(c1 TIME NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
500 SHOW TABLES;
501 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
502 SHOW CREATE TABLE t1;
503 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
504 SHOW TABLES;
505 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
506 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
507 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
508 SHOW TABLES;
509 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
510 SHOW CREATE TABLE t1;
511 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
512 SHOW TABLES;
513 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
514 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
515 CREATE TABLE t1(c1 YEAR NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
516 SHOW TABLES;
517 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
518 SHOW CREATE TABLE t1;
519 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
520 SHOW TABLES;
521 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
522 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
523 CREATE TABLE t1(c1 BIT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
524 SHOW TABLES;
525 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
526 SHOW CREATE TABLE t1;
527 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
528 SHOW TABLES;
529 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
530 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
531 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
532 SHOW TABLES;
533 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
534 SHOW CREATE TABLE t1;
535 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
536 SHOW TABLES;
537 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
538 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
539 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
540 SHOW TABLES;
541 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
542 SHOW CREATE TABLE t1;
543 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
544 SHOW TABLES;
545 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
546 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
547 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
548 SHOW TABLES;
549 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
550 SHOW CREATE TABLE t1;
551 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
552 SHOW TABLES;
553 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
554 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
555 CREATE TABLE t1(c1 INT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
556 SHOW TABLES;
557 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
558 SHOW CREATE TABLE t1;
559 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
560 SHOW TABLES;
561 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
562 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
563 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
564 SHOW TABLES;
565 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
566 SHOW CREATE TABLE t1;
567 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
568 SHOW TABLES;
569 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
570 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
571 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
572 SHOW TABLES;
573 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
574 SHOW CREATE TABLE t1;
575 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
576 SHOW TABLES;
577 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
578 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
579 CREATE TABLE t1(c1 REAL NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
580 SHOW TABLES;
581 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
582 SHOW CREATE TABLE t1;
583 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
584 SHOW TABLES;
585 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
586 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
587 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
588 SHOW TABLES;
589 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
590 SHOW CREATE TABLE t1;
591 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
592 SHOW TABLES;
593 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
594 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
595 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
596 SHOW TABLES;
597 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
598 SHOW CREATE TABLE t1;
599 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
600 SHOW TABLES;
601 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
602 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
603 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
604 SHOW TABLES;
605 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
606 SHOW CREATE TABLE t1;
607 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
608 SHOW TABLES;
609 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
610 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
611 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
612 SHOW TABLES;
613 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
614 SHOW CREATE TABLE t1;
615 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
616 SHOW TABLES;
617 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
618 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
619 CREATE TABLE t1(c1 DATE NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
620 SHOW TABLES;
621 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
622 SHOW CREATE TABLE t1;
623 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
624 SHOW TABLES;
625 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
626 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
627 CREATE TABLE t1(c1 TIME NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
628 SHOW TABLES;
629 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
630 SHOW CREATE TABLE t1;
631 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
632 SHOW TABLES;
633 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
634 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
635 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
636 SHOW TABLES;
637 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
638 SHOW CREATE TABLE t1;
639 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
640 SHOW TABLES;
641 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
642 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
643 CREATE TABLE t1(c1 YEAR NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
644 SHOW TABLES;
645 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
646 SHOW CREATE TABLE t1;
647 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
648 SHOW TABLES;
649 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
650 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
651 CREATE TABLE t1(c1 BIT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
652 SHOW TABLES;
653 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
654 SHOW CREATE TABLE t1;
655 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
656 SHOW TABLES;
657 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
658 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
659 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
660 SHOW TABLES;
661 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
662 SHOW CREATE TABLE t1;
663 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
664 SHOW TABLES;
665 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
666 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
667 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
668 SHOW TABLES;
669 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
670 SHOW CREATE TABLE t1;
671 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
672 SHOW TABLES;
673 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
674 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
675 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
676 SHOW TABLES;
677 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
678 SHOW CREATE TABLE t1;
679 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
680 SHOW TABLES;
681 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
682 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
683 CREATE TABLE t1(c1 INT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
684 SHOW TABLES;
685 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
686 SHOW CREATE TABLE t1;
687 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
688 SHOW TABLES;
689 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
690 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
691 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
692 SHOW TABLES;
693 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
694 SHOW CREATE TABLE t1;
695 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
696 SHOW TABLES;
697 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
698 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
699 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
700 SHOW TABLES;
701 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
702 SHOW CREATE TABLE t1;
703 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
704 SHOW TABLES;
705 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
706 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
707 CREATE TABLE t1(c1 REAL NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
708 SHOW TABLES;
709 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
710 SHOW CREATE TABLE t1;
711 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
712 SHOW TABLES;
713 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
714 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
715 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
716 SHOW TABLES;
717 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
718 SHOW CREATE TABLE t1;
719 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
720 SHOW TABLES;
721 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
722 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
723 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
724 SHOW TABLES;
725 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
726 SHOW CREATE TABLE t1;
727 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
728 SHOW TABLES;
729 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
730 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
731 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
732 SHOW TABLES;
733 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
734 SHOW CREATE TABLE t1;
735 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
736 SHOW TABLES;
737 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
738 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
739 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
740 SHOW TABLES;
741 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
742 SHOW CREATE TABLE t1;
743 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
744 SHOW TABLES;
745 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
746 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
747 CREATE TABLE t1(c1 DATE NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
748 SHOW TABLES;
749 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
750 SHOW CREATE TABLE t1;
751 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
752 SHOW TABLES;
753 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
754 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
755 CREATE TABLE t1(c1 TIME NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
756 SHOW TABLES;
757 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
758 SHOW CREATE TABLE t1;
759 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
760 SHOW TABLES;
761 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
762 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
763 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
764 SHOW TABLES;
765 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
766 SHOW CREATE TABLE t1;
767 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
768 SHOW TABLES;
769 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
770 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
771 CREATE TABLE t1(c1 YEAR NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
772 SHOW TABLES;
773 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
774 SHOW CREATE TABLE t1;
775 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
776 SHOW TABLES;
777 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
778 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
779 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
780 SHOW TABLES;
781 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
782 SHOW CREATE TABLE t1;
783 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
784 SHOW TABLES;
785 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
786 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
787 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
788 SHOW TABLES;
789 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
790 SHOW CREATE TABLE t1;
791 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
792 SHOW TABLES;
793 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
794 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
795 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
796 SHOW TABLES;
797 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
798 SHOW CREATE TABLE t1;
799 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
800 SHOW TABLES;
801 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
802 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
803 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
804 SHOW TABLES;
805 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
806 SHOW CREATE TABLE t1;
807 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
808 SHOW TABLES;
809 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
810 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
811 CREATE TABLE t1(c1 INT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
812 SHOW TABLES;
813 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
814 SHOW CREATE TABLE t1;
815 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
816 SHOW TABLES;
817 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
818 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
819 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
820 SHOW TABLES;
821 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
822 SHOW CREATE TABLE t1;
823 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
824 SHOW TABLES;
825 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
826 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
827 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
828 SHOW TABLES;
829 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
830 SHOW CREATE TABLE t1;
831 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
832 SHOW TABLES;
833 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
834 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
835 CREATE TABLE t1(c1 REAL NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
836 SHOW TABLES;
837 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
838 SHOW CREATE TABLE t1;
839 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
840 SHOW TABLES;
841 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
842 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
843 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
844 SHOW TABLES;
845 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
846 SHOW CREATE TABLE t1;
847 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
848 SHOW TABLES;
849 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
850 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
851 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
852 SHOW TABLES;
853 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
854 SHOW CREATE TABLE t1;
855 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
856 SHOW TABLES;
857 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
858 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
859 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
860 SHOW TABLES;
861 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
862 SHOW CREATE TABLE t1;
863 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
864 SHOW TABLES;
865 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
866 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
867 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
868 SHOW TABLES;
869 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
870 SHOW CREATE TABLE t1;
871 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
872 SHOW TABLES;
873 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
874 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
875 CREATE TABLE t1(c1 DATE NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
876 SHOW TABLES;
877 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
878 SHOW CREATE TABLE t1;
879 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
880 SHOW TABLES;
881 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
882 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
883 CREATE TABLE t1(c1 TIME NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
884 SHOW TABLES;
885 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
886 SHOW CREATE TABLE t1;
887 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
888 SHOW TABLES;
889 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
890 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
891 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
892 SHOW TABLES;
893 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
894 SHOW CREATE TABLE t1;
895 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
896 SHOW TABLES;
897 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
898 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
899 CREATE TABLE t1(c1 YEAR NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
900 SHOW TABLES;
901 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
902 SHOW CREATE TABLE t1;
903 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
904 SHOW TABLES;
905 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
906 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
907 CREATE TABLE t1(c1 BIT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
908 SHOW TABLES;
909 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
910 SHOW CREATE TABLE t1;
911 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
912 SHOW TABLES;
913 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
914 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
915 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
916 SHOW TABLES;
917 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
918 SHOW CREATE TABLE t1;
919 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
920 SHOW TABLES;
921 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
922 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
923 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
924 SHOW TABLES;
925 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
926 SHOW CREATE TABLE t1;
927 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
928 SHOW TABLES;
929 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
930 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
931 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
932 SHOW TABLES;
933 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
934 SHOW CREATE TABLE t1;
935 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
936 SHOW TABLES;
937 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
938 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
939 CREATE TABLE t1(c1 INT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
940 SHOW TABLES;
941 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
942 SHOW CREATE TABLE t1;
943 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
944 SHOW TABLES;
945 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
946 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
947 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
948 SHOW TABLES;
949 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
950 SHOW CREATE TABLE t1;
951 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
952 SHOW TABLES;
953 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
954 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
955 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
956 SHOW TABLES;
957 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
958 SHOW CREATE TABLE t1;
959 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
960 SHOW TABLES;
961 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
962 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
963 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
964 SHOW TABLES;
965 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
966 SHOW CREATE TABLE t1;
967 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
968 SHOW TABLES;
969 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
970 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
971 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
972 SHOW TABLES;
973 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
974 SHOW CREATE TABLE t1;
975 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
976 SHOW TABLES;
977 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
978 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
979 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
980 SHOW TABLES;
981 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
982 SHOW CREATE TABLE t1;
983 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
984 SHOW TABLES;
985 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
986 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
987 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
988 SHOW TABLES;
989 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
990 SHOW CREATE TABLE t1;
991 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
992 SHOW TABLES;
993 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
994 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
995 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
996 SHOW TABLES;
997 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
998 SHOW CREATE TABLE t1;
999 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1000 SHOW TABLES;
1001 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1002 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1003 CREATE TABLE t1(c1 DATE NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1004 SHOW TABLES;
1005 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1006 SHOW CREATE TABLE t1;
1007 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1008 SHOW TABLES;
1009 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1010 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1011 CREATE TABLE t1(c1 TIME NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1012 SHOW TABLES;
1013 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1014 SHOW CREATE TABLE t1;
1015 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1016 SHOW TABLES;
1017 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1018 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1019 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1020 SHOW TABLES;
1021 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1022 SHOW CREATE TABLE t1;
1023 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1024 SHOW TABLES;
1025 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1026 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1027 CREATE TABLE t1(c1 YEAR NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1028 SHOW TABLES;
1029 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1030 SHOW CREATE TABLE t1;
1031 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1032 SHOW TABLES;
1033 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1034 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1035 CREATE TABLE t1(c1 BIT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1036 SHOW TABLES;
1037 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1038 SHOW CREATE TABLE t1;
1039 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1040 SHOW TABLES;
1041 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1042 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1043 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1044 SHOW TABLES;
1045 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1046 SHOW CREATE TABLE t1;
1047 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1048 SHOW TABLES;
1049 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1050 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1051 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1052 SHOW TABLES;
1053 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1054 SHOW CREATE TABLE t1;
1055 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1056 SHOW TABLES;
1057 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1058 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1059 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1060 SHOW TABLES;
1061 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1062 SHOW CREATE TABLE t1;
1063 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1064 SHOW TABLES;
1065 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1066 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1067 CREATE TABLE t1(c1 INT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1068 SHOW TABLES;
1069 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1070 SHOW CREATE TABLE t1;
1071 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1072 SHOW TABLES;
1073 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1074 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1075 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1076 SHOW TABLES;
1077 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1078 SHOW CREATE TABLE t1;
1079 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1080 SHOW TABLES;
1081 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1082 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1083 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1084 SHOW TABLES;
1085 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1086 SHOW CREATE TABLE t1;
1087 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1088 SHOW TABLES;
1089 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1090 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1091 CREATE TABLE t1(c1 REAL NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1092 SHOW TABLES;
1093 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1094 SHOW CREATE TABLE t1;
1095 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1096 SHOW TABLES;
1097 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1098 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1099 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1100 SHOW TABLES;
1101 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1102 SHOW CREATE TABLE t1;
1103 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1104 SHOW TABLES;
1105 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1106 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1107 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1108 SHOW TABLES;
1109 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1110 SHOW CREATE TABLE t1;
1111 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1112 SHOW TABLES;
1113 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1114 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1115 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1116 SHOW TABLES;
1117 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1118 SHOW CREATE TABLE t1;
1119 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1120 SHOW TABLES;
1121 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1122 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1123 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1124 SHOW TABLES;
1125 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1126 SHOW CREATE TABLE t1;
1127 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1128 SHOW TABLES;
1129 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1130 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1131 CREATE TABLE t1(c1 DATE NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1132 SHOW TABLES;
1133 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1134 SHOW CREATE TABLE t1;
1135 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1136 SHOW TABLES;
1137 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1138 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1139 CREATE TABLE t1(c1 TIME NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1140 SHOW TABLES;
1141 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1142 SHOW CREATE TABLE t1;
1143 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1144 SHOW TABLES;
1145 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1146 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1147 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1148 SHOW TABLES;
1149 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1150 SHOW CREATE TABLE t1;
1151 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1152 SHOW TABLES;
1153 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1154 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1155 CREATE TABLE t1(c1 YEAR NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1156 SHOW TABLES;
1157 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1158 SHOW CREATE TABLE t1;
1159 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1160 SHOW TABLES;
1161 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1162 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1163 CREATE TABLE t1(c1 BIT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1164 SHOW TABLES;
1165 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1166 SHOW CREATE TABLE t1;
1167 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1168 SHOW TABLES;
1169 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1170 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1171 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1172 SHOW TABLES;
1173 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1174 SHOW CREATE TABLE t1;
1175 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1176 SHOW TABLES;
1177 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1178 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1179 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1180 SHOW TABLES;
1181 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1182 SHOW CREATE TABLE t1;
1183 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1184 SHOW TABLES;
1185 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1186 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1187 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1188 SHOW TABLES;
1189 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1190 SHOW CREATE TABLE t1;
1191 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1192 SHOW TABLES;
1193 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1194 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1195 CREATE TABLE t1(c1 INT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1196 SHOW TABLES;
1197 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1198 SHOW CREATE TABLE t1;
1199 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1200 SHOW TABLES;
1201 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1202 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1203 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1204 SHOW TABLES;
1205 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1206 SHOW CREATE TABLE t1;
1207 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1208 SHOW TABLES;
1209 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1210 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1211 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1212 SHOW TABLES;
1213 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1214 SHOW CREATE TABLE t1;
1215 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1216 SHOW TABLES;
1217 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1218 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1219 CREATE TABLE t1(c1 REAL NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1220 SHOW TABLES;
1221 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1222 SHOW CREATE TABLE t1;
1223 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1224 SHOW TABLES;
1225 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1226 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1227 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1228 SHOW TABLES;
1229 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1230 SHOW CREATE TABLE t1;
1231 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1232 SHOW TABLES;
1233 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1234 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1235 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1236 SHOW TABLES;
1237 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1238 SHOW CREATE TABLE t1;
1239 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1240 SHOW TABLES;
1241 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1242 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1243 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1244 SHOW TABLES;
1245 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1246 SHOW CREATE TABLE t1;
1247 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1248 SHOW TABLES;
1249 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1250 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1251 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1252 SHOW TABLES;
1253 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1254 SHOW CREATE TABLE t1;
1255 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1256 SHOW TABLES;
1257 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1258 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1259 CREATE TABLE t1(c1 DATE NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1260 SHOW TABLES;
1261 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1262 SHOW CREATE TABLE t1;
1263 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1264 SHOW TABLES;
1265 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1266 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1267 CREATE TABLE t1(c1 TIME NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1268 SHOW TABLES;
1269 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1270 SHOW CREATE TABLE t1;
1271 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1272 SHOW TABLES;
1273 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1274 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1275 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1276 SHOW TABLES;
1277 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1278 SHOW CREATE TABLE t1;
1279 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1280 SHOW TABLES;
1281 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1282 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1283 CREATE TABLE t1(c1 YEAR NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1284 SHOW TABLES;
1285 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1286 SHOW CREATE TABLE t1;
1287 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1288 SHOW TABLES;
1289 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1290 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1291 CREATE TABLE t1(c1 BIT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1292 SHOW TABLES;
1293 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1294 SHOW CREATE TABLE t1;
1295 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1296 SHOW TABLES;
1297 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1298 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1299 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1300 SHOW TABLES;
1301 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1302 SHOW CREATE TABLE t1;
1303 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1304 SHOW TABLES;
1305 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1306 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1307 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1308 SHOW TABLES;
1309 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1310 SHOW CREATE TABLE t1;
1311 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1312 SHOW TABLES;
1313 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1314 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1315 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1316 SHOW TABLES;
1317 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1318 SHOW CREATE TABLE t1;
1319 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1320 SHOW TABLES;
1321 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1322 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1323 CREATE TABLE t1(c1 INT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1324 SHOW TABLES;
1325 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1326 SHOW CREATE TABLE t1;
1327 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1328 SHOW TABLES;
1329 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1330 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1331 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1332 SHOW TABLES;
1333 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1334 SHOW CREATE TABLE t1;
1335 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1336 SHOW TABLES;
1337 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1338 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1339 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1340 SHOW TABLES;
1341 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1342 SHOW CREATE TABLE t1;
1343 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1344 SHOW TABLES;
1345 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1346 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1347 CREATE TABLE t1(c1 REAL NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1348 SHOW TABLES;
1349 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1350 SHOW CREATE TABLE t1;
1351 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1352 SHOW TABLES;
1353 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1354 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1355 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1356 SHOW TABLES;
1357 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1358 SHOW CREATE TABLE t1;
1359 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1360 SHOW TABLES;
1361 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1362 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1363 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1364 SHOW TABLES;
1365 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1366 SHOW CREATE TABLE t1;
1367 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1368 SHOW TABLES;
1369 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1370 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1371 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1372 SHOW TABLES;
1373 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1374 SHOW CREATE TABLE t1;
1375 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1376 SHOW TABLES;
1377 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1378 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1379 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1380 SHOW TABLES;
1381 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1382 SHOW CREATE TABLE t1;
1383 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1384 SHOW TABLES;
1385 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1386 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1387 CREATE TABLE t1(c1 DATE NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1388 SHOW TABLES;
1389 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1390 SHOW CREATE TABLE t1;
1391 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1392 SHOW TABLES;
1393 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1394 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1395 CREATE TABLE t1(c1 TIME NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1396 SHOW TABLES;
1397 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1398 SHOW CREATE TABLE t1;
1399 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1400 SHOW TABLES;
1401 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1402 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1403 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1404 SHOW TABLES;
1405 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1406 SHOW CREATE TABLE t1;
1407 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1408 SHOW TABLES;
1409 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1410 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1411 CREATE TABLE t1(c1 YEAR NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1412 SHOW TABLES;
1413 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1414 SHOW CREATE TABLE t1;
1415 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1416 SHOW TABLES;
1417 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1418 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1419 CREATE TABLE t1(c1 BIT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1420 SHOW TABLES;
1421 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1422 SHOW CREATE TABLE t1;
1423 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1424 SHOW TABLES;
1425 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1426 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1427 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1428 SHOW TABLES;
1429 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1430 SHOW CREATE TABLE t1;
1431 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1432 SHOW TABLES;
1433 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1434 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1435 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1436 SHOW TABLES;
1437 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1438 SHOW CREATE TABLE t1;
1439 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1440 SHOW TABLES;
1441 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1442 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1443 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1444 SHOW TABLES;
1445 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1446 SHOW CREATE TABLE t1;
1447 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1448 SHOW TABLES;
1449 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1450 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1451 CREATE TABLE t1(c1 INT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1452 SHOW TABLES;
1453 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1454 SHOW CREATE TABLE t1;
1455 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1456 SHOW TABLES;
1457 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1458 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1459 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1460 SHOW TABLES;
1461 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1462 SHOW CREATE TABLE t1;
1463 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1464 SHOW TABLES;
1465 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1466 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1467 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1468 SHOW TABLES;
1469 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1470 SHOW CREATE TABLE t1;
1471 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1472 SHOW TABLES;
1473 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1474 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1475 CREATE TABLE t1(c1 REAL NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1476 SHOW TABLES;
1477 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1478 SHOW CREATE TABLE t1;
1479 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1480 SHOW TABLES;
1481 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1482 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1483 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1484 SHOW TABLES;
1485 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1486 SHOW CREATE TABLE t1;
1487 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1488 SHOW TABLES;
1489 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1490 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1491 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1492 SHOW TABLES;
1493 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1494 SHOW CREATE TABLE t1;
1495 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1496 SHOW TABLES;
1497 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1498 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1499 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1500 SHOW TABLES;
1501 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1502 SHOW CREATE TABLE t1;
1503 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1504 SHOW TABLES;
1505 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1506 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1507 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1508 SHOW TABLES;
1509 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1510 SHOW CREATE TABLE t1;
1511 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1512 SHOW TABLES;
1513 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1514 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1515 CREATE TABLE t1(c1 DATE NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1516 SHOW TABLES;
1517 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1518 SHOW CREATE TABLE t1;
1519 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1520 SHOW TABLES;
1521 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1522 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1523 CREATE TABLE t1(c1 TIME NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1524 SHOW TABLES;
1525 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1526 SHOW CREATE TABLE t1;
1527 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1528 SHOW TABLES;
1529 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1530 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1531 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1532 SHOW TABLES;
1533 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1534 SHOW CREATE TABLE t1;
1535 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1536 SHOW TABLES;
1537 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1538 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1539 CREATE TABLE t1(c1 YEAR NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1540 SHOW TABLES;
1541 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1542 SHOW CREATE TABLE t1;
1543 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1544 SHOW TABLES;
1545 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1546 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1547 CREATE TABLE t1(c1 BIT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1548 SHOW TABLES;
1549 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1550 SHOW CREATE TABLE t1;
1551 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1552 SHOW TABLES;
1553 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1554 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1555 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1556 SHOW TABLES;
1557 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1558 SHOW CREATE TABLE t1;
1559 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1560 SHOW TABLES;
1561 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1562 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1563 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1564 SHOW TABLES;
1565 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1566 SHOW CREATE TABLE t1;
1567 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1568 SHOW TABLES;
1569 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1570 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1571 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1572 SHOW TABLES;
1573 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1574 SHOW CREATE TABLE t1;
1575 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1576 SHOW TABLES;
1577 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1578 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1579 CREATE TABLE t1(c1 INT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1580 SHOW TABLES;
1581 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1582 SHOW CREATE TABLE t1;
1583 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1584 SHOW TABLES;
1585 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1586 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1587 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1588 SHOW TABLES;
1589 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1590 SHOW CREATE TABLE t1;
1591 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1592 SHOW TABLES;
1593 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1594 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1595 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1596 SHOW TABLES;
1597 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1598 SHOW CREATE TABLE t1;
1599 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1600 SHOW TABLES;
1601 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1602 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1603 CREATE TABLE t1(c1 REAL NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1604 SHOW TABLES;
1605 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1606 SHOW CREATE TABLE t1;
1607 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1608 SHOW TABLES;
1609 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1610 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1611 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1612 SHOW TABLES;
1613 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1614 SHOW CREATE TABLE t1;
1615 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1616 SHOW TABLES;
1617 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1618 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1619 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1620 SHOW TABLES;
1621 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1622 SHOW CREATE TABLE t1;
1623 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1624 SHOW TABLES;
1625 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1626 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1627 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1628 SHOW TABLES;
1629 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1630 SHOW CREATE TABLE t1;
1631 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1632 SHOW TABLES;
1633 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1634 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1635 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1636 SHOW TABLES;
1637 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1638 SHOW CREATE TABLE t1;
1639 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1640 SHOW TABLES;
1641 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1642 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1643 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1644 SHOW TABLES;
1645 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1646 SHOW CREATE TABLE t1;
1647 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1648 SHOW TABLES;
1649 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1650 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1651 CREATE TABLE t1(c1 TIME NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1652 SHOW TABLES;
1653 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1654 SHOW CREATE TABLE t1;
1655 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1656 SHOW TABLES;
1657 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1658 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1659 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1660 SHOW TABLES;
1661 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1662 SHOW CREATE TABLE t1;
1663 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1664 SHOW TABLES;
1665 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1666 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1667 CREATE TABLE t1(c1 YEAR NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1668 SHOW TABLES;
1669 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1670 SHOW CREATE TABLE t1;
1671 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1672 SHOW TABLES;
1673 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1674 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1675 CREATE TABLE t1(c1 BIT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1676 SHOW TABLES;
1677 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1678 SHOW CREATE TABLE t1;
1679 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1680 SHOW TABLES;
1681 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1682 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1683 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1684 SHOW TABLES;
1685 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1686 SHOW CREATE TABLE t1;
1687 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1688 SHOW TABLES;
1689 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1690 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1691 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1692 SHOW TABLES;
1693 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1694 SHOW CREATE TABLE t1;
1695 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1696 SHOW TABLES;
1697 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1698 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1699 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1700 SHOW TABLES;
1701 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1702 SHOW CREATE TABLE t1;
1703 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1704 SHOW TABLES;
1705 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1706 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1707 CREATE TABLE t1(c1 INT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1708 SHOW TABLES;
1709 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1710 SHOW CREATE TABLE t1;
1711 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1712 SHOW TABLES;
1713 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1714 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1715 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1716 SHOW TABLES;
1717 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1718 SHOW CREATE TABLE t1;
1719 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1720 SHOW TABLES;
1721 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1722 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1723 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1724 SHOW TABLES;
1725 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1726 SHOW CREATE TABLE t1;
1727 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1728 SHOW TABLES;
1729 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1730 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1731 CREATE TABLE t1(c1 REAL NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1732 SHOW TABLES;
1733 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1734 SHOW CREATE TABLE t1;
1735 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1736 SHOW TABLES;
1737 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1738 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1739 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1740 SHOW TABLES;
1741 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1742 SHOW CREATE TABLE t1;
1743 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1744 SHOW TABLES;
1745 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1746 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1747 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1748 SHOW TABLES;
1749 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1750 SHOW CREATE TABLE t1;
1751 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1752 SHOW TABLES;
1753 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1754 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1755 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1756 SHOW TABLES;
1757 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1758 SHOW CREATE TABLE t1;
1759 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1760 SHOW TABLES;
1761 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1762 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1763 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1764 SHOW TABLES;
1765 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1766 SHOW CREATE TABLE t1;
1767 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1768 SHOW TABLES;
1769 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1770 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1771 CREATE TABLE t1(c1 DATE NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1772 SHOW TABLES;
1773 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1774 SHOW CREATE TABLE t1;
1775 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1776 SHOW TABLES;
1777 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1778 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1779 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1780 SHOW TABLES;
1781 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1782 SHOW CREATE TABLE t1;
1783 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1784 SHOW TABLES;
1785 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1786 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1787 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1788 SHOW TABLES;
1789 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1790 SHOW CREATE TABLE t1;
1791 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1792 SHOW TABLES;
1793 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1794 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1795 CREATE TABLE t1(c1 YEAR NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1796 SHOW TABLES;
1797 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1798 SHOW CREATE TABLE t1;
1799 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1800 SHOW TABLES;
1801 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1802 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1803 CREATE TABLE t1(c1 BIT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1804 SHOW TABLES;
1805 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1806 SHOW CREATE TABLE t1;
1807 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1808 SHOW TABLES;
1809 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1810 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1811 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1812 SHOW TABLES;
1813 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1814 SHOW CREATE TABLE t1;
1815 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1816 SHOW TABLES;
1817 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1818 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1819 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1820 SHOW TABLES;
1821 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1822 SHOW CREATE TABLE t1;
1823 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1824 SHOW TABLES;
1825 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1826 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1827 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1828 SHOW TABLES;
1829 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1830 SHOW CREATE TABLE t1;
1831 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1832 SHOW TABLES;
1833 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1834 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1835 CREATE TABLE t1(c1 INT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1836 SHOW TABLES;
1837 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1838 SHOW CREATE TABLE t1;
1839 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1840 SHOW TABLES;
1841 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1842 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1843 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1844 SHOW TABLES;
1845 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1846 SHOW CREATE TABLE t1;
1847 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1848 SHOW TABLES;
1849 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1850 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1851 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1852 SHOW TABLES;
1853 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1854 SHOW CREATE TABLE t1;
1855 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1856 SHOW TABLES;
1857 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1858 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1859 CREATE TABLE t1(c1 REAL NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1860 SHOW TABLES;
1861 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1862 SHOW CREATE TABLE t1;
1863 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1864 SHOW TABLES;
1865 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1866 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1867 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1868 SHOW TABLES;
1869 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1870 SHOW CREATE TABLE t1;
1871 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1872 SHOW TABLES;
1873 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1874 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1875 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1876 SHOW TABLES;
1877 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1878 SHOW CREATE TABLE t1;
1879 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1880 SHOW TABLES;
1881 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1882 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1883 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1884 SHOW TABLES;
1885 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1886 SHOW CREATE TABLE t1;
1887 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1888 SHOW TABLES;
1889 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1890 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1891 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1892 SHOW TABLES;
1893 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1894 SHOW CREATE TABLE t1;
1895 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1896 SHOW TABLES;
1897 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1898 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1899 CREATE TABLE t1(c1 DATE NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1900 SHOW TABLES;
1901 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1902 SHOW CREATE TABLE t1;
1903 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1904 SHOW TABLES;
1905 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1906 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1907 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1908 SHOW TABLES;
1909 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1910 SHOW CREATE TABLE t1;
1911 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1912 SHOW TABLES;
1913 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1914 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1915 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1916 SHOW TABLES;
1917 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1918 SHOW CREATE TABLE t1;
1919 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1920 SHOW TABLES;
1921 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1922 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1923 CREATE TABLE t1(c1 YEAR NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1924 SHOW TABLES;
1925 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1926 SHOW CREATE TABLE t1;
1927 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1928 SHOW TABLES;
1929 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1930 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1931 CREATE TABLE t1(c1 BIT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1932 SHOW TABLES;
1933 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1934 SHOW CREATE TABLE t1;
1935 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1936 SHOW TABLES;
1937 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1938 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1939 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1940 SHOW TABLES;
1941 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1942 SHOW CREATE TABLE t1;
1943 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1944 SHOW TABLES;
1945 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1946 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1947 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1948 SHOW TABLES;
1949 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1950 SHOW CREATE TABLE t1;
1951 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1952 SHOW TABLES;
1953 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1954 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1955 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1956 SHOW TABLES;
1957 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1958 SHOW CREATE TABLE t1;
1959 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1960 SHOW TABLES;
1961 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1962 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1963 CREATE TABLE t1(c1 INT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1964 SHOW TABLES;
1965 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1966 SHOW CREATE TABLE t1;
1967 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1968 SHOW TABLES;
1969 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1970 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1971 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1972 SHOW TABLES;
1973 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1974 SHOW CREATE TABLE t1;
1975 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1976 SHOW TABLES;
1977 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1978 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1979 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1980 SHOW TABLES;
1981 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1982 SHOW CREATE TABLE t1;
1983 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1984 SHOW TABLES;
1985 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1986 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1987 CREATE TABLE t1(c1 REAL NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1988 SHOW TABLES;
1989 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1990 SHOW CREATE TABLE t1;
1991 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1992 SHOW TABLES;
1993 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1994 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
1995 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1996 SHOW TABLES;
1997 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
1998 SHOW CREATE TABLE t1;
1999 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2000 SHOW TABLES;
2001 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2002 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2003 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2004 SHOW TABLES;
2005 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2006 SHOW CREATE TABLE t1;
2007 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2008 SHOW TABLES;
2009 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2010 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2011 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2012 SHOW TABLES;
2013 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2014 SHOW CREATE TABLE t1;
2015 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2016 SHOW TABLES;
2017 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2018 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2019 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2020 SHOW TABLES;
2021 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2022 SHOW CREATE TABLE t1;
2023 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2024 SHOW TABLES;
2025 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2026 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2027 CREATE TABLE t1(c1 DATE NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2028 SHOW TABLES;
2029 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2030 SHOW CREATE TABLE t1;
2031 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2032 SHOW TABLES;
2033 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2034 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2035 CREATE TABLE t1(c1 TIME NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2036 SHOW TABLES;
2037 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2038 SHOW CREATE TABLE t1;
2039 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2040 SHOW TABLES;
2041 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2042 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2043 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2044 SHOW TABLES;
2045 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2046 SHOW CREATE TABLE t1;
2047 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2048 SHOW TABLES;
2049 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2050 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2051 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2052 SHOW TABLES;
2053 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2054 SHOW CREATE TABLE t1;
2055 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2056 SHOW TABLES;
2057 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
2058 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
2059 SET sql_mode=default;