Debian Codegraph @

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

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