Debian Codegraph @

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

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