Debian Codegraph @

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

raw
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 (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM 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" "" " PAGE_CHECKSUM=1" ""
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;
11 SHOW TABLES;
12 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
13 DROP TABLE src;
14 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARCHAR(10) NULL, PRIMARY KEY(c1));
15 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
16 SHOW TABLES;
17 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
18 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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;
21 SHOW TABLES;
22 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
23 DROP TABLE src;
24 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BINARY(10) NULL, PRIMARY KEY(c1));
25 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
26 SHOW TABLES;
27 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
28 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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;
31 SHOW TABLES;
32 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
33 DROP TABLE src;
34 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 VARBINARY(10) NULL, PRIMARY KEY(c1));
35 CREATE TABLE dst (c1 INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(c1)) SELECT c1,c2 FROM src;
36 SHOW TABLES;
37 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
38 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
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;
41 SHOW TABLES;
42 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
43 DROP TABLE src;
44