Debian Codegraph @

mysql-test/suite/engines/funcs/t/tc_column_zerofill.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 t4;
7 --enable_warnings
8 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
9 SHOW TABLES;
10 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
11 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
12 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
13 SHOW TABLES;
14 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
15 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
16 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
17 SHOW TABLES;
18 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
19 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
20 CREATE TABLE t4(c1 INT ZEROFILL NULL);
21 SHOW TABLES;
22 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
23 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
24 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
25 SHOW TABLES;
26 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
27 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
28 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
29 SHOW TABLES;
30 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
31 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
32 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
33 SHOW TABLES;
34 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
35 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
36 CREATE TABLE t4(c1 DEC ZEROFILL NULL);
37 SHOW TABLES;
38 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
39 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
40 CREATE TABLE t4(c1 FIXED ZEROFILL NULL);
41 SHOW TABLES;
42 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
43 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
44 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
45 SHOW TABLES;
46 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
47 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
48 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
49 SHOW TABLES;
50 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
51 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
52 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
53 SHOW TABLES;
54 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
55 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
56 CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NULL);
57 SHOW TABLES;
58 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
59 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
60 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
61 SHOW TABLES;
62 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
63 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
64 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
65 SHOW TABLES;
66 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
67 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
68 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
69 SHOW TABLES;
70 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
71 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
72 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
73 SHOW TABLES;
74 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
75 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
76 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
77 SHOW TABLES;
78 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
79 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
80 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
81 SHOW TABLES;
82 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
83 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
84 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
85 SHOW TABLES;
86 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
87 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
88 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
89 SHOW TABLES;
90 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
91 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
92 CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NULL);
93 SHOW TABLES;
94 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
95 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
96 CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NULL);
97 SHOW TABLES;
98 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
99 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
100 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
101 SHOW TABLES;
102 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
103 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
104 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
105 SHOW TABLES;
106 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
107 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
108 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
109 SHOW TABLES;
110 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
111 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
112 CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NULL);
113 SHOW TABLES;
114 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
115 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
116 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
117 SHOW TABLES;
118 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
119 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
120 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
121 SHOW TABLES;
122 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
123 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
124 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
125 SHOW TABLES;
126 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
127 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
128 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
129 SHOW TABLES;
130 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
131 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
132 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
133 SHOW TABLES;
134 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
135 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
136 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
137 SHOW TABLES;
138 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
139 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
140 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
141 SHOW TABLES;
142 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
143 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
144 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
145 SHOW TABLES;
146 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
147 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
148 CREATE TABLE t4(c1 DEC ZEROFILL NOT NULL);
149 SHOW TABLES;
150 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
151 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
152 CREATE TABLE t4(c1 FIXED ZEROFILL NOT NULL);
153 SHOW TABLES;
154 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
155 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
156 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
157 SHOW TABLES;
158 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
159 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
160 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
161 SHOW TABLES;
162 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
163 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
164 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
165 SHOW TABLES;
166 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
167 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
168 CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NOT NULL);
169 SHOW TABLES;
170 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
171 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
172 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
173 SHOW TABLES;
174 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
175 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
176 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
177 SHOW TABLES;
178 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
179 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
180 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
181 SHOW TABLES;
182 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
183 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
184 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
185 SHOW TABLES;
186 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
187 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
188 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
189 SHOW TABLES;
190 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
191 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
192 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
193 SHOW TABLES;
194 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
195 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
196 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
197 SHOW TABLES;
198 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
199 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
200 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
201 SHOW TABLES;
202 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
203 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
204 CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NOT NULL);
205 SHOW TABLES;
206 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
207 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
208 CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NOT NULL);
209 SHOW TABLES;
210 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
211 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
212 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
213 SHOW TABLES;
214 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
215 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
216 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
217 SHOW TABLES;
218 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
219 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
220 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
221 SHOW TABLES;
222 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
223 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
224 CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NOT NULL);
225 SHOW TABLES;
226 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
227 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
228 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
229 SHOW TABLES;
230 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
231 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;