[tomato.git] / release / src / router / mysql / mysql-test / suite / engines / funcs / t / tc_structure_create_like_string.test
| blob | 551a87f12ab721f89c0db6e2eabc5825afbff2ff |
1 --disable_warnings
2 DROP TABLE IF EXISTS src,dest;
3 --enable_warnings
4 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 CHAR(10) NULL, PRIMARY KEY(c1));
5 CREATE TABLE dst LIKE src;
6 SHOW TABLES;
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 DROP TABLE src;
11 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARCHAR(10) NULL, PRIMARY KEY(c1));
12 CREATE TABLE dst LIKE src;
13 SHOW TABLES;
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;
17 DROP TABLE src;
18 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BINARY(10) NULL, PRIMARY KEY(c1));
19 CREATE TABLE dst LIKE src;
20 SHOW TABLES;
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;
24 DROP TABLE src;
25 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARBINARY(10) NULL, PRIMARY KEY(c1));
26 CREATE TABLE dst LIKE src;
27 SHOW TABLES;
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;
31 DROP TABLE src;