Debian Codegraph @

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