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 LIKE 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;
11 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYINT NULL, PRIMARY KEY(c1));
12 CREATE TABLE dst LIKE src;
14 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
15 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
16 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
18 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 SMALLINT NULL, PRIMARY KEY(c1));
19 CREATE TABLE dst LIKE src;
21 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
22 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
23 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
25 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMINT NULL, PRIMARY KEY(c1));
26 CREATE TABLE dst LIKE src;
28 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
29 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
30 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
32 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INT NULL, PRIMARY KEY(c1));
33 CREATE TABLE dst LIKE src;
35 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
36 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
37 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
39 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INTEGER NULL, PRIMARY KEY(c1));
40 CREATE TABLE dst LIKE src;
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 dst; DROP TABLE dst; SHOW TABLES;
46 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIGINT NULL, PRIMARY KEY(c1));
47 CREATE TABLE dst LIKE src;
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 dst; DROP TABLE dst; SHOW TABLES;
53 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 REAL NULL, PRIMARY KEY(c1));
54 CREATE TABLE dst LIKE src;
56 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
57 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
58 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
60 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DOUBLE NULL, PRIMARY KEY(c1));
61 CREATE TABLE dst LIKE src;
63 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
64 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
65 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
67 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 FLOAT NULL, PRIMARY KEY(c1));
68 CREATE TABLE dst LIKE src;
70 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
71 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
72 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
74 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DECIMAL NULL, PRIMARY KEY(c1));
75 CREATE TABLE dst LIKE 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;
81 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 NUMERIC NULL, PRIMARY KEY(c1));
82 CREATE TABLE dst LIKE src;
84 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
85 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
86 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
88 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATE NULL, PRIMARY KEY(c1));
89 CREATE TABLE dst LIKE src;
91 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
92 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
93 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
95 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIME NULL, PRIMARY KEY(c1));
96 CREATE TABLE dst LIKE src;
98 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
99 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
100 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
102 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATETIME NULL, PRIMARY KEY(c1));
103 CREATE TABLE dst LIKE src;
105 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
106 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
107 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
109 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIMESTAMP NULL, PRIMARY KEY(c1));
110 CREATE TABLE dst LIKE src;
112 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
113 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
114 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
116 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 YEAR NULL, PRIMARY KEY(c1));
117 CREATE TABLE dst LIKE src;
119 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
120 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
121 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
123 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYBLOB NULL, PRIMARY KEY(c1));
124 CREATE TABLE dst LIKE src;
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 dst; DROP TABLE dst; SHOW TABLES;
130 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BLOB NULL, PRIMARY KEY(c1));
131 CREATE TABLE dst LIKE src;
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 dst; DROP TABLE dst; SHOW TABLES;
137 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMBLOB NULL, PRIMARY KEY(c1));
138 CREATE TABLE dst LIKE src;
140 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
141 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
142 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
144 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGBLOB NULL, PRIMARY KEY(c1));
145 CREATE TABLE dst LIKE 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;
151 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYTEXT NULL, PRIMARY KEY(c1));
152 CREATE TABLE dst LIKE src;
154 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
155 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
156 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
158 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TEXT NULL, PRIMARY KEY(c1));
159 CREATE TABLE dst LIKE src;
161 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
162 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
163 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
165 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMTEXT NULL, PRIMARY KEY(c1));
166 CREATE TABLE dst LIKE src;
168 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
169 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
170 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
172 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGTEXT NULL, PRIMARY KEY(c1));
173 CREATE TABLE dst LIKE src;
175 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
176 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
177 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;