Debian Codegraph @

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

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