Debian Codegraph @

mysql-test/suite/engines/funcs/t/tc_structure_create_like.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 src,dest;
7 --enable_warnings
8 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIT NULL, PRIMARY KEY(c1));
9 CREATE TABLE dst LIKE src;
10 SHOW TABLES;
11 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
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 TINYINT NULL, PRIMARY KEY(c1));
15 CREATE TABLE dst LIKE src;
16 SHOW TABLES;
17 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
18 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
19 DROP TABLE src;
20 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 SMALLINT NULL, PRIMARY KEY(c1));
21 CREATE TABLE dst LIKE src;
22 SHOW TABLES;
23 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
24 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
25 DROP TABLE src;
26 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMINT NULL, PRIMARY KEY(c1));
27 CREATE TABLE dst LIKE src;
28 SHOW TABLES;
29 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
30 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
31 DROP TABLE src;
32 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INT NULL, PRIMARY KEY(c1));
33 CREATE TABLE dst LIKE src;
34 SHOW TABLES;
35 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
36 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
37 DROP TABLE src;
38 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 INTEGER NULL, PRIMARY KEY(c1));
39 CREATE TABLE dst LIKE src;
40 SHOW TABLES;
41 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
42 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
43 DROP TABLE src;
44 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BIGINT NULL, PRIMARY KEY(c1));
45 CREATE TABLE dst LIKE src;
46 SHOW TABLES;
47 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
49 DROP TABLE src;
50 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 REAL NULL, PRIMARY KEY(c1));
51 CREATE TABLE dst LIKE src;
52 SHOW TABLES;
53 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
54 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
55 DROP TABLE src;
56 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DOUBLE NULL, PRIMARY KEY(c1));
57 CREATE TABLE dst LIKE src;
58 SHOW TABLES;
59 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
60 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
61 DROP TABLE src;
62 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 FLOAT NULL, PRIMARY KEY(c1));
63 CREATE TABLE dst LIKE src;
64 SHOW TABLES;
65 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
66 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
67 DROP TABLE src;
68 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DECIMAL NULL, PRIMARY KEY(c1));
69 CREATE TABLE dst LIKE src;
70 SHOW TABLES;
71 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
72 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
73 DROP TABLE src;
74 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 NUMERIC NULL, PRIMARY KEY(c1));
75 CREATE TABLE dst LIKE src;
76 SHOW TABLES;
77 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
78 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
79 DROP TABLE src;
80 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATE NULL, PRIMARY KEY(c1));
81 CREATE TABLE dst LIKE src;
82 SHOW TABLES;
83 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
84 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
85 DROP TABLE src;
86 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIME NULL, PRIMARY KEY(c1));
87 CREATE TABLE dst LIKE src;
88 SHOW TABLES;
89 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
90 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
91 DROP TABLE src;
92 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 DATETIME NULL, PRIMARY KEY(c1));
93 CREATE TABLE dst LIKE src;
94 SHOW TABLES;
95 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
96 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
97 DROP TABLE src;
98 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TIMESTAMP NULL, PRIMARY KEY(c1));
99 CREATE TABLE dst LIKE src;
100 SHOW TABLES;
101 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
102 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
103 DROP TABLE src;
104 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 YEAR NULL, PRIMARY KEY(c1));
105 CREATE TABLE dst LIKE src;
106 SHOW TABLES;
107 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
108 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
109 DROP TABLE src;
110 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYBLOB NULL, PRIMARY KEY(c1));
111 CREATE TABLE dst LIKE src;
112 SHOW TABLES;
113 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
114 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
115 DROP TABLE src;
116 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 BLOB NULL, PRIMARY KEY(c1));
117 CREATE TABLE dst LIKE src;
118 SHOW TABLES;
119 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
120 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
121 DROP TABLE src;
122 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMBLOB NULL, PRIMARY KEY(c1));
123 CREATE TABLE dst LIKE src;
124 SHOW TABLES;
125 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
126 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
127 DROP TABLE src;
128 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGBLOB NULL, PRIMARY KEY(c1));
129 CREATE TABLE dst LIKE src;
130 SHOW TABLES;
131 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
132 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
133 DROP TABLE src;
134 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TINYTEXT NULL, PRIMARY KEY(c1));
135 CREATE TABLE dst LIKE src;
136 SHOW TABLES;
137 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
138 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
139 DROP TABLE src;
140 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 TEXT NULL, PRIMARY KEY(c1));
141 CREATE TABLE dst LIKE src;
142 SHOW TABLES;
143 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
144 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
145 DROP TABLE src;
146 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 MEDIUMTEXT NULL, PRIMARY KEY(c1));
147 CREATE TABLE dst LIKE src;
148 SHOW TABLES;
149 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
150 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
151 DROP TABLE src;
152 CREATE TABLE src (c1 INT NOT NULL AUTO_INCREMENT, c2 LONGTEXT NULL, PRIMARY KEY(c1));
153 CREATE TABLE dst LIKE src;
154 SHOW TABLES;
155 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
156 SHOW CREATE TABLE dst; DROP TABLE dst; SHOW TABLES;
157 DROP TABLE src;