path: root/mysql-test/suite/funcs_1/r/is_columns_innodb.result

DROP DATABASE IF EXISTS test1;
CREATE DATABASE test1;
USE test;
drop table if exists tb1 ;
create table tb1 (
f1 char(0),
f2 char(0) binary,
f3 char(0) ascii,
f4 tinytext,
f5 text,
f6 mediumtext,
f7 longtext,
f8 tinyblob,
f9 blob,
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,
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
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb1.txt'
into table tb1;
drop table if exists tb2 ;
create table tb2 (
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",
f109 set("1set","2set") not null default "1set"
) engine = innodb;
Warnings:
Note	1287	'YEAR(3)' is deprecated and will be removed in a future release. Please use YEAR(4) instead
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb2.txt'
into table tb2;
drop table if exists tb3 ;
create table tb3 (
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,
f124 longtext,
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)
) 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
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb3.txt'
into table tb3;
drop table if exists tb4;
create table tb4 (
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 NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
f222 year,
f223 year(3),
f224 year(4),
f225 enum("1enum","2enum"),
f226 set("1set","2set"),
f235 char(0),
f236 char(90),
f237 char(255) ascii,
f238 varchar(0),
f239 varchar(20000) binary,
f240 varchar(2000),
f241 char(100)
) engine = innodb;
Warnings:
Note	1287	'YEAR(3)' is deprecated and will be removed in a future release. Please use YEAR(4) instead
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb4.txt'
into table tb4;
USE test1;
drop table if exists tb2 ;
create table tb2 (
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",
f109 set("1set","2set") not null default "1set"
) engine = innodb;
Warnings:
Note	1287	'YEAR(3)' is deprecated and will be removed in a future release. Please use YEAR(4) instead
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb2.txt'
into table tb2;
USE test;
USE test;
DROP TABLE IF EXISTS t1, t2, t4, t10, t11;
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/funcs_1/t4.txt' INTO TABLE t1;
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t2;
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t4;
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t10;
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t11;
drop TABLE if exists t3;
CREATE TABLE t3 (f1 char(20), f2 char(20), f3 integer) ENGINE = InnoDB;
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t3.txt' INTO TABLE t3;
drop database if exists test4;
CREATE database test4;
use test4;
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/funcs_1/t4.txt' INTO TABLE t6;
use test;
drop TABLE if exists t7, t8;
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/funcs_1/t7.txt' INTO TABLE t7;
ERROR 22007: Incorrect date value: '' for column 'f3' at row 1
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t8;
ERROR 22007: Incorrect date value: '' for column 'f3' at row 1
drop TABLE if exists t9;
CREATE TABLE t9 (f1 int, f2 char(25), f3 int) ENGINE = InnoDB;
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t9.txt' INTO TABLE t9;
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	DATETIME_PRECISION	CHARACTER_SET_NAME	COLLATION_NAME	COLUMN_TYPE	COLUMN_KEY	EXTRA	PRIVILEGES	COLUMN_COMMENT
def	test	t1	f1	1	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test	t1	f2	2	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t1	f3	3	NULL	YES	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test	t1	f4	4	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t1	f5	5	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t1	f6	6	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t10	f1	1	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test	t10	f2	2	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t10	f3	3	NULL	YES	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test	t10	f4	4	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t10	f5	5	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t10	f6	6	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t11	f1	1	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test	t11	f2	2	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t11	f3	3	NULL	YES	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test	t11	f4	4	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t11	f5	5	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t11	f6	6	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t2	f1	1	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test	t2	f2	2	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t2	f3	3	NULL	YES	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test	t2	f4	4	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t2	f5	5	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t2	f6	6	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t3	f1	1	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test	t3	f2	2	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test	t3	f3	3	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t4	f1	1	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test	t4	f2	2	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t4	f3	3	NULL	YES	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test	t4	f4	4	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t4	f5	5	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t4	f6	6	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t7	f1	1	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test	t7	f2	2	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t7	f3	3	NULL	YES	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test	t7	f4	4	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t8	f1	1	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test	t8	f2	2	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t8	f3	3	NULL	YES	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test	t8	f4	4	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t9	f1	1	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	t9	f2	2	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test	t9	f3	3	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	tb1	f1	1	NULL	YES	char	0	0	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(0)			select,insert,update,references	
def	test	tb1	f10	10	NULL	YES	mediumblob	16777215	16777215	NULL	NULL	NULL	NULL	NULL	mediumblob			select,insert,update,references	
def	test	tb1	f11	11	NULL	YES	longblob	4294967295	4294967295	NULL	NULL	NULL	NULL	NULL	longblob			select,insert,update,references	
def	test	tb1	f12	12	NULL	YES	binary	1	1	NULL	NULL	NULL	NULL	NULL	binary(1)			select,insert,update,references	
def	test	tb1	f13	13	NULL	YES	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(4)			select,insert,update,references	
def	test	tb1	f14	14	NULL	YES	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned			select,insert,update,references	
def	test	tb1	f15	15	NULL	YES	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned zerofill			select,insert,update,references	
def	test	tb1	f16	16	NULL	YES	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned zerofill			select,insert,update,references	
def	test	tb1	f17	17	NULL	YES	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(6)			select,insert,update,references	
def	test	tb1	f18	18	NULL	YES	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned			select,insert,update,references	
def	test	tb1	f19	19	NULL	YES	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned zerofill			select,insert,update,references	
def	test	tb1	f2	2	NULL	YES	char	0	0	NULL	NULL	NULL	latin1	latin1_bin	char(0)			select,insert,update,references	
def	test	tb1	f20	20	NULL	YES	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned zerofill			select,insert,update,references	
def	test	tb1	f21	21	NULL	YES	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(9)			select,insert,update,references	
def	test	tb1	f22	22	NULL	YES	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned			select,insert,update,references	
def	test	tb1	f23	23	NULL	YES	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned zerofill			select,insert,update,references	
def	test	tb1	f24	24	NULL	YES	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned zerofill			select,insert,update,references	
def	test	tb1	f25	25	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	tb1	f26	26	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned			select,insert,update,references	
def	test	tb1	f27	27	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned zerofill			select,insert,update,references	
def	test	tb1	f28	28	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned zerofill			select,insert,update,references	
def	test	tb1	f29	29	NULL	YES	bigint	NULL	NULL	19	0	NULL	NULL	NULL	bigint(20)			select,insert,update,references	
def	test	tb1	f3	3	NULL	YES	char	0	0	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(0)			select,insert,update,references	
def	test	tb1	f30	30	NULL	YES	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned			select,insert,update,references	
def	test	tb1	f31	31	NULL	YES	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned zerofill			select,insert,update,references	
def	test	tb1	f32	32	NULL	YES	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned zerofill			select,insert,update,references	
def	test	tb1	f33	33	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb1	f34	34	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb1	f35	35	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f36	36	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f37	37	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb1	f38	38	10	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0)			select,insert,update,references	
def	test	tb1	f39	39	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb1	f4	4	NULL	YES	tinytext	255	255	NULL	NULL	NULL	latin1	latin1_swedish_ci	tinytext			select,insert,update,references	
def	test	tb1	f40	40	10	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned			select,insert,update,references	
def	test	tb1	f41	41	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f42	42	0000000000000000000000000000000000000000000000000000000000000010	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f43	43	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f44	44	0000000000000000000000000000000000000000000000000000000000000010	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f45	45	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb1	f46	46	9.900000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30)			select,insert,update,references	
def	test	tb1	f47	47	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb1	f48	48	9.900000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned			select,insert,update,references	
def	test	tb1	f49	49	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f5	5	NULL	YES	text	65535	65535	NULL	NULL	NULL	latin1	latin1_swedish_ci	text			select,insert,update,references	
def	test	tb1	f50	50	000000000000000000000000000000009.900000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test	tb1	f51	51	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f52	52	000000000000000000000000000000009.900000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test	tb1	f53	53	99	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb1	f54	54	99	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb1	f55	55	0000000099	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f56	56	0000000099	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb1	f57	57	99	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb1	f58	58	99	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0)			select,insert,update,references	
def	test	tb1	f6	6	NULL	YES	mediumtext	16777215	16777215	NULL	NULL	NULL	latin1	latin1_swedish_ci	mediumtext			select,insert,update,references	
def	test	tb1	f7	7	NULL	YES	longtext	4294967295	4294967295	NULL	NULL	NULL	latin1	latin1_swedish_ci	longtext			select,insert,update,references	
def	test	tb1	f8	8	NULL	YES	tinyblob	255	255	NULL	NULL	NULL	NULL	NULL	tinyblob			select,insert,update,references	
def	test	tb1	f9	9	NULL	YES	blob	65535	65535	NULL	NULL	NULL	NULL	NULL	blob			select,insert,update,references	
def	test	tb2	f100	42	00000000000000000008.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb2	f101	43	2000-01-01	NO	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test	tb2	f102	44	00:00:20	NO	time	NULL	NULL	NULL	NULL	0	NULL	NULL	time			select,insert,update,references	
def	test	tb2	f103	45	0002-02-02 00:00:00	NO	datetime	NULL	NULL	NULL	NULL	0	NULL	NULL	datetime			select,insert,update,references	
def	test	tb2	f104	46	2000-12-31 23:59:59	NO	timestamp	NULL	NULL	NULL	NULL	0	NULL	NULL	timestamp			select,insert,update,references	
def	test	tb2	f105	47	2000	NO	year	NULL	NULL	NULL	NULL	NULL	NULL	NULL	year(4)			select,insert,update,references	
def	test	tb2	f106	48	2000	NO	year	NULL	NULL	NULL	NULL	NULL	NULL	NULL	year(4)			select,insert,update,references	
def	test	tb2	f107	49	2000	NO	year	NULL	NULL	NULL	NULL	NULL	NULL	NULL	year(4)			select,insert,update,references	
def	test	tb2	f108	50	1enum	NO	enum	5	5	NULL	NULL	NULL	latin1	latin1_swedish_ci	enum('1enum','2enum')			select,insert,update,references	
def	test	tb2	f109	51	1set	NO	set	9	9	NULL	NULL	NULL	latin1	latin1_swedish_ci	set('1set','2set')			select,insert,update,references	
def	test	tb2	f59	1	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb2	f60	2	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned			select,insert,update,references	
def	test	tb2	f61	3	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb2	f62	4	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test	tb2	f63	5	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb2	f64	6	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test	tb2	f65	7	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb2	f66	8	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30)			select,insert,update,references	
def	test	tb2	f67	9	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb2	f68	10	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned			select,insert,update,references	
def	test	tb2	f69	11	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb2	f70	12	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test	tb2	f71	13	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb2	f72	14	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test	tb2	f73	15	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double			select,insert,update,references	
def	test	tb2	f74	16	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned			select,insert,update,references	
def	test	tb2	f75	17	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb2	f76	18	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb2	f77	19	7.7	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double			select,insert,update,references	
def	test	tb2	f78	20	7.7	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned			select,insert,update,references	
def	test	tb2	f79	21	00000000000000000007.7	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb2	f80	22	00000000000000000008.8	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb2	f81	23	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test	tb2	f82	24	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test	tb2	f83	25	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb2	f84	26	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb2	f85	27	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test	tb2	f86	28	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test	tb2	f87	29	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test	tb2	f88	30	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test	tb2	f89	31	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb2	f90	32	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb2	f91	33	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb2	f92	34	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb2	f93	35	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test	tb2	f94	36	8.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double			select,insert,update,references	
def	test	tb2	f95	37	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test	tb2	f96	38	8.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned			select,insert,update,references	
def	test	tb2	f97	39	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb2	f98	40	00000000000000000008.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb2	f99	41	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb3	f118	1	a	NO	char	1	1	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(1)			select,insert,update,references	
def	test	tb3	f119	2		NO	char	1	1	NULL	NULL	NULL	latin1	latin1_bin	char(1)			select,insert,update,references	
def	test	tb3	f120	3		NO	char	1	1	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(1)			select,insert,update,references	
def	test	tb3	f121	4	NULL	YES	tinytext	255	255	NULL	NULL	NULL	latin1	latin1_swedish_ci	tinytext			select,insert,update,references	
def	test	tb3	f122	5	NULL	YES	text	65535	65535	NULL	NULL	NULL	latin1	latin1_swedish_ci	text			select,insert,update,references	
def	test	tb3	f123	6	NULL	YES	mediumtext	16777215	16777215	NULL	NULL	NULL	latin1	latin1_swedish_ci	mediumtext			select,insert,update,references	
def	test	tb3	f124	7	NULL	YES	longtext	4294967295	4294967295	NULL	NULL	NULL	latin1	latin1_swedish_ci	longtext			select,insert,update,references	
def	test	tb3	f125	8	NULL	YES	tinyblob	255	255	NULL	NULL	NULL	NULL	NULL	tinyblob			select,insert,update,references	
def	test	tb3	f126	9	NULL	YES	blob	65535	65535	NULL	NULL	NULL	NULL	NULL	blob			select,insert,update,references	
def	test	tb3	f127	10	NULL	YES	mediumblob	16777215	16777215	NULL	NULL	NULL	NULL	NULL	mediumblob			select,insert,update,references	
def	test	tb3	f128	11	NULL	YES	longblob	4294967295	4294967295	NULL	NULL	NULL	NULL	NULL	longblob			select,insert,update,references	
def	test	tb3	f129	12		NO	binary	1	1	NULL	NULL	NULL	NULL	NULL	binary(1)			select,insert,update,references	
def	test	tb3	f130	13	99	NO	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(4)			select,insert,update,references	
def	test	tb3	f131	14	99	NO	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned			select,insert,update,references	
def	test	tb3	f132	15	099	NO	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned zerofill			select,insert,update,references	
def	test	tb3	f133	16	099	NO	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned zerofill			select,insert,update,references	
def	test	tb3	f134	17	999	NO	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(6)			select,insert,update,references	
def	test	tb3	f135	18	999	NO	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned			select,insert,update,references	
def	test	tb3	f136	19	00999	NO	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned zerofill			select,insert,update,references	
def	test	tb3	f137	20	00999	NO	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned zerofill			select,insert,update,references	
def	test	tb3	f138	21	9999	NO	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(9)			select,insert,update,references	
def	test	tb3	f139	22	9999	NO	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned			select,insert,update,references	
def	test	tb3	f140	23	00009999	NO	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned zerofill			select,insert,update,references	
def	test	tb3	f141	24	00009999	NO	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned zerofill			select,insert,update,references	
def	test	tb3	f142	25	99999	NO	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test	tb3	f143	26	99999	NO	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned			select,insert,update,references	
def	test	tb3	f144	27	0000099999	NO	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned zerofill			select,insert,update,references	
def	test	tb3	f145	28	0000099999	NO	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned zerofill			select,insert,update,references	
def	test	tb3	f146	29	999999	NO	bigint	NULL	NULL	19	0	NULL	NULL	NULL	bigint(20)			select,insert,update,references	
def	test	tb3	f147	30	999999	NO	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned			select,insert,update,references	
def	test	tb3	f148	31	00000000000000999999	NO	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned zerofill			select,insert,update,references	
def	test	tb3	f149	32	00000000000000999999	NO	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned zerofill			select,insert,update,references	
def	test	tb3	f150	33	1000	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb3	f151	34	999	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb3	f152	35	0000001000	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f153	36	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f154	37	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb3	f155	38	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0)			select,insert,update,references	
def	test	tb3	f156	39	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb3	f157	40	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned			select,insert,update,references	
def	test	tb3	f158	41	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f159	42	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f160	43	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f161	44	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f162	45	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb3	f163	46	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30)			select,insert,update,references	
def	test	tb3	f164	47	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb3	f165	48	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned			select,insert,update,references	
def	test	tb3	f166	49	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f167	50	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test	tb3	f168	51	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f169	52	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test	tb3	f170	53	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb3	f171	54	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb3	f172	55	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f173	56	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb3	f174	57	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb3	f175	58	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0)			select,insert,update,references	
def	test	tb4	f176	1	9	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb4	f177	2	9	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned			select,insert,update,references	
def	test	tb4	f178	3	0000000009	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb4	f179	4	0000000000000000000000000000000000000000000000000000000000000009	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test	tb4	f180	5	0000000009	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb4	f181	6	0000000000000000000000000000000000000000000000000000000000000009	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test	tb4	f182	7	9	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test	tb4	f183	8	9.000000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30)			select,insert,update,references	
def	test	tb4	f184	9	9	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test	tb4	f185	10	9.000000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned			select,insert,update,references	
def	test	tb4	f186	11	0000000009	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb4	f187	12	000000000000000000000000000000009.000000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test	tb4	f188	13	0000000009	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test	tb4	f189	14	000000000000000000000000000000009.000000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test	tb4	f190	15	88.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double			select,insert,update,references	
def	test	tb4	f191	16	88.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned			select,insert,update,references	
def	test	tb4	f192	17	00000000000000000088.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb4	f193	18	00000000000000000088.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb4	f194	19	55.5	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double			select,insert,update,references	
def	test	tb4	f195	20	55.5	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned			select,insert,update,references	
def	test	tb4	f196	21	00000000000000000055.5	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb4	f197	22	00000000000000000055.5	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb4	f198	23	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test	tb4	f199	24	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test	tb4	f200	25	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb4	f201	26	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb4	f202	27	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test	tb4	f203	28	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test	tb4	f204	29	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test	tb4	f205	30	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test	tb4	f206	31	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb4	f207	32	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb4	f208	33	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb4	f209	34	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb4	f210	35	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test	tb4	f211	36	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double			select,insert,update,references	
def	test	tb4	f212	37	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test	tb4	f213	38	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned			select,insert,update,references	
def	test	tb4	f214	39	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb4	f215	40	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb4	f216	41	NULL	YES	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test	tb4	f217	42	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test	tb4	f218	43	NULL	YES	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test	tb4	f219	44	NULL	YES	time	NULL	NULL	NULL	NULL	0	NULL	NULL	time			select,insert,update,references	
def	test	tb4	f220	45	NULL	YES	datetime	NULL	NULL	NULL	NULL	0	NULL	NULL	datetime			select,insert,update,references	
def	test	tb4	f221	46	current_timestamp()	NO	timestamp	NULL	NULL	NULL	NULL	0	NULL	NULL	timestamp		on update current_timestamp()	select,insert,update,references	
def	test	tb4	f222	47	NULL	YES	year	NULL	NULL	NULL	NULL	NULL	NULL	NULL	year(4)			select,insert,update,references	
def	test	tb4	f223	48	NULL	YES	year	NULL	NULL	NULL	NULL	NULL	NULL	NULL	year(4)			select,insert,update,references	
def	test	tb4	f224	49	NULL	YES	year	NULL	NULL	NULL	NULL	NULL	NULL	NULL	year(4)			select,insert,update,references	
def	test	tb4	f225	50	NULL	YES	enum	5	5	NULL	NULL	NULL	latin1	latin1_swedish_ci	enum('1enum','2enum')			select,insert,update,references	
def	test	tb4	f226	51	NULL	YES	set	9	9	NULL	NULL	NULL	latin1	latin1_swedish_ci	set('1set','2set')			select,insert,update,references	
def	test	tb4	f235	52	NULL	YES	char	0	0	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(0)			select,insert,update,references	
def	test	tb4	f236	53	NULL	YES	char	90	90	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(90)			select,insert,update,references	
def	test	tb4	f237	54	NULL	YES	char	255	255	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(255)			select,insert,update,references	
def	test	tb4	f238	55	NULL	YES	varchar	0	0	NULL	NULL	NULL	latin1	latin1_swedish_ci	varchar(0)			select,insert,update,references	
def	test	tb4	f239	56	NULL	YES	varchar	20000	20000	NULL	NULL	NULL	latin1	latin1_bin	varchar(20000)			select,insert,update,references	
def	test	tb4	f240	57	NULL	YES	varchar	2000	2000	NULL	NULL	NULL	latin1	latin1_swedish_ci	varchar(2000)			select,insert,update,references	
def	test	tb4	f241	58	NULL	YES	char	100	100	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(100)			select,insert,update,references	
def	test1	tb2	f100	42	00000000000000000008.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test1	tb2	f101	43	2000-01-01	NO	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test1	tb2	f102	44	00:00:20	NO	time	NULL	NULL	NULL	NULL	0	NULL	NULL	time			select,insert,update,references	
def	test1	tb2	f103	45	0002-02-02 00:00:00	NO	datetime	NULL	NULL	NULL	NULL	0	NULL	NULL	datetime			select,insert,update,references	
def	test1	tb2	f104	46	2000-12-31 23:59:59	NO	timestamp	NULL	NULL	NULL	NULL	0	NULL	NULL	timestamp			select,insert,update,references	
def	test1	tb2	f105	47	2000	NO	year	NULL	NULL	NULL	NULL	NULL	NULL	NULL	year(4)			select,insert,update,references	
def	test1	tb2	f106	48	2000	NO	year	NULL	NULL	NULL	NULL	NULL	NULL	NULL	year(4)			select,insert,update,references	
def	test1	tb2	f107	49	2000	NO	year	NULL	NULL	NULL	NULL	NULL	NULL	NULL	year(4)			select,insert,update,references	
def	test1	tb2	f108	50	1enum	NO	enum	5	5	NULL	NULL	NULL	latin1	latin1_swedish_ci	enum('1enum','2enum')			select,insert,update,references	
def	test1	tb2	f109	51	1set	NO	set	9	9	NULL	NULL	NULL	latin1	latin1_swedish_ci	set('1set','2set')			select,insert,update,references	
def	test1	tb2	f59	1	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test1	tb2	f60	2	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned			select,insert,update,references	
def	test1	tb2	f61	3	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test1	tb2	f62	4	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test1	tb2	f63	5	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test1	tb2	f64	6	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references	
def	test1	tb2	f65	7	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references	
def	test1	tb2	f66	8	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30)			select,insert,update,references	
def	test1	tb2	f67	9	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references	
def	test1	tb2	f68	10	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned			select,insert,update,references	
def	test1	tb2	f69	11	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test1	tb2	f70	12	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test1	tb2	f71	13	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references	
def	test1	tb2	f72	14	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references	
def	test1	tb2	f73	15	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double			select,insert,update,references	
def	test1	tb2	f74	16	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned			select,insert,update,references	
def	test1	tb2	f75	17	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test1	tb2	f76	18	NULL	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test1	tb2	f77	19	7.7	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double			select,insert,update,references	
def	test1	tb2	f78	20	7.7	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned			select,insert,update,references	
def	test1	tb2	f79	21	00000000000000000007.7	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test1	tb2	f80	22	00000000000000000008.8	YES	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test1	tb2	f81	23	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test1	tb2	f82	24	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test1	tb2	f83	25	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test1	tb2	f84	26	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test1	tb2	f85	27	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test1	tb2	f86	28	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test1	tb2	f87	29	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test1	tb2	f88	30	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test1	tb2	f89	31	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test1	tb2	f90	32	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test1	tb2	f91	33	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test1	tb2	f92	34	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test1	tb2	f93	35	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float			select,insert,update,references	
def	test1	tb2	f94	36	8.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double			select,insert,update,references	
def	test1	tb2	f95	37	8.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned			select,insert,update,references	
def	test1	tb2	f96	38	8.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned			select,insert,update,references	
def	test1	tb2	f97	39	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test1	tb2	f98	40	00000000000000000008.8	NO	double	NULL	NULL	22	NULL	NULL	NULL	NULL	double unsigned zerofill			select,insert,update,references	
def	test1	tb2	f99	41	0000000008.8	NO	float	NULL	NULL	12	NULL	NULL	NULL	NULL	float unsigned zerofill			select,insert,update,references	
def	test4	t6	f1	1	NULL	YES	char	20	20	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(20)			select,insert,update,references	
def	test4	t6	f2	2	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test4	t6	f3	3	NULL	YES	date	NULL	NULL	NULL	NULL	NULL	NULL	NULL	date			select,insert,update,references	
def	test4	t6	f4	4	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references	
def	test4	t6	f5	5	NULL	YES	char	25	25	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(25)			select,insert,update,references	
def	test4	t6	f6	6	NULL	YES	int	NULL	NULL	10	0	NULL	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
1.0000	varchar	latin1	latin1_swedish_ci
Warnings:
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
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
Warnings:
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
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	float	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
Warnings:
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
--> 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)
1.0000	test	tb1	f4	tinytext	255	255	latin1	latin1_swedish_ci	tinytext
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	NULL	NULL	NULL	NULL	double unsigned
NULL	test	tb2	f75	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb2	f76	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb2	f77	double	NULL	NULL	NULL	NULL	double
NULL	test	tb2	f78	double	NULL	NULL	NULL	NULL	double unsigned
NULL	test	tb2	f79	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb2	f80	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb2	f81	float	NULL	NULL	NULL	NULL	float
NULL	test	tb2	f82	float	NULL	NULL	NULL	NULL	float unsigned
NULL	test	tb2	f83	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb2	f84	float	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	NULL	NULL	NULL	NULL	float unsigned
NULL	test	tb2	f88	float	NULL	NULL	NULL	NULL	float unsigned
NULL	test	tb2	f89	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb2	f90	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb2	f91	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb2	f92	float	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	NULL	NULL	NULL	NULL	float unsigned
NULL	test	tb2	f96	double	NULL	NULL	NULL	NULL	double unsigned
NULL	test	tb2	f97	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb2	f98	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb2	f99	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb2	f100	double	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
1.0000	test	tb3	f124	longtext	4294967295	4294967295	latin1	latin1_swedish_ci	longtext
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	NULL	NULL	NULL	NULL	double unsigned
NULL	test	tb4	f192	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb4	f193	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb4	f194	double	NULL	NULL	NULL	NULL	double
NULL	test	tb4	f195	double	NULL	NULL	NULL	NULL	double unsigned
NULL	test	tb4	f196	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb4	f197	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb4	f198	float	NULL	NULL	NULL	NULL	float
NULL	test	tb4	f199	float	NULL	NULL	NULL	NULL	float unsigned
NULL	test	tb4	f200	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb4	f201	float	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	NULL	NULL	NULL	NULL	float unsigned
NULL	test	tb4	f205	float	NULL	NULL	NULL	NULL	float unsigned
NULL	test	tb4	f206	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb4	f207	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb4	f208	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb4	f209	float	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	NULL	NULL	NULL	NULL	float unsigned
NULL	test	tb4	f213	double	NULL	NULL	NULL	NULL	double unsigned
NULL	test	tb4	f214	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb4	f215	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test	tb4	f216	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test	tb4	f217	double	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')
NULL	test	tb4	f235	char	0	0	latin1	latin1_swedish_ci	char(0)
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)
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)
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	NULL	NULL	NULL	NULL	double unsigned
NULL	test1	tb2	f75	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test1	tb2	f76	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test1	tb2	f77	double	NULL	NULL	NULL	NULL	double
NULL	test1	tb2	f78	double	NULL	NULL	NULL	NULL	double unsigned
NULL	test1	tb2	f79	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test1	tb2	f80	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test1	tb2	f81	float	NULL	NULL	NULL	NULL	float
NULL	test1	tb2	f82	float	NULL	NULL	NULL	NULL	float unsigned
NULL	test1	tb2	f83	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test1	tb2	f84	float	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	NULL	NULL	NULL	NULL	float unsigned
NULL	test1	tb2	f88	float	NULL	NULL	NULL	NULL	float unsigned
NULL	test1	tb2	f89	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test1	tb2	f90	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test1	tb2	f91	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test1	tb2	f92	float	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	NULL	NULL	NULL	NULL	float unsigned
NULL	test1	tb2	f96	double	NULL	NULL	NULL	NULL	double unsigned
NULL	test1	tb2	f97	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test1	tb2	f98	double	NULL	NULL	NULL	NULL	double unsigned zerofill
NULL	test1	tb2	f99	float	NULL	NULL	NULL	NULL	float unsigned zerofill
NULL	test1	tb2	f100	double	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)
Warnings:
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
Warning	1365	Division by 0
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;