Debian Codegraph @

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

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