← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/ta_rename.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mfrom: (1.1.5)
  • Revision ID: package-import@ubuntu.com-20120222223355-or06x1euyk8n0ldi
Tags: 5.1.61-0ubuntu0.10.04.1
https://launchpad.net/bugs/937869
* SECURITY UPDATE: Update to 5.1.61 to fix multiple security issues
  (LP: #937869)
  - http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html
  - CVE-2011-2262
  - CVE-2012-0075
  - CVE-2012-0112
  - CVE-2012-0113
  - CVE-2012-0114
  - CVE-2012-0115
  - CVE-2012-0116
  - CVE-2012-0117
  - CVE-2012-0118
  - CVE-2012-0119
  - CVE-2012-0120
  - CVE-2012-0484
  - CVE-2012-0485
  - CVE-2012-0486
  - CVE-2012-0487
  - CVE-2012-0488
  - CVE-2012-0489
  - CVE-2012-0490
  - CVE-2012-0491
  - CVE-2012-0492
  - CVE-2012-0493
  - CVE-2012-0494
  - CVE-2012-0495
  - CVE-2012-0496
* Dropped patches unnecessary with 5.1.61:
  - debian/patches/90_mysql_safer_strmov.dpatch
  - debian/patches/51_ssl_test_certs.dpatch
  - debian/patches/52_CVE-2009-4030.dpatch
  - debian/patches/53_CVE-2009-4484.dpatch
  - debian/patches/54_CVE-2008-7247.dpatch
  - debian/patches/55_CVE-2010-1621.dpatch
  - debian/patches/56_CVE-2010-1850.dpatch
  - debian/patches/57_CVE-2010-1849.dpatch
  - debian/patches/58_CVE-2010-1848.dpatch
  - debian/patches/59_CVE-2010-1626.dpatch
  - debian/patches/60_CVE-2010-2008.dpatch
  - debian/patches/60_CVE-2010-3677.dpatch
  - debian/patches/60_CVE-2010-3678.dpatch
  - debian/patches/60_CVE-2010-3679.dpatch
  - debian/patches/60_CVE-2010-3680.dpatch
  - debian/patches/60_CVE-2010-3681.dpatch
  - debian/patches/60_CVE-2010-3682.dpatch
  - debian/patches/60_CVE-2010-3683.dpatch
  - debian/patches/60_CVE-2010-3833.dpatch
  - debian/patches/60_CVE-2010-3834.dpatch
  - debian/patches/60_CVE-2010-3835.dpatch
  - debian/patches/60_CVE-2010-3836.dpatch
  - debian/patches/60_CVE-2010-3837.dpatch
  - debian/patches/60_CVE-2010-3838.dpatch
  - debian/patches/60_CVE-2010-3839.dpatch
  - debian/patches/60_CVE-2010-3840.dpatch
  - debian/patches/61_disable_longfilename_test.dpatch
  - debian/patches/62_alter_table_fix.dpatch
  - debian/patches/63_cherrypick-upstream-49479.dpatch
  - debian/patches/10_readline_build_fix.dpatch
* debian/mysql-client-5.1.docs: removed EXCEPTIONS-CLIENT file
* debian/mysql-server-5.1.docs,debian/libmysqlclient16.docs,
  debian/libmysqlclient-dev.docs: removed, no longer necessary.

Show diffs side-by-side

added added

removed removed

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