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