Debian Codegraph @

mysql-test/suite/funcs_1/r/is_columns_myisam.result

raw
1 SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2 DROP DATABASE IF EXISTS test1;
3 CREATE DATABASE test1 charset latin1;
4 USE test;
5 drop table if exists tb1 ;
6 create table tb1 (
7 f1 char,
8 f2 char binary,
9 f3 char ascii,
10 f4 tinytext,
11 f5 text,
12 f6 mediumtext,
13 f7 longtext,
14 f8 tinyblob,
15 f9 blob,
16 f10 mediumblob,
17 f11 longblob,
18 f12 binary,
19 f13 tinyint,
20 f14 tinyint unsigned,
21 f15 tinyint zerofill,
22 f16 tinyint unsigned zerofill,
23 f17 smallint,
24 f18 smallint unsigned,
25 f19 smallint zerofill,
26 f20 smallint unsigned zerofill,
27 f21 mediumint,
28 f22 mediumint unsigned,
29 f23 mediumint zerofill,
30 f24 mediumint unsigned zerofill,
31 f25 int,
32 f26 int unsigned,
33 f27 int zerofill,
34 f28 int unsigned zerofill,
35 f29 bigint,
36 f30 bigint unsigned,
37 f31 bigint zerofill,
38 f32 bigint unsigned zerofill,
39 f33 decimal not null DEFAULT 9.9,
40 f34 decimal unsigned not null DEFAULT 9.9,
41 f35 decimal zerofill not null DEFAULT 9.9,
42 f36 decimal unsigned zerofill not null DEFAULT 9.9,
43 f37 decimal (0) not null DEFAULT 9.9,
44 f38 decimal (64) not null DEFAULT 9.9,
45 f39 decimal (0) unsigned not null DEFAULT 9.9,
46 f40 decimal (64) unsigned not null DEFAULT 9.9,
47 f41 decimal (0) zerofill not null DEFAULT 9.9,
48 f42 decimal (64) zerofill not null DEFAULT 9.9,
49 f43 decimal (0) unsigned zerofill not null DEFAULT 9.9,
50 f44 decimal (64) unsigned zerofill not null DEFAULT 9.9,
51 f45 decimal (0,0) not null DEFAULT 9.9,
52 f46 decimal (63,30) not null DEFAULT 9.9,
53 f47 decimal (0,0) unsigned not null DEFAULT 9.9,
54 f48 decimal (63,30) unsigned not null DEFAULT 9.9,
55 f49 decimal (0,0) zerofill not null DEFAULT 9.9,
56 f50 decimal (63,30) zerofill not null DEFAULT 9.9,
57 f51 decimal (0,0) unsigned zerofill not null DEFAULT 9.9,
58 f52 decimal (63,30) unsigned zerofill not null DEFAULT 9.9,
59 f53 numeric not null DEFAULT 99,
60 f54 numeric unsigned not null DEFAULT 99,
61 f55 numeric zerofill not null DEFAULT 99,
62 f56 numeric unsigned zerofill not null DEFAULT 99,
63 f57 numeric (0) not null DEFAULT 99,
64 f58 numeric (64) not null DEFAULT 99
65 ) charset latin1 engine = myisam;
66 Warnings:
67 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
68 Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead
69 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
70 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
71 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
72 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
73 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
74 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
75 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
76 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
77 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
78 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
79 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
80 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
81 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
82 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
83 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
84 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
85 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
86 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
87 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
88 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
89 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
90 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
91 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
92 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
93 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
94 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
95 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
96 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
97 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
98 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
99 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
100 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
101 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
102 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
103 Note 1265 Data truncated for column 'f33' at row 1
104 Note 1265 Data truncated for column 'f34' at row 1
105 Note 1265 Data truncated for column 'f35' at row 1
106 Note 1265 Data truncated for column 'f36' at row 1
107 Note 1265 Data truncated for column 'f37' at row 1
108 Note 1265 Data truncated for column 'f38' at row 1
109 Note 1265 Data truncated for column 'f39' at row 1
110 Note 1265 Data truncated for column 'f40' at row 1
111 Note 1265 Data truncated for column 'f41' at row 1
112 Note 1265 Data truncated for column 'f42' at row 1
113 Note 1265 Data truncated for column 'f43' at row 1
114 Note 1265 Data truncated for column 'f44' at row 1
115 Note 1265 Data truncated for column 'f45' at row 1
116 Note 1265 Data truncated for column 'f47' at row 1
117 Note 1265 Data truncated for column 'f49' at row 1
118 Note 1265 Data truncated for column 'f51' at row 1
119 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/myisam_tb1.txt'
120 into table tb1 character set latin1;
121 drop table if exists tb2 ;
122 create table tb2 (
123 f59 numeric (0) unsigned,
124 f60 numeric (64) unsigned,
125 f61 numeric (0) zerofill,
126 f62 numeric (64) zerofill,
127 f63 numeric (0) unsigned zerofill,
128 f64 numeric (64) unsigned zerofill,
129 f65 numeric (0,0),
130 f66 numeric (63,30),
131 f67 numeric (0,0) unsigned,
132 f68 numeric (63,30) unsigned,
133 f69 numeric (0,0) zerofill,
134 f70 numeric (63,30) zerofill,
135 f71 numeric (0,0) unsigned zerofill,
136 f72 numeric (63,30) unsigned zerofill,
137 f73 real,
138 f74 real unsigned,
139 f75 real zerofill,
140 f76 real unsigned zerofill,
141 f77 double default 7.7,
142 f78 double unsigned default 7.7,
143 f79 double zerofill default 7.7,
144 f80 double unsigned zerofill default 8.8,
145 f81 float not null default 8.8,
146 f82 float unsigned not null default 8.8,
147 f83 float zerofill not null default 8.8,
148 f84 float unsigned zerofill not null default 8.8,
149 f85 float(0) not null default 8.8,
150 f86 float(23) not null default 8.8,
151 f87 float(0) unsigned not null default 8.8,
152 f88 float(23) unsigned not null default 8.8,
153 f89 float(0) zerofill not null default 8.8,
154 f90 float(23) zerofill not null default 8.8,
155 f91 float(0) unsigned zerofill not null default 8.8,
156 f92 float(23) unsigned zerofill not null default 8.8,
157 f93 float(24) not null default 8.8,
158 f94 float(53) not null default 8.8,
159 f95 float(24) unsigned not null default 8.8,
160 f96 float(53) unsigned not null default 8.8,
161 f97 float(24) zerofill not null default 8.8,
162 f98 float(53) zerofill not null default 8.8,
163 f99 float(24) unsigned zerofill not null default 8.8,
164 f100 float(53) unsigned zerofill not null default 8.8,
165 f101 date not null default '2000-01-01',
166 f102 time not null default 20,
167 f103 datetime not null default '2/2/2',
168 f104 timestamp not null default 20001231235959,
169 f105 year not null default 2000,
170 f108 enum("1enum","2enum") not null default "1enum",
171 f109 set("1set","2set") not null default "1set",
172 f110 VARBINARY(64) null,
173 f111 VARBINARY(27) null ,
174 f112 VARBINARY(64) null ,
175 f113 VARBINARY(192) null ,
176 f114 VARBINARY(192) ,
177 f115 VARBINARY(27) null ,
178 f116 VARBINARY(64) null,
179 f117 VARBINARY(192) null
180 ) charset latin1 engine = myisam;
181 Warnings:
182 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
183 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
184 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
185 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
186 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
187 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
188 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
189 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
190 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
191 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
192 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
193 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
194 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
195 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
196 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
197 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
198 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
199 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
200 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
201 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
202 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
203 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
204 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
205 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
206 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
207 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
208 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
209 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
210 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
211 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
212 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
213 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
214 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
215 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
216 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
217 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
218 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
219 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
220 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
221 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
222 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
223 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
224 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
225 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
226 Warning 4095 Delimiter '/' in position 1 in datetime value '2/2/2' at row 1 is deprecated. Prefer the standard '-'.
227 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/myisam_tb2.txt'
228 into table tb2 character set latin1;
229 drop table if exists tb3 ;
230 create table tb3 (
231 f118 char not null DEFAULT 'a',
232 f119 char binary not null DEFAULT b'101',
233 f120 char ascii not null DEFAULT b'101',
234 f121 tinytext,
235 f122 text,
236 f123 mediumtext,
237 f124 longtext,
238 f125 tinyblob,
239 f126 blob,
240 f127 mediumblob,
241 f128 longblob,
242 f129 binary not null DEFAULT b'101',
243 f130 tinyint not null DEFAULT 99,
244 f131 tinyint unsigned not null DEFAULT 99,
245 f132 tinyint zerofill not null DEFAULT 99,
246 f133 tinyint unsigned zerofill not null DEFAULT 99,
247 f134 smallint not null DEFAULT 999,
248 f135 smallint unsigned not null DEFAULT 999,
249 f136 smallint zerofill not null DEFAULT 999,
250 f137 smallint unsigned zerofill not null DEFAULT 999,
251 f138 mediumint not null DEFAULT 9999,
252 f139 mediumint unsigned not null DEFAULT 9999,
253 f140 mediumint zerofill not null DEFAULT 9999,
254 f141 mediumint unsigned zerofill not null DEFAULT 9999,
255 f142 int not null DEFAULT 99999,
256 f143 int unsigned not null DEFAULT 99999,
257 f144 int zerofill not null DEFAULT 99999,
258 f145 int unsigned zerofill not null DEFAULT 99999,
259 f146 bigint not null DEFAULT 999999,
260 f147 bigint unsigned not null DEFAULT 999999,
261 f148 bigint zerofill not null DEFAULT 999999,
262 f149 bigint unsigned zerofill not null DEFAULT 999999,
263 f150 decimal not null DEFAULT 999.999,
264 f151 decimal unsigned not null DEFAULT 999.17,
265 f152 decimal zerofill not null DEFAULT 999.999,
266 f153 decimal unsigned zerofill,
267 f154 decimal (0),
268 f155 decimal (64),
269 f156 decimal (0) unsigned,
270 f157 decimal (64) unsigned,
271 f158 decimal (0) zerofill,
272 f159 decimal (64) zerofill,
273 f160 decimal (0) unsigned zerofill,
274 f161 decimal (64) unsigned zerofill,
275 f162 decimal (0,0),
276 f163 decimal (63,30),
277 f164 decimal (0,0) unsigned,
278 f165 decimal (63,30) unsigned,
279 f166 decimal (0,0) zerofill,
280 f167 decimal (63,30) zerofill,
281 f168 decimal (0,0) unsigned zerofill,
282 f169 decimal (63,30) unsigned zerofill,
283 f170 numeric,
284 f171 numeric unsigned,
285 f172 numeric zerofill,
286 f173 numeric unsigned zerofill,
287 f174 numeric (0),
288 f175 numeric (64)
289 ) charset latin1 Engine = myisam;
290 Warnings:
291 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
292 Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead
293 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
294 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
295 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
296 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
297 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
298 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
299 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
300 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
301 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
302 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
303 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
304 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
305 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
306 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
307 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
308 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
309 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
310 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
311 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
312 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
313 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
314 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
315 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
316 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
317 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
318 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
319 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
320 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
321 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
322 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
323 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
324 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
325 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
326 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
327 Note 1265 Data truncated for column 'f150' at row 1
328 Note 1265 Data truncated for column 'f151' at row 1
329 Note 1265 Data truncated for column 'f152' at row 1
330 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/myisam_tb3.txt'
331 into table tb3 character set latin1;
332 drop table if exists tb4 ;
333 create table tb4 (
334 f176 numeric (0) unsigned not null DEFAULT 9,
335 f177 numeric (64) unsigned not null DEFAULT 9,
336 f178 numeric (0) zerofill not null DEFAULT 9,
337 f179 numeric (64) zerofill not null DEFAULT 9,
338 f180 numeric (0) unsigned zerofill not null DEFAULT 9,
339 f181 numeric (64) unsigned zerofill not null DEFAULT 9,
340 f182 numeric (0,0) not null DEFAULT 9,
341 f183 numeric (63,30) not null DEFAULT 9,
342 f184 numeric (0,0) unsigned not null DEFAULT 9,
343 f185 numeric (63,30) unsigned not null DEFAULT 9,
344 f186 numeric (0,0) zerofill not null DEFAULT 9,
345 f187 numeric (63,30) zerofill not null DEFAULT 9,
346 f188 numeric (0,0) unsigned zerofill not null DEFAULT 9,
347 f189 numeric (63,30) unsigned zerofill not null DEFAULT 9,
348 f190 real not null DEFAULT 88.8,
349 f191 real unsigned not null DEFAULT 88.8,
350 f192 real zerofill not null DEFAULT 88.8,
351 f193 real unsigned zerofill not null DEFAULT 88.8,
352 f194 double not null DEFAULT 55.5,
353 f195 double unsigned not null DEFAULT 55.5,
354 f196 double zerofill not null DEFAULT 55.5,
355 f197 double unsigned zerofill not null DEFAULT 55.5,
356 f198 float,
357 f199 float unsigned,
358 f200 float zerofill,
359 f201 float unsigned zerofill,
360 f202 float(0),
361 f203 float(23),
362 f204 float(0) unsigned,
363 f205 float(23) unsigned,
364 f206 float(0) zerofill,
365 f207 float(23) zerofill,
366 f208 float(0) unsigned zerofill,
367 f209 float(23) unsigned zerofill,
368 f210 float(24),
369 f211 float(53),
370 f212 float(24) unsigned,
371 f213 float(53) unsigned,
372 f214 float(24) zerofill,
373 f215 float(53) zerofill,
374 f216 float(24) unsigned zerofill,
375 f217 float(53) unsigned zerofill,
376 f218 date,
377 f219 time,
378 f220 datetime,
379 f221 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
380 f222 year,
381 f225 enum("1enum","2enum"),
382 f226 set("1set","2set"),
383 f227 VARBINARY(64),
384 f228 VARBINARY(27),
385 f229 VARBINARY(64),
386 f230 VARBINARY(192),
387 f231 VARBINARY(192),
388 f232 VARBINARY(27),
389 f233 VARBINARY(64),
390 f234 VARBINARY(192),
391 f235 char(255),
392 f236 char(60) ascii,
393 f237 char(255) binary,
394 f238 varchar(0) binary,
395 f239 varbinary(1000),
396 f240 varchar(120),
397 f241 char(100),
398 f242 bit(30)
399 ) charset latin1 engine = myisam;
400 Warnings:
401 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
402 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
403 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
404 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
405 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
406 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
407 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
408 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
409 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
410 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
411 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
412 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
413 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
414 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
415 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
416 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
417 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
418 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
419 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
420 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
421 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
422 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
423 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
424 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
425 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
426 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
427 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
428 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
429 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
430 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
431 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
432 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
433 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
434 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
435 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
436 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
437 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
438 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
439 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
440 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
441 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
442 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
443 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
444 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
445 Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead
446 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
447 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
448 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/myisam_tb4.txt'
449 into table tb4 character set latin1;
450 USE test1;
451 drop table if exists tb2 ;
452 create table tb2 (
453 f59 numeric (0) unsigned,
454 f60 numeric (64) unsigned,
455 f61 numeric (0) zerofill,
456 f62 numeric (64) zerofill,
457 f63 numeric (0) unsigned zerofill,
458 f64 numeric (64) unsigned zerofill,
459 f65 numeric (0,0),
460 f66 numeric (63,30),
461 f67 numeric (0,0) unsigned,
462 f68 numeric (63,30) unsigned,
463 f69 numeric (0,0) zerofill,
464 f70 numeric (63,30) zerofill,
465 f71 numeric (0,0) unsigned zerofill,
466 f72 numeric (63,30) unsigned zerofill,
467 f73 real,
468 f74 real unsigned,
469 f75 real zerofill,
470 f76 real unsigned zerofill,
471 f77 double default 7.7,
472 f78 double unsigned default 7.7,
473 f79 double zerofill default 7.7,
474 f80 double unsigned zerofill default 8.8,
475 f81 float not null default 8.8,
476 f82 float unsigned not null default 8.8,
477 f83 float zerofill not null default 8.8,
478 f84 float unsigned zerofill not null default 8.8,
479 f85 float(0) not null default 8.8,
480 f86 float(23) not null default 8.8,
481 f87 float(0) unsigned not null default 8.8,
482 f88 float(23) unsigned not null default 8.8,
483 f89 float(0) zerofill not null default 8.8,
484 f90 float(23) zerofill not null default 8.8,
485 f91 float(0) unsigned zerofill not null default 8.8,
486 f92 float(23) unsigned zerofill not null default 8.8,
487 f93 float(24) not null default 8.8,
488 f94 float(53) not null default 8.8,
489 f95 float(24) unsigned not null default 8.8,
490 f96 float(53) unsigned not null default 8.8,
491 f97 float(24) zerofill not null default 8.8,
492 f98 float(53) zerofill not null default 8.8,
493 f99 float(24) unsigned zerofill not null default 8.8,
494 f100 float(53) unsigned zerofill not null default 8.8,
495 f101 date not null default '2000-01-01',
496 f102 time not null default 20,
497 f103 datetime not null default '2/2/2',
498 f104 timestamp not null default 20001231235959,
499 f105 year not null default 2000,
500 f108 enum("1enum","2enum") not null default "1enum",
501 f109 set("1set","2set") not null default "1set",
502 f110 VARBINARY(64) null,
503 f111 VARBINARY(27) null ,
504 f112 VARBINARY(64) null ,
505 f113 VARBINARY(192) null ,
506 f114 VARBINARY(192) ,
507 f115 VARBINARY(27) null ,
508 f116 VARBINARY(64) null,
509 f117 VARBINARY(192) null
510 ) charset latin1 engine = myisam;
511 Warnings:
512 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
513 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
514 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
515 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
516 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
517 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
518 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
519 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
520 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
521 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
522 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
523 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
524 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
525 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
526 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
527 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
528 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
529 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
530 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
531 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
532 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
533 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
534 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
535 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
536 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
537 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
538 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
539 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
540 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
541 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
542 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
543 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
544 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
545 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
546 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
547 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
548 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
549 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
550 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
551 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
552 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
553 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
554 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
555 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
556 Warning 4095 Delimiter '/' in position 1 in datetime value '2/2/2' at row 1 is deprecated. Prefer the standard '-'.
557 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/myisam_tb2.txt'
558 into table tb2 character set latin1;
559 USE test;
560 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
561 USE test;
562 DROP TABLE IF EXISTS t1, t2, t4, t10, t11;
563 CREATE TABLE t1 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
564 charset latin1 ENGINE = MyISAM;
565 CREATE TABLE t2 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
566 charset latin1 ENGINE = MyISAM;
567 CREATE TABLE t4 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
568 charset latin1 ENGINE = MyISAM;
569 CREATE TABLE t10 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
570 charset latin1 ENGINE = MyISAM;
571 CREATE TABLE t11 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
572 charset latin1 ENGINE = MyISAM;
573 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t1
574 character set latin1;
575 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t2
576 character set latin1;
577 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t4
578 character set latin1;
579 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t10
580 character set latin1;
581 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t11
582 character set latin1;
583 drop TABLE if exists t3;
584 CREATE TABLE t3 (f1 char(20), f2 char(20), f3 integer) charset latin1 ENGINE = MyISAM;
585 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t3.txt' INTO TABLE t3
586 character set latin1;
587 drop database if exists test4;
588 CREATE database test4;
589 use test4;
590 CREATE TABLE t6 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int)
591 charset latin1 ENGINE = MyISAM;
592 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t6
593 character set latin1;
594 use test;
595 drop TABLE if exists t7, t8;
596 CREATE TABLE t7 (f1 char(20),f2 char(25),f3 date,f4 int) charset latin1 ENGINE = MyISAM;
597 CREATE TABLE t8 (f1 char(20),f2 char(25),f3 date,f4 int) charset latin1 ENGINE = MyISAM;
598 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t7
599 character set latin1;
600 Warnings:
601 Warning 1265 Data truncated for column 'f3' at row 1
602 Warning 1265 Data truncated for column 'f3' at row 2
603 Warning 1265 Data truncated for column 'f3' at row 3
604 Warning 1265 Data truncated for column 'f3' at row 4
605 Warning 1265 Data truncated for column 'f3' at row 5
606 Warning 1265 Data truncated for column 'f3' at row 6
607 Warning 1265 Data truncated for column 'f3' at row 7
608 Warning 1265 Data truncated for column 'f3' at row 8
609 Warning 1265 Data truncated for column 'f3' at row 9
610 Warning 1265 Data truncated for column 'f3' at row 10
611 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t8
612 character set latin1;
613 Warnings:
614 Warning 1265 Data truncated for column 'f3' at row 1
615 Warning 1265 Data truncated for column 'f3' at row 2
616 Warning 1265 Data truncated for column 'f3' at row 3
617 Warning 1265 Data truncated for column 'f3' at row 4
618 Warning 1265 Data truncated for column 'f3' at row 5
619 Warning 1265 Data truncated for column 'f3' at row 6
620 Warning 1265 Data truncated for column 'f3' at row 7
621 Warning 1265 Data truncated for column 'f3' at row 8
622 Warning 1265 Data truncated for column 'f3' at row 9
623 Warning 1265 Data truncated for column 'f3' at row 10
624 drop TABLE if exists t9;
625 CREATE TABLE t9 (f1 int, f2 char(25), f3 int) charset latin1 ENGINE = MyISAM;
626 LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t9.txt' INTO TABLE t9
627 character set latin1;
628 SET sql_mode = default;
629 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
630 SELECT * FROM information_schema.columns
631 WHERE table_schema LIKE 'test%'
632 ORDER BY table_schema,
633 table_name COLLATE utf8_general_ci,
634 ordinal_position;
635 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT GENERATION_EXPRESSION SRS_ID
636 def test t1 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
637 def test t1 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
638 def test t1 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
639 def test t1 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
640 def test t1 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
641 def test t1 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
642 def test t10 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
643 def test t10 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
644 def test t10 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
645 def test t10 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
646 def test t10 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
647 def test t10 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
648 def test t11 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
649 def test t11 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
650 def test t11 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
651 def test t11 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
652 def test t11 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
653 def test t11 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
654 def test t2 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
655 def test t2 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
656 def test t2 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
657 def test t2 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
658 def test t2 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
659 def test t2 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
660 def test t3 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
661 def test t3 f2 2 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
662 def test t3 f3 3 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
663 def test t4 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
664 def test t4 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
665 def test t4 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
666 def test t4 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
667 def test t4 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
668 def test t4 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
669 def test t7 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
670 def test t7 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
671 def test t7 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
672 def test t7 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
673 def test t8 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
674 def test t8 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
675 def test t8 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
676 def test t8 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
677 def test t9 f1 1 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
678 def test t9 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
679 def test t9 f3 3 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
680 def test tb1 f1 1 NULL YES char 1 1 NULL NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references NULL
681 def test tb1 f2 2 NULL YES char 1 1 NULL NULL NULL latin1 latin1_bin char(1) select,insert,update,references NULL
682 def test tb1 f3 3 NULL YES char 1 1 NULL NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references NULL
683 def test tb1 f4 4 NULL YES tinytext 255 255 NULL NULL NULL latin1 latin1_swedish_ci tinytext select,insert,update,references NULL
684 def test tb1 f5 5 NULL YES text 65535 65535 NULL NULL NULL latin1 latin1_swedish_ci text select,insert,update,references NULL
685 def test tb1 f6 6 NULL YES mediumtext 16777215 16777215 NULL NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references NULL
686 def test tb1 f7 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL latin1 latin1_swedish_ci longtext select,insert,update,references NULL
687 def test tb1 f8 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL NULL tinyblob select,insert,update,references NULL
688 def test tb1 f9 9 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL
689 def test tb1 f10 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL NULL mediumblob select,insert,update,references NULL
690 def test tb1 f11 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob select,insert,update,references NULL
691 def test tb1 f12 12 NULL YES binary 1 1 NULL NULL NULL NULL NULL binary(1) select,insert,update,references NULL
692 def test tb1 f13 13 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint select,insert,update,references NULL
693 def test tb1 f14 14 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned select,insert,update,references NULL
694 def test tb1 f15 15 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL
695 def test tb1 f16 16 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL
696 def test tb1 f17 17 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint select,insert,update,references NULL
697 def test tb1 f18 18 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL
698 def test tb1 f19 19 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL
699 def test tb1 f20 20 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL
700 def test tb1 f21 21 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint select,insert,update,references NULL
701 def test tb1 f22 22 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint unsigned select,insert,update,references NULL
702 def test tb1 f23 23 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL
703 def test tb1 f24 24 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL
704 def test tb1 f25 25 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
705 def test tb1 f26 26 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL
706 def test tb1 f27 27 NULL YES int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL
707 def test tb1 f28 28 NULL YES int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL
708 def test tb1 f29 29 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select,insert,update,references NULL
709 def test tb1 f30 30 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL
710 def test tb1 f31 31 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL
711 def test tb1 f32 32 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL
712 def test tb1 f33 33 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
713 def test tb1 f34 34 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
714 def test tb1 f35 35 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
715 def test tb1 f36 36 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
716 def test tb1 f37 37 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
717 def test tb1 f38 38 10 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL
718 def test tb1 f39 39 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
719 def test tb1 f40 40 10 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
720 def test tb1 f41 41 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
721 def test tb1 f42 42 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
722 def test tb1 f43 43 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
723 def test tb1 f44 44 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
724 def test tb1 f45 45 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
725 def test tb1 f46 46 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
726 def test tb1 f47 47 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
727 def test tb1 f48 48 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
728 def test tb1 f49 49 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
729 def test tb1 f50 50 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
730 def test tb1 f51 51 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
731 def test tb1 f52 52 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
732 def test tb1 f53 53 99 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
733 def test tb1 f54 54 99 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
734 def test tb1 f55 55 0000000099 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
735 def test tb1 f56 56 0000000099 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
736 def test tb1 f57 57 99 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
737 def test tb1 f58 58 99 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL
738 def test tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
739 def test tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
740 def test tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
741 def test tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
742 def test tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
743 def test tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
744 def test tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
745 def test tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
746 def test tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
747 def test tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
748 def test tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
749 def test tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
750 def test tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
751 def test tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
752 def test tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
753 def test tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
754 def test tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
755 def test tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
756 def test tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
757 def test tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
758 def test tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
759 def test tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
760 def test tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
761 def test tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
762 def test tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
763 def test tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
764 def test tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
765 def test tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
766 def test tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
767 def test tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
768 def test tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
769 def test tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
770 def test tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
771 def test tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
772 def test tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
773 def test tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
774 def test tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
775 def test tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
776 def test tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
777 def test tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
778 def test tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
779 def test tb2 f100 42 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
780 def test tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
781 def test tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL 0 NULL NULL time select,insert,update,references NULL
782 def test tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL 0 NULL NULL datetime select,insert,update,references NULL
783 def test tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select,insert,update,references NULL
784 def test tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL NULL year select,insert,update,references NULL
785 def test tb2 f108 48 1enum NO enum 5 5 NULL NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references NULL
786 def test tb2 f109 49 1set NO set 9 9 NULL NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references NULL
787 def test tb2 f110 50 NULL YES varbinary 64 64 NULL NULL NULL NULL NULL varbinary(64) select,insert,update,references NULL
788 def test tb2 f111 51 NULL YES varbinary 27 27 NULL NULL NULL NULL NULL varbinary(27) select,insert,update,references NULL
789 def test tb2 f112 52 NULL YES varbinary 64 64 NULL NULL NULL NULL NULL varbinary(64) select,insert,update,references NULL
790 def test tb2 f113 53 NULL YES varbinary 192 192 NULL NULL NULL NULL NULL varbinary(192) select,insert,update,references NULL
791 def test tb2 f114 54 NULL YES varbinary 192 192 NULL NULL NULL NULL NULL varbinary(192) select,insert,update,references NULL
792 def test tb2 f115 55 NULL YES varbinary 27 27 NULL NULL NULL NULL NULL varbinary(27) select,insert,update,references NULL
793 def test tb2 f116 56 NULL YES varbinary 64 64 NULL NULL NULL NULL NULL varbinary(64) select,insert,update,references NULL
794 def test tb2 f117 57 NULL YES varbinary 192 192 NULL NULL NULL NULL NULL varbinary(192) select,insert,update,references NULL
795 def test tb3 f118 1 a NO char 1 1 NULL NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references NULL
796 def test tb3 f119 2  NO char 1 1 NULL NULL NULL latin1 latin1_bin char(1) select,insert,update,references NULL
797 def test tb3 f120 3  NO char 1 1 NULL NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references NULL
798 def test tb3 f121 4 NULL YES tinytext 255 255 NULL NULL NULL latin1 latin1_swedish_ci tinytext select,insert,update,references NULL
799 def test tb3 f122 5 NULL YES text 65535 65535 NULL NULL NULL latin1 latin1_swedish_ci text select,insert,update,references NULL
800 def test tb3 f123 6 NULL YES mediumtext 16777215 16777215 NULL NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references NULL
801 def test tb3 f124 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL latin1 latin1_swedish_ci longtext select,insert,update,references NULL
802 def test tb3 f125 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL NULL tinyblob select,insert,update,references NULL
803 def test tb3 f126 9 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL
804 def test tb3 f127 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL NULL mediumblob select,insert,update,references NULL
805 def test tb3 f128 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob select,insert,update,references NULL
806 def test tb3 f129 12 0x05 NO binary 1 1 NULL NULL NULL NULL NULL binary(1) select,insert,update,references NULL
807 def test tb3 f130 13 99 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint select,insert,update,references NULL
808 def test tb3 f131 14 99 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned select,insert,update,references NULL
809 def test tb3 f132 15 099 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL
810 def test tb3 f133 16 099 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL
811 def test tb3 f134 17 999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint select,insert,update,references NULL
812 def test tb3 f135 18 999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL
813 def test tb3 f136 19 00999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL
814 def test tb3 f137 20 00999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL
815 def test tb3 f138 21 9999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint select,insert,update,references NULL
816 def test tb3 f139 22 9999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint unsigned select,insert,update,references NULL
817 def test tb3 f140 23 00009999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL
818 def test tb3 f141 24 00009999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL
819 def test tb3 f142 25 99999 NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
820 def test tb3 f143 26 99999 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL
821 def test tb3 f144 27 0000099999 NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL
822 def test tb3 f145 28 0000099999 NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL
823 def test tb3 f146 29 999999 NO bigint NULL NULL 19 0 NULL NULL NULL bigint select,insert,update,references NULL
824 def test tb3 f147 30 999999 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL
825 def test tb3 f148 31 00000000000000999999 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL
826 def test tb3 f149 32 00000000000000999999 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL
827 def test tb3 f150 33 1000 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
828 def test tb3 f151 34 999 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
829 def test tb3 f152 35 0000001000 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
830 def test tb3 f153 36 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
831 def test tb3 f154 37 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
832 def test tb3 f155 38 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL
833 def test tb3 f156 39 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
834 def test tb3 f157 40 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
835 def test tb3 f158 41 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
836 def test tb3 f159 42 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
837 def test tb3 f160 43 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
838 def test tb3 f161 44 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
839 def test tb3 f162 45 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
840 def test tb3 f163 46 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
841 def test tb3 f164 47 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
842 def test tb3 f165 48 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
843 def test tb3 f166 49 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
844 def test tb3 f167 50 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
845 def test tb3 f168 51 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
846 def test tb3 f169 52 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
847 def test tb3 f170 53 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
848 def test tb3 f171 54 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
849 def test tb3 f172 55 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
850 def test tb3 f173 56 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
851 def test tb3 f174 57 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
852 def test tb3 f175 58 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL
853 def test tb4 f176 1 9 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
854 def test tb4 f177 2 9 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
855 def test tb4 f178 3 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
856 def test tb4 f179 4 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
857 def test tb4 f180 5 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
858 def test tb4 f181 6 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
859 def test tb4 f182 7 9 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
860 def test tb4 f183 8 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
861 def test tb4 f184 9 9 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
862 def test tb4 f185 10 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
863 def test tb4 f186 11 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
864 def test tb4 f187 12 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
865 def test tb4 f188 13 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
866 def test tb4 f189 14 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
867 def test tb4 f190 15 88.8 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
868 def test tb4 f191 16 88.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
869 def test tb4 f192 17 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
870 def test tb4 f193 18 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
871 def test tb4 f194 19 55.5 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
872 def test tb4 f195 20 55.5 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
873 def test tb4 f196 21 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
874 def test tb4 f197 22 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
875 def test tb4 f198 23 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
876 def test tb4 f199 24 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
877 def test tb4 f200 25 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
878 def test tb4 f201 26 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
879 def test tb4 f202 27 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
880 def test tb4 f203 28 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
881 def test tb4 f204 29 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
882 def test tb4 f205 30 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
883 def test tb4 f206 31 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
884 def test tb4 f207 32 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
885 def test tb4 f208 33 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
886 def test tb4 f209 34 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
887 def test tb4 f210 35 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
888 def test tb4 f211 36 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
889 def test tb4 f212 37 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
890 def test tb4 f213 38 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
891 def test tb4 f214 39 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
892 def test tb4 f215 40 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
893 def test tb4 f216 41 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
894 def test tb4 f217 42 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
895 def test tb4 f218 43 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
896 def test tb4 f219 44 NULL YES time NULL NULL NULL NULL 0 NULL NULL time select,insert,update,references NULL
897 def test tb4 f220 45 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select,insert,update,references NULL
898 def test tb4 f221 46 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL
899 def test tb4 f222 47 NULL YES year NULL NULL NULL NULL NULL NULL NULL year select,insert,update,references NULL
900 def test tb4 f225 48 NULL YES enum 5 5 NULL NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references NULL
901 def test tb4 f226 49 NULL YES set 9 9 NULL NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references NULL
902 def test tb4 f227 50 NULL YES varbinary 64 64 NULL NULL NULL NULL NULL varbinary(64) select,insert,update,references NULL
903 def test tb4 f228 51 NULL YES varbinary 27 27 NULL NULL NULL NULL NULL varbinary(27) select,insert,update,references NULL
904 def test tb4 f229 52 NULL YES varbinary 64 64 NULL NULL NULL NULL NULL varbinary(64) select,insert,update,references NULL
905 def test tb4 f230 53 NULL YES varbinary 192 192 NULL NULL NULL NULL NULL varbinary(192) select,insert,update,references NULL
906 def test tb4 f231 54 NULL YES varbinary 192 192 NULL NULL NULL NULL NULL varbinary(192) select,insert,update,references NULL
907 def test tb4 f232 55 NULL YES varbinary 27 27 NULL NULL NULL NULL NULL varbinary(27) select,insert,update,references NULL
908 def test tb4 f233 56 NULL YES varbinary 64 64 NULL NULL NULL NULL NULL varbinary(64) select,insert,update,references NULL
909 def test tb4 f234 57 NULL YES varbinary 192 192 NULL NULL NULL NULL NULL varbinary(192) select,insert,update,references NULL
910 def test tb4 f235 58 NULL YES char 255 255 NULL NULL NULL latin1 latin1_swedish_ci char(255) select,insert,update,references NULL
911 def test tb4 f236 59 NULL YES char 60 60 NULL NULL NULL latin1 latin1_swedish_ci char(60) select,insert,update,references NULL
912 def test tb4 f237 60 NULL YES char 255 255 NULL NULL NULL latin1 latin1_bin char(255) select,insert,update,references NULL
913 def test tb4 f238 61 NULL YES varchar 0 0 NULL NULL NULL latin1 latin1_bin varchar(0) select,insert,update,references NULL
914 def test tb4 f239 62 NULL YES varbinary 1000 1000 NULL NULL NULL NULL NULL varbinary(1000) select,insert,update,references NULL
915 def test tb4 f240 63 NULL YES varchar 120 120 NULL NULL NULL latin1 latin1_swedish_ci varchar(120) select,insert,update,references NULL
916 def test tb4 f241 64 NULL YES char 100 100 NULL NULL NULL latin1 latin1_swedish_ci char(100) select,insert,update,references NULL
917 def test tb4 f242 65 NULL YES bit NULL NULL 30 NULL NULL NULL NULL bit(30) select,insert,update,references NULL
918 def test1 tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
919 def test1 tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL
920 def test1 tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
921 def test1 tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
922 def test1 tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
923 def test1 tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL
924 def test1 tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL
925 def test1 tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL
926 def test1 tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL
927 def test1 tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL
928 def test1 tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
929 def test1 tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
930 def test1 tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL
931 def test1 tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL
932 def test1 tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
933 def test1 tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
934 def test1 tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
935 def test1 tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
936 def test1 tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
937 def test1 tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
938 def test1 tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
939 def test1 tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
940 def test1 tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
941 def test1 tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
942 def test1 tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
943 def test1 tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
944 def test1 tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
945 def test1 tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
946 def test1 tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
947 def test1 tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
948 def test1 tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
949 def test1 tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
950 def test1 tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
951 def test1 tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
952 def test1 tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL
953 def test1 tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL
954 def test1 tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL
955 def test1 tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL
956 def test1 tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
957 def test1 tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
958 def test1 tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL
959 def test1 tb2 f100 42 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL
960 def test1 tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
961 def test1 tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL 0 NULL NULL time select,insert,update,references NULL
962 def test1 tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL 0 NULL NULL datetime select,insert,update,references NULL
963 def test1 tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select,insert,update,references NULL
964 def test1 tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL NULL year select,insert,update,references NULL
965 def test1 tb2 f108 48 1enum NO enum 5 5 NULL NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references NULL
966 def test1 tb2 f109 49 1set NO set 9 9 NULL NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references NULL
967 def test1 tb2 f110 50 NULL YES varbinary 64 64 NULL NULL NULL NULL NULL varbinary(64) select,insert,update,references NULL
968 def test1 tb2 f111 51 NULL YES varbinary 27 27 NULL NULL NULL NULL NULL varbinary(27) select,insert,update,references NULL
969 def test1 tb2 f112 52 NULL YES varbinary 64 64 NULL NULL NULL NULL NULL varbinary(64) select,insert,update,references NULL
970 def test1 tb2 f113 53 NULL YES varbinary 192 192 NULL NULL NULL NULL NULL varbinary(192) select,insert,update,references NULL
971 def test1 tb2 f114 54 NULL YES varbinary 192 192 NULL NULL NULL NULL NULL varbinary(192) select,insert,update,references NULL
972 def test1 tb2 f115 55 NULL YES varbinary 27 27 NULL NULL NULL NULL NULL varbinary(27) select,insert,update,references NULL
973 def test1 tb2 f116 56 NULL YES varbinary 64 64 NULL NULL NULL NULL NULL varbinary(64) select,insert,update,references NULL
974 def test1 tb2 f117 57 NULL YES varbinary 192 192 NULL NULL NULL NULL NULL varbinary(192) select,insert,update,references NULL
975 def test4 t6 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL
976 def test4 t6 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
977 def test4 t6 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL
978 def test4 t6 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
979 def test4 t6 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL
980 def test4 t6 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL
981 ##########################################################################
982 # Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH
983 ##########################################################################
984 SELECT DISTINCT
985 CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
986 DATA_TYPE,
987 CHARACTER_SET_NAME,
988 COLLATION_NAME
989 FROM information_schema.columns
990 WHERE table_schema LIKE 'test%'
991 AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1
992 ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE;
993 COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
994 1.0000 binary NULL NULL
995 1.0000 blob NULL NULL
996 1.0000 longblob NULL NULL
997 1.0000 mediumblob NULL NULL
998 1.0000 tinyblob NULL NULL
999 1.0000 varbinary NULL NULL
1000 1.0000 char latin1 latin1_bin
1001 1.0000 char latin1 latin1_swedish_ci
1002 1.0000 enum latin1 latin1_swedish_ci
1003 1.0000 longtext latin1 latin1_swedish_ci
1004 1.0000 mediumtext latin1 latin1_swedish_ci
1005 1.0000 set latin1 latin1_swedish_ci
1006 1.0000 text latin1 latin1_swedish_ci
1007 1.0000 tinytext latin1 latin1_swedish_ci
1008 1.0000 varchar latin1 latin1_swedish_ci
1009 SELECT DISTINCT
1010 CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
1011 DATA_TYPE,
1012 CHARACTER_SET_NAME,
1013 COLLATION_NAME
1014 FROM information_schema.columns
1015 WHERE table_schema LIKE 'test%'
1016 AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1
1017 ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE;
1018 COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
1019 SELECT DISTINCT
1020 CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
1021 DATA_TYPE,
1022 CHARACTER_SET_NAME,
1023 COLLATION_NAME
1024 FROM information_schema.columns
1025 WHERE table_schema LIKE 'test%'
1026 AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL
1027 ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE;
1028 COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME
1029 NULL bigint NULL NULL
1030 NULL bit NULL NULL
1031 NULL date NULL NULL
1032 NULL datetime NULL NULL
1033 NULL decimal NULL NULL
1034 NULL double NULL NULL
1035 NULL float NULL NULL
1036 NULL int NULL NULL
1037 NULL mediumint NULL NULL
1038 NULL smallint NULL NULL
1039 NULL time NULL NULL
1040 NULL timestamp NULL NULL
1041 NULL tinyint NULL NULL
1042 NULL year NULL NULL
1043 NULL varchar latin1 latin1_bin
1044 --> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values
1045 --> are 0, which is intended behavior, and the result of 0 / 0 IS NULL
1046 SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML,
1047 TABLE_SCHEMA,
1048 TABLE_NAME,
1049 COLUMN_NAME,
1050 DATA_TYPE,
1051 CHARACTER_MAXIMUM_LENGTH,
1052 CHARACTER_OCTET_LENGTH,
1053 CHARACTER_SET_NAME,
1054 COLLATION_NAME,
1055 COLUMN_TYPE
1056 FROM information_schema.columns
1057 WHERE table_schema LIKE 'test%'
1058 ORDER BY TABLE_SCHEMA, TABLE_NAME COLLATE utf8_general_ci, ORDINAL_POSITION;
1059 COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE
1060 1.0000 test t1 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1061 1.0000 test t1 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1062 NULL test t1 f3 date NULL NULL NULL NULL date
1063 NULL test t1 f4 int NULL NULL NULL NULL int
1064 1.0000 test t1 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1065 NULL test t1 f6 int NULL NULL NULL NULL int
1066 1.0000 test t10 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1067 1.0000 test t10 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1068 NULL test t10 f3 date NULL NULL NULL NULL date
1069 NULL test t10 f4 int NULL NULL NULL NULL int
1070 1.0000 test t10 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1071 NULL test t10 f6 int NULL NULL NULL NULL int
1072 1.0000 test t11 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1073 1.0000 test t11 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1074 NULL test t11 f3 date NULL NULL NULL NULL date
1075 NULL test t11 f4 int NULL NULL NULL NULL int
1076 1.0000 test t11 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1077 NULL test t11 f6 int NULL NULL NULL NULL int
1078 1.0000 test t2 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1079 1.0000 test t2 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1080 NULL test t2 f3 date NULL NULL NULL NULL date
1081 NULL test t2 f4 int NULL NULL NULL NULL int
1082 1.0000 test t2 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1083 NULL test t2 f6 int NULL NULL NULL NULL int
1084 1.0000 test t3 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1085 1.0000 test t3 f2 char 20 20 latin1 latin1_swedish_ci char(20)
1086 NULL test t3 f3 int NULL NULL NULL NULL int
1087 1.0000 test t4 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1088 1.0000 test t4 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1089 NULL test t4 f3 date NULL NULL NULL NULL date
1090 NULL test t4 f4 int NULL NULL NULL NULL int
1091 1.0000 test t4 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1092 NULL test t4 f6 int NULL NULL NULL NULL int
1093 1.0000 test t7 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1094 1.0000 test t7 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1095 NULL test t7 f3 date NULL NULL NULL NULL date
1096 NULL test t7 f4 int NULL NULL NULL NULL int
1097 1.0000 test t8 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1098 1.0000 test t8 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1099 NULL test t8 f3 date NULL NULL NULL NULL date
1100 NULL test t8 f4 int NULL NULL NULL NULL int
1101 NULL test t9 f1 int NULL NULL NULL NULL int
1102 1.0000 test t9 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1103 NULL test t9 f3 int NULL NULL NULL NULL int
1104 1.0000 test tb1 f1 char 1 1 latin1 latin1_swedish_ci char(1)
1105 1.0000 test tb1 f2 char 1 1 latin1 latin1_bin char(1)
1106 1.0000 test tb1 f3 char 1 1 latin1 latin1_swedish_ci char(1)
1107 1.0000 test tb1 f4 tinytext 255 255 latin1 latin1_swedish_ci tinytext
1108 1.0000 test tb1 f5 text 65535 65535 latin1 latin1_swedish_ci text
1109 1.0000 test tb1 f6 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext
1110 1.0000 test tb1 f7 longtext 4294967295 4294967295 latin1 latin1_swedish_ci longtext
1111 1.0000 test tb1 f8 tinyblob 255 255 NULL NULL tinyblob
1112 1.0000 test tb1 f9 blob 65535 65535 NULL NULL blob
1113 1.0000 test tb1 f10 mediumblob 16777215 16777215 NULL NULL mediumblob
1114 1.0000 test tb1 f11 longblob 4294967295 4294967295 NULL NULL longblob
1115 1.0000 test tb1 f12 binary 1 1 NULL NULL binary(1)
1116 NULL test tb1 f13 tinyint NULL NULL NULL NULL tinyint
1117 NULL test tb1 f14 tinyint NULL NULL NULL NULL tinyint unsigned
1118 NULL test tb1 f15 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1119 NULL test tb1 f16 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1120 NULL test tb1 f17 smallint NULL NULL NULL NULL smallint
1121 NULL test tb1 f18 smallint NULL NULL NULL NULL smallint unsigned
1122 NULL test tb1 f19 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1123 NULL test tb1 f20 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1124 NULL test tb1 f21 mediumint NULL NULL NULL NULL mediumint
1125 NULL test tb1 f22 mediumint NULL NULL NULL NULL mediumint unsigned
1126 NULL test tb1 f23 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1127 NULL test tb1 f24 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1128 NULL test tb1 f25 int NULL NULL NULL NULL int
1129 NULL test tb1 f26 int NULL NULL NULL NULL int unsigned
1130 NULL test tb1 f27 int NULL NULL NULL NULL int(10) unsigned zerofill
1131 NULL test tb1 f28 int NULL NULL NULL NULL int(10) unsigned zerofill
1132 NULL test tb1 f29 bigint NULL NULL NULL NULL bigint
1133 NULL test tb1 f30 bigint NULL NULL NULL NULL bigint unsigned
1134 NULL test tb1 f31 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1135 NULL test tb1 f32 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1136 NULL test tb1 f33 decimal NULL NULL NULL NULL decimal(10,0)
1137 NULL test tb1 f34 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1138 NULL test tb1 f35 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1139 NULL test tb1 f36 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1140 NULL test tb1 f37 decimal NULL NULL NULL NULL decimal(10,0)
1141 NULL test tb1 f38 decimal NULL NULL NULL NULL decimal(64,0)
1142 NULL test tb1 f39 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1143 NULL test tb1 f40 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1144 NULL test tb1 f41 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1145 NULL test tb1 f42 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1146 NULL test tb1 f43 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1147 NULL test tb1 f44 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1148 NULL test tb1 f45 decimal NULL NULL NULL NULL decimal(10,0)
1149 NULL test tb1 f46 decimal NULL NULL NULL NULL decimal(63,30)
1150 NULL test tb1 f47 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1151 NULL test tb1 f48 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1152 NULL test tb1 f49 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1153 NULL test tb1 f50 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1154 NULL test tb1 f51 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1155 NULL test tb1 f52 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1156 NULL test tb1 f53 decimal NULL NULL NULL NULL decimal(10,0)
1157 NULL test tb1 f54 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1158 NULL test tb1 f55 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1159 NULL test tb1 f56 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1160 NULL test tb1 f57 decimal NULL NULL NULL NULL decimal(10,0)
1161 NULL test tb1 f58 decimal NULL NULL NULL NULL decimal(64,0)
1162 NULL test tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1163 NULL test tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1164 NULL test tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1165 NULL test tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1166 NULL test tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1167 NULL test tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1168 NULL test tb2 f65 decimal NULL NULL NULL NULL decimal(10,0)
1169 NULL test tb2 f66 decimal NULL NULL NULL NULL decimal(63,30)
1170 NULL test tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1171 NULL test tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1172 NULL test tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1173 NULL test tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1174 NULL test tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1175 NULL test tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1176 NULL test tb2 f73 double NULL NULL NULL NULL double
1177 NULL test tb2 f74 double NULL NULL NULL NULL double unsigned
1178 NULL test tb2 f75 double NULL NULL NULL NULL double unsigned zerofill
1179 NULL test tb2 f76 double NULL NULL NULL NULL double unsigned zerofill
1180 NULL test tb2 f77 double NULL NULL NULL NULL double
1181 NULL test tb2 f78 double NULL NULL NULL NULL double unsigned
1182 NULL test tb2 f79 double NULL NULL NULL NULL double unsigned zerofill
1183 NULL test tb2 f80 double NULL NULL NULL NULL double unsigned zerofill
1184 NULL test tb2 f81 float NULL NULL NULL NULL float
1185 NULL test tb2 f82 float NULL NULL NULL NULL float unsigned
1186 NULL test tb2 f83 float NULL NULL NULL NULL float unsigned zerofill
1187 NULL test tb2 f84 float NULL NULL NULL NULL float unsigned zerofill
1188 NULL test tb2 f85 float NULL NULL NULL NULL float
1189 NULL test tb2 f86 float NULL NULL NULL NULL float
1190 NULL test tb2 f87 float NULL NULL NULL NULL float unsigned
1191 NULL test tb2 f88 float NULL NULL NULL NULL float unsigned
1192 NULL test tb2 f89 float NULL NULL NULL NULL float unsigned zerofill
1193 NULL test tb2 f90 float NULL NULL NULL NULL float unsigned zerofill
1194 NULL test tb2 f91 float NULL NULL NULL NULL float unsigned zerofill
1195 NULL test tb2 f92 float NULL NULL NULL NULL float unsigned zerofill
1196 NULL test tb2 f93 float NULL NULL NULL NULL float
1197 NULL test tb2 f94 double NULL NULL NULL NULL double
1198 NULL test tb2 f95 float NULL NULL NULL NULL float unsigned
1199 NULL test tb2 f96 double NULL NULL NULL NULL double unsigned
1200 NULL test tb2 f97 float NULL NULL NULL NULL float unsigned zerofill
1201 NULL test tb2 f98 double NULL NULL NULL NULL double unsigned zerofill
1202 NULL test tb2 f99 float NULL NULL NULL NULL float unsigned zerofill
1203 NULL test tb2 f100 double NULL NULL NULL NULL double unsigned zerofill
1204 NULL test tb2 f101 date NULL NULL NULL NULL date
1205 NULL test tb2 f102 time NULL NULL NULL NULL time
1206 NULL test tb2 f103 datetime NULL NULL NULL NULL datetime
1207 NULL test tb2 f104 timestamp NULL NULL NULL NULL timestamp
1208 NULL test tb2 f105 year NULL NULL NULL NULL year
1209 1.0000 test tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')
1210 1.0000 test tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set')
1211 1.0000 test tb2 f110 varbinary 64 64 NULL NULL varbinary(64)
1212 1.0000 test tb2 f111 varbinary 27 27 NULL NULL varbinary(27)
1213 1.0000 test tb2 f112 varbinary 64 64 NULL NULL varbinary(64)
1214 1.0000 test tb2 f113 varbinary 192 192 NULL NULL varbinary(192)
1215 1.0000 test tb2 f114 varbinary 192 192 NULL NULL varbinary(192)
1216 1.0000 test tb2 f115 varbinary 27 27 NULL NULL varbinary(27)
1217 1.0000 test tb2 f116 varbinary 64 64 NULL NULL varbinary(64)
1218 1.0000 test tb2 f117 varbinary 192 192 NULL NULL varbinary(192)
1219 1.0000 test tb3 f118 char 1 1 latin1 latin1_swedish_ci char(1)
1220 1.0000 test tb3 f119 char 1 1 latin1 latin1_bin char(1)
1221 1.0000 test tb3 f120 char 1 1 latin1 latin1_swedish_ci char(1)
1222 1.0000 test tb3 f121 tinytext 255 255 latin1 latin1_swedish_ci tinytext
1223 1.0000 test tb3 f122 text 65535 65535 latin1 latin1_swedish_ci text
1224 1.0000 test tb3 f123 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext
1225 1.0000 test tb3 f124 longtext 4294967295 4294967295 latin1 latin1_swedish_ci longtext
1226 1.0000 test tb3 f125 tinyblob 255 255 NULL NULL tinyblob
1227 1.0000 test tb3 f126 blob 65535 65535 NULL NULL blob
1228 1.0000 test tb3 f127 mediumblob 16777215 16777215 NULL NULL mediumblob
1229 1.0000 test tb3 f128 longblob 4294967295 4294967295 NULL NULL longblob
1230 1.0000 test tb3 f129 binary 1 1 NULL NULL binary(1)
1231 NULL test tb3 f130 tinyint NULL NULL NULL NULL tinyint
1232 NULL test tb3 f131 tinyint NULL NULL NULL NULL tinyint unsigned
1233 NULL test tb3 f132 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1234 NULL test tb3 f133 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill
1235 NULL test tb3 f134 smallint NULL NULL NULL NULL smallint
1236 NULL test tb3 f135 smallint NULL NULL NULL NULL smallint unsigned
1237 NULL test tb3 f136 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1238 NULL test tb3 f137 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill
1239 NULL test tb3 f138 mediumint NULL NULL NULL NULL mediumint
1240 NULL test tb3 f139 mediumint NULL NULL NULL NULL mediumint unsigned
1241 NULL test tb3 f140 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1242 NULL test tb3 f141 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill
1243 NULL test tb3 f142 int NULL NULL NULL NULL int
1244 NULL test tb3 f143 int NULL NULL NULL NULL int unsigned
1245 NULL test tb3 f144 int NULL NULL NULL NULL int(10) unsigned zerofill
1246 NULL test tb3 f145 int NULL NULL NULL NULL int(10) unsigned zerofill
1247 NULL test tb3 f146 bigint NULL NULL NULL NULL bigint
1248 NULL test tb3 f147 bigint NULL NULL NULL NULL bigint unsigned
1249 NULL test tb3 f148 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1250 NULL test tb3 f149 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill
1251 NULL test tb3 f150 decimal NULL NULL NULL NULL decimal(10,0)
1252 NULL test tb3 f151 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1253 NULL test tb3 f152 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1254 NULL test tb3 f153 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1255 NULL test tb3 f154 decimal NULL NULL NULL NULL decimal(10,0)
1256 NULL test tb3 f155 decimal NULL NULL NULL NULL decimal(64,0)
1257 NULL test tb3 f156 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1258 NULL test tb3 f157 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1259 NULL test tb3 f158 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1260 NULL test tb3 f159 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1261 NULL test tb3 f160 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1262 NULL test tb3 f161 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1263 NULL test tb3 f162 decimal NULL NULL NULL NULL decimal(10,0)
1264 NULL test tb3 f163 decimal NULL NULL NULL NULL decimal(63,30)
1265 NULL test tb3 f164 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1266 NULL test tb3 f165 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1267 NULL test tb3 f166 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1268 NULL test tb3 f167 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1269 NULL test tb3 f168 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1270 NULL test tb3 f169 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1271 NULL test tb3 f170 decimal NULL NULL NULL NULL decimal(10,0)
1272 NULL test tb3 f171 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1273 NULL test tb3 f172 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1274 NULL test tb3 f173 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1275 NULL test tb3 f174 decimal NULL NULL NULL NULL decimal(10,0)
1276 NULL test tb3 f175 decimal NULL NULL NULL NULL decimal(64,0)
1277 NULL test tb4 f176 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1278 NULL test tb4 f177 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1279 NULL test tb4 f178 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1280 NULL test tb4 f179 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1281 NULL test tb4 f180 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1282 NULL test tb4 f181 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1283 NULL test tb4 f182 decimal NULL NULL NULL NULL decimal(10,0)
1284 NULL test tb4 f183 decimal NULL NULL NULL NULL decimal(63,30)
1285 NULL test tb4 f184 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1286 NULL test tb4 f185 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1287 NULL test tb4 f186 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1288 NULL test tb4 f187 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1289 NULL test tb4 f188 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1290 NULL test tb4 f189 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1291 NULL test tb4 f190 double NULL NULL NULL NULL double
1292 NULL test tb4 f191 double NULL NULL NULL NULL double unsigned
1293 NULL test tb4 f192 double NULL NULL NULL NULL double unsigned zerofill
1294 NULL test tb4 f193 double NULL NULL NULL NULL double unsigned zerofill
1295 NULL test tb4 f194 double NULL NULL NULL NULL double
1296 NULL test tb4 f195 double NULL NULL NULL NULL double unsigned
1297 NULL test tb4 f196 double NULL NULL NULL NULL double unsigned zerofill
1298 NULL test tb4 f197 double NULL NULL NULL NULL double unsigned zerofill
1299 NULL test tb4 f198 float NULL NULL NULL NULL float
1300 NULL test tb4 f199 float NULL NULL NULL NULL float unsigned
1301 NULL test tb4 f200 float NULL NULL NULL NULL float unsigned zerofill
1302 NULL test tb4 f201 float NULL NULL NULL NULL float unsigned zerofill
1303 NULL test tb4 f202 float NULL NULL NULL NULL float
1304 NULL test tb4 f203 float NULL NULL NULL NULL float
1305 NULL test tb4 f204 float NULL NULL NULL NULL float unsigned
1306 NULL test tb4 f205 float NULL NULL NULL NULL float unsigned
1307 NULL test tb4 f206 float NULL NULL NULL NULL float unsigned zerofill
1308 NULL test tb4 f207 float NULL NULL NULL NULL float unsigned zerofill
1309 NULL test tb4 f208 float NULL NULL NULL NULL float unsigned zerofill
1310 NULL test tb4 f209 float NULL NULL NULL NULL float unsigned zerofill
1311 NULL test tb4 f210 float NULL NULL NULL NULL float
1312 NULL test tb4 f211 double NULL NULL NULL NULL double
1313 NULL test tb4 f212 float NULL NULL NULL NULL float unsigned
1314 NULL test tb4 f213 double NULL NULL NULL NULL double unsigned
1315 NULL test tb4 f214 float NULL NULL NULL NULL float unsigned zerofill
1316 NULL test tb4 f215 double NULL NULL NULL NULL double unsigned zerofill
1317 NULL test tb4 f216 float NULL NULL NULL NULL float unsigned zerofill
1318 NULL test tb4 f217 double NULL NULL NULL NULL double unsigned zerofill
1319 NULL test tb4 f218 date NULL NULL NULL NULL date
1320 NULL test tb4 f219 time NULL NULL NULL NULL time
1321 NULL test tb4 f220 datetime NULL NULL NULL NULL datetime
1322 NULL test tb4 f221 timestamp NULL NULL NULL NULL timestamp
1323 NULL test tb4 f222 year NULL NULL NULL NULL year
1324 1.0000 test tb4 f225 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')
1325 1.0000 test tb4 f226 set 9 9 latin1 latin1_swedish_ci set('1set','2set')
1326 1.0000 test tb4 f227 varbinary 64 64 NULL NULL varbinary(64)
1327 1.0000 test tb4 f228 varbinary 27 27 NULL NULL varbinary(27)
1328 1.0000 test tb4 f229 varbinary 64 64 NULL NULL varbinary(64)
1329 1.0000 test tb4 f230 varbinary 192 192 NULL NULL varbinary(192)
1330 1.0000 test tb4 f231 varbinary 192 192 NULL NULL varbinary(192)
1331 1.0000 test tb4 f232 varbinary 27 27 NULL NULL varbinary(27)
1332 1.0000 test tb4 f233 varbinary 64 64 NULL NULL varbinary(64)
1333 1.0000 test tb4 f234 varbinary 192 192 NULL NULL varbinary(192)
1334 1.0000 test tb4 f235 char 255 255 latin1 latin1_swedish_ci char(255)
1335 1.0000 test tb4 f236 char 60 60 latin1 latin1_swedish_ci char(60)
1336 1.0000 test tb4 f237 char 255 255 latin1 latin1_bin char(255)
1337 NULL test tb4 f238 varchar 0 0 latin1 latin1_bin varchar(0)
1338 1.0000 test tb4 f239 varbinary 1000 1000 NULL NULL varbinary(1000)
1339 1.0000 test tb4 f240 varchar 120 120 latin1 latin1_swedish_ci varchar(120)
1340 1.0000 test tb4 f241 char 100 100 latin1 latin1_swedish_ci char(100)
1341 NULL test tb4 f242 bit NULL NULL NULL NULL bit(30)
1342 NULL test1 tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1343 NULL test1 tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned
1344 NULL test1 tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1345 NULL test1 tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1346 NULL test1 tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1347 NULL test1 tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill
1348 NULL test1 tb2 f65 decimal NULL NULL NULL NULL decimal(10,0)
1349 NULL test1 tb2 f66 decimal NULL NULL NULL NULL decimal(63,30)
1350 NULL test1 tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned
1351 NULL test1 tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned
1352 NULL test1 tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1353 NULL test1 tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1354 NULL test1 tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1355 NULL test1 tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1356 NULL test1 tb2 f73 double NULL NULL NULL NULL double
1357 NULL test1 tb2 f74 double NULL NULL NULL NULL double unsigned
1358 NULL test1 tb2 f75 double NULL NULL NULL NULL double unsigned zerofill
1359 NULL test1 tb2 f76 double NULL NULL NULL NULL double unsigned zerofill
1360 NULL test1 tb2 f77 double NULL NULL NULL NULL double
1361 NULL test1 tb2 f78 double NULL NULL NULL NULL double unsigned
1362 NULL test1 tb2 f79 double NULL NULL NULL NULL double unsigned zerofill
1363 NULL test1 tb2 f80 double NULL NULL NULL NULL double unsigned zerofill
1364 NULL test1 tb2 f81 float NULL NULL NULL NULL float
1365 NULL test1 tb2 f82 float NULL NULL NULL NULL float unsigned
1366 NULL test1 tb2 f83 float NULL NULL NULL NULL float unsigned zerofill
1367 NULL test1 tb2 f84 float NULL NULL NULL NULL float unsigned zerofill
1368 NULL test1 tb2 f85 float NULL NULL NULL NULL float
1369 NULL test1 tb2 f86 float NULL NULL NULL NULL float
1370 NULL test1 tb2 f87 float NULL NULL NULL NULL float unsigned
1371 NULL test1 tb2 f88 float NULL NULL NULL NULL float unsigned
1372 NULL test1 tb2 f89 float NULL NULL NULL NULL float unsigned zerofill
1373 NULL test1 tb2 f90 float NULL NULL NULL NULL float unsigned zerofill
1374 NULL test1 tb2 f91 float NULL NULL NULL NULL float unsigned zerofill
1375 NULL test1 tb2 f92 float NULL NULL NULL NULL float unsigned zerofill
1376 NULL test1 tb2 f93 float NULL NULL NULL NULL float
1377 NULL test1 tb2 f94 double NULL NULL NULL NULL double
1378 NULL test1 tb2 f95 float NULL NULL NULL NULL float unsigned
1379 NULL test1 tb2 f96 double NULL NULL NULL NULL double unsigned
1380 NULL test1 tb2 f97 float NULL NULL NULL NULL float unsigned zerofill
1381 NULL test1 tb2 f98 double NULL NULL NULL NULL double unsigned zerofill
1382 NULL test1 tb2 f99 float NULL NULL NULL NULL float unsigned zerofill
1383 NULL test1 tb2 f100 double NULL NULL NULL NULL double unsigned zerofill
1384 NULL test1 tb2 f101 date NULL NULL NULL NULL date
1385 NULL test1 tb2 f102 time NULL NULL NULL NULL time
1386 NULL test1 tb2 f103 datetime NULL NULL NULL NULL datetime
1387 NULL test1 tb2 f104 timestamp NULL NULL NULL NULL timestamp
1388 NULL test1 tb2 f105 year NULL NULL NULL NULL year
1389 1.0000 test1 tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum')
1390 1.0000 test1 tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set')
1391 1.0000 test1 tb2 f110 varbinary 64 64 NULL NULL varbinary(64)
1392 1.0000 test1 tb2 f111 varbinary 27 27 NULL NULL varbinary(27)
1393 1.0000 test1 tb2 f112 varbinary 64 64 NULL NULL varbinary(64)
1394 1.0000 test1 tb2 f113 varbinary 192 192 NULL NULL varbinary(192)
1395 1.0000 test1 tb2 f114 varbinary 192 192 NULL NULL varbinary(192)
1396 1.0000 test1 tb2 f115 varbinary 27 27 NULL NULL varbinary(27)
1397 1.0000 test1 tb2 f116 varbinary 64 64 NULL NULL varbinary(64)
1398 1.0000 test1 tb2 f117 varbinary 192 192 NULL NULL varbinary(192)
1399 1.0000 test4 t6 f1 char 20 20 latin1 latin1_swedish_ci char(20)
1400 1.0000 test4 t6 f2 char 25 25 latin1 latin1_swedish_ci char(25)
1401 NULL test4 t6 f3 date NULL NULL NULL NULL date
1402 NULL test4 t6 f4 int NULL NULL NULL NULL int
1403 1.0000 test4 t6 f5 char 25 25 latin1 latin1_swedish_ci char(25)
1404 NULL test4 t6 f6 int NULL NULL NULL NULL int
1405 SET sql_mode = default;
1406 DROP DATABASE test1;
1407 DROP DATABASE test4;
1408 DROP TABLE test.t1;
1409 DROP TABLE test.t2;
1410 DROP TABLE test.t3;
1411 DROP TABLE test.t4;
1412 DROP TABLE test.t7;
1413 DROP TABLE test.t8;
1414 DROP TABLE test.t9;
1415 DROP TABLE test.t10;
1416 DROP TABLE test.t11;
1417 DROP TABLE test.tb1;
1418 DROP TABLE test.tb2;
1419 DROP TABLE test.tb3;
1420 DROP TABLE test.tb4;