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