2 DROP TABLE IF EXISTS src,dest;
4 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIT NULL, PRIMARY KEY(c1));
5 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
7 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
8 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
9 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
10 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
12 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
14 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYINT NULL, PRIMARY KEY(c1));
15 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
17 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
18 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
19 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
20 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
22 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
24 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 SMALLINT NULL, PRIMARY KEY(c1));
25 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
27 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
28 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
29 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
30 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
32 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
34 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMINT NULL, PRIMARY KEY(c1));
35 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
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 dst; DROP TABLE dst; SHOW TABLES;
40 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
42 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
44 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INT NULL, PRIMARY KEY(c1));
45 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
47 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
48 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
49 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
50 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
52 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
54 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INTEGER NULL, PRIMARY KEY(c1));
55 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
57 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
58 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
59 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
60 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
62 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
64 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIGINT NULL, PRIMARY KEY(c1));
65 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
67 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
68 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
69 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
70 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
72 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
74 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 REAL NULL, PRIMARY KEY(c1));
75 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
77 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
78 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
79 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
80 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
82 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
84 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DOUBLE NULL, PRIMARY KEY(c1));
85 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
87 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
88 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
89 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
90 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
92 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
94 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 FLOAT NULL, PRIMARY KEY(c1));
95 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
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 dst; DROP TABLE dst; SHOW TABLES;
100 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
102 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
104 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DECIMAL NULL, PRIMARY KEY(c1));
105 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
107 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
108 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
109 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
110 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
112 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
114 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 NUMERIC NULL, PRIMARY KEY(c1));
115 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
117 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
118 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
119 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
120 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
122 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
124 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATE NULL, PRIMARY KEY(c1));
125 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
127 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
128 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
129 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
130 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
132 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
134 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIME NULL, PRIMARY KEY(c1));
135 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
137 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
138 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
139 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
140 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
142 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
144 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATETIME NULL, PRIMARY KEY(c1));
145 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
147 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
148 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
149 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
150 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
152 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
154 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIMESTAMP NULL, PRIMARY KEY(c1));
155 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
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 dst; DROP TABLE dst; SHOW TABLES;
160 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
162 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
164 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 YEAR NULL, PRIMARY KEY(c1));
165 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
167 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
168 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
169 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
170 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
172 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
174 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYBLOB NULL, PRIMARY KEY(c1));
175 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
177 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
178 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
179 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
180 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
182 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
184 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BLOB NULL, PRIMARY KEY(c1));
185 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
187 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
188 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
189 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
190 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
192 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
194 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMBLOB NULL, PRIMARY KEY(c1));
195 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
197 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
198 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
199 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
200 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
202 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
204 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGBLOB NULL, PRIMARY KEY(c1));
205 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
207 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
208 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
209 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
210 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
212 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
214 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYTEXT NULL, PRIMARY KEY(c1));
215 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
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 dst; DROP TABLE dst; SHOW TABLES;
220 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
222 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
224 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TEXT NULL, PRIMARY KEY(c1));
225 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
227 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
228 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
229 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
230 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
232 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
234 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMTEXT NULL, PRIMARY KEY(c1));
235 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
237 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
238 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
239 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
240 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
242 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
244 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGTEXT NULL, PRIMARY KEY(c1));
245 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
247 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
248 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
249 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
250 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1))ENGINE=MyISAM SELECT c1,c2 FROM src;
252 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;