Gecko [ www.jdcpatala.org ]

Name	Size	Permission
charset_collation.result	1.31 KB	-rw-r--r--
innodb_bitdata.result	117 B	-rw-r--r--
innodb_cursors.result	116 B	-rw-r--r--
innodb_func_view.result	309.26 KB	-rw-r--r--
innodb_storedproc_02.result	36.35 KB	-rw-r--r--
innodb_storedproc_03.result	15.48 KB	-rw-r--r--
innodb_storedproc_06.result	14.62 KB	-rw-r--r--
innodb_storedproc_07.result	8.36 KB	-rw-r--r--
innodb_storedproc_08.result	25.53 KB	-rw-r--r--
innodb_storedproc_10.result	13.39 KB	-rw-r--r--
innodb_trig_0102.result	15.08 KB	-rw-r--r--
innodb_trig_03.result	24.65 KB	-rw-r--r--
innodb_trig_03e.result	48.78 KB	-rw-r--r--
innodb_trig_0407.result	10.07 KB	-rw-r--r--
innodb_trig_08.result	18.46 KB	-rw-r--r--
innodb_trig_09.result	9.98 KB	-rw-r--r--
innodb_trig_1011ext.result	12.04 KB	-rw-r--r--
innodb_trig_frkey.result	2.23 KB	-rw-r--r--
innodb_views.result	588.04 KB	-rw-r--r--
is_basics_mixed.result	30.21 KB	-rw-r--r--
is_character_sets.result	3.96 KB	-rw-r--r--
is_cml_innodb.result	4.97 KB	-rw-r--r--
is_cml_memory.result	3.94 KB	-rw-r--r--
is_cml_myisam.result	4.97 KB	-rw-r--r--
is_coll_char_set_appl.result	4.34 KB	-rw-r--r--
is_collations.result	4.43 KB	-rw-r--r--
is_column_privileges.result	19.15 KB	-rw-r--r--
is_column_privileges_is_mysql_...	1.44 KB	-rw-r--r--
is_columns.result	20.71 KB	-rw-r--r--
is_columns_innodb.result	78.28 KB	-rw-r--r--
is_columns_is.result	77.55 KB	-rw-r--r--
is_columns_is_embedded.result	75.57 KB	-rw-r--r--
is_columns_memory.result	75.05 KB	-rw-r--r--
is_columns_myisam.result	83.51 KB	-rw-r--r--
is_columns_myisam_embedded.res...	72.89 KB	-rw-r--r--
is_columns_mysql.result	67.25 KB	-rw-r--r--
is_columns_mysql_embedded.resu...	58.59 KB	-rw-r--r--
is_engines.result	3.88 KB	-rw-r--r--
is_engines_archive.result	161 B	-rw-r--r--
is_engines_blackhole.result	205 B	-rw-r--r--
is_engines_csv.result	149 B	-rw-r--r--
is_engines_federated.result	173 B	-rw-r--r--
is_engines_innodb.result	202 B	-rw-r--r--
is_engines_memory.result	194 B	-rw-r--r--
is_engines_merge.result	182 B	-rw-r--r--
is_engines_myisam.result	158 B	-rw-r--r--
is_events.result	6.38 KB	-rw-r--r--
is_key_column_usage.result	20.01 KB	-rw-r--r--
is_key_column_usage_embedded.r...	16.94 KB	-rw-r--r--
is_routines.result	27.73 KB	-rw-r--r--
is_routines_embedded.result	23.94 KB	-rw-r--r--
is_schema_privileges.result	15.56 KB	-rw-r--r--
is_schema_privileges_is_mysql_...	1.84 KB	-rw-r--r--
is_schemata.result	8.67 KB	-rw-r--r--
is_schemata_embedded.result	8.75 KB	-rw-r--r--
is_schemata_is_mysql_test.resu...	1.59 KB	-rw-r--r--
is_statistics.result	20.12 KB	-rw-r--r--
is_statistics_is.result	1.01 KB	-rw-r--r--
is_statistics_mysql.result	6.23 KB	-rw-r--r--
is_statistics_mysql_embedded.r...	11.47 KB	-rw-r--r--
is_table_constraints.result	15.57 KB	-rw-r--r--
is_table_constraints_is.result	828 B	-rw-r--r--
is_table_constraints_mysql.res...	2.3 KB	-rw-r--r--
is_table_constraints_mysql_emb...	3.81 KB	-rw-r--r--
is_table_privileges.result	15.08 KB	-rw-r--r--
is_tables.result	17.27 KB	-rw-r--r--
is_tables_embedded.result	17.48 KB	-rw-r--r--
is_tables_innodb.result	4.07 KB	-rw-r--r--
is_tables_is.result	30.01 KB	-rw-r--r--
is_tables_memory.result	4.17 KB	-rw-r--r--
is_tables_myisam.result	4.23 KB	-rw-r--r--
is_tables_myisam_embedded.resu...	4.63 KB	-rw-r--r--
is_tables_mysql.result	16.11 KB	-rw-r--r--
is_tables_mysql_embedded.resul...	31.05 KB	-rw-r--r--
is_triggers.result	15.87 KB	-rw-r--r--
is_triggers_embedded.result	11.97 KB	-rw-r--r--
is_user_privileges.result	41.08 KB	-rw-r--r--
is_views.result	14.67 KB	-rw-r--r--
is_views_embedded.result	10.98 KB	-rw-r--r--
memory_bitdata.result	286 B	-rw-r--r--
memory_cursors.result	285 B	-rw-r--r--
memory_func_view.result	309.31 KB	-rw-r--r--
memory_storedproc_02.result	36.4 KB	-rw-r--r--
memory_storedproc_03.result	15.53 KB	-rw-r--r--
memory_storedproc_06.result	14.67 KB	-rw-r--r--
memory_storedproc_07.result	8.41 KB	-rw-r--r--
memory_storedproc_08.result	25.58 KB	-rw-r--r--
memory_storedproc_10.result	13.44 KB	-rw-r--r--
memory_trig_0102.result	15.25 KB	-rw-r--r--
memory_trig_03.result	24.47 KB	-rw-r--r--
memory_trig_03e.result	47.41 KB	-rw-r--r--
memory_trig_0407.result	10.23 KB	-rw-r--r--
memory_trig_08.result	18.51 KB	-rw-r--r--
memory_trig_09.result	10.14 KB	-rw-r--r--
memory_trig_1011ext.result	12.11 KB	-rw-r--r--
memory_views.result	588.33 KB	-rw-r--r--
myisam_bitdata.result	286 B	-rw-r--r--
myisam_cursors.result	285 B	-rw-r--r--
myisam_func_view.result	309.31 KB	-rw-r--r--
myisam_storedproc_02.result	36.4 KB	-rw-r--r--
myisam_storedproc_03.result	15.53 KB	-rw-r--r--
myisam_storedproc_06.result	14.67 KB	-rw-r--r--
myisam_storedproc_07.result	8.41 KB	-rw-r--r--
myisam_storedproc_08.result	25.58 KB	-rw-r--r--
myisam_storedproc_10.result	13.44 KB	-rw-r--r--
myisam_trig_0102.result	15.25 KB	-rw-r--r--
myisam_trig_03.result	24.47 KB	-rw-r--r--
myisam_trig_03e.result	47.41 KB	-rw-r--r--
myisam_trig_0407.result	10.23 KB	-rw-r--r--
myisam_trig_08.result	18.51 KB	-rw-r--r--
myisam_trig_09.result	10.14 KB	-rw-r--r--
myisam_trig_1011ext.result	12.11 KB	-rw-r--r--
myisam_views-big.result	603.32 KB	-rw-r--r--
processlist_priv_no_prot.resul...	28.91 KB	-rw-r--r--
processlist_priv_ps.result	28.94 KB	-rw-r--r--
processlist_val_no_prot.result	91.97 KB	-rw-r--r--
processlist_val_ps.result	91.98 KB	-rw-r--r--
row_count_func.result	1.4 KB	-rw-r--r--
storedproc.result	893.84 KB	-rw-r--r--

Code Editor : is_columns_memory.result

SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
DROP DATABASE IF EXISTS test1;
CREATE DATABASE test1;
USE test;
drop table if exists tb1 ;
create table tb1 (
f1 char,
f2 char binary,
f3 char ascii,
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 not null DEFAULT 9.9,
f34 decimal unsigned not null DEFAULT 9.9,
f35 decimal zerofill not null DEFAULT 9.9,
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 = memory;
Warnings:
Note	1265	Data truncated for column 'f33' at row 1
Note	1265	Data truncated for column 'f34' at row 1
Note	1265	Data truncated for column 'f35' at row 1
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/memory_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(4) 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 = memory;
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/memory_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 char(50),
f122 char(50),
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 = memory;
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/memory_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(4),
f224 year(4),
f225 enum("1enum","2enum"),
f226 set("1set","2set"),
f236 char(95),
f241 char(255),
f237 char(130) binary,
f238 varchar(25000) binary,
f239 varbinary(0),
f240 varchar(1200)
) engine = memory;
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/memory_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(4) 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 = memory;
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/memory_tb2.txt'
into table tb2 ;
USE test;
SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
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 = MEMORY;
CREATE TABLE t2  (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
ENGINE = MEMORY;
CREATE TABLE t4  (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
ENGINE = MEMORY;
CREATE TABLE t10 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
ENGINE = MEMORY;
CREATE TABLE t11 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
ENGINE = MEMORY;
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 = MEMORY;
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 = MEMORY;
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 = MEMORY;
CREATE TABLE t8 (f1 char(20),f2 char(25),f3 date,f4 int) ENGINE = MEMORY;
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t7;
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
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t8;
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 = MEMORY;
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t9.txt' INTO TABLE t9;
SET sql_mode = default;
SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
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	GENERATION_EXPRESSION
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	1	1	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(1)			select,insert,update,references		
def	test	tb1	f12	4	NULL	YES	binary	1	1	NULL	NULL	NULL	NULL	NULL	binary(1)			select,insert,update,references		
def	test	tb1	f13	5	NULL	YES	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(4)			select,insert,update,references		
def	test	tb1	f14	6	NULL	YES	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned			select,insert,update,references		
def	test	tb1	f15	7	NULL	YES	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned zerofill			select,insert,update,references		
def	test	tb1	f16	8	NULL	YES	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned zerofill			select,insert,update,references		
def	test	tb1	f17	9	NULL	YES	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(6)			select,insert,update,references		
def	test	tb1	f18	10	NULL	YES	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned			select,insert,update,references		
def	test	tb1	f19	11	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	1	1	NULL	NULL	NULL	latin1	latin1_bin	char(1)			select,insert,update,references		
def	test	tb1	f20	12	NULL	YES	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned zerofill			select,insert,update,references		
def	test	tb1	f21	13	NULL	YES	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(9)			select,insert,update,references		
def	test	tb1	f22	14	NULL	YES	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned			select,insert,update,references		
def	test	tb1	f23	15	NULL	YES	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned zerofill			select,insert,update,references		
def	test	tb1	f24	16	NULL	YES	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned zerofill			select,insert,update,references		
def	test	tb1	f25	17	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references		
def	test	tb1	f26	18	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned			select,insert,update,references		
def	test	tb1	f27	19	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned zerofill			select,insert,update,references		
def	test	tb1	f28	20	NULL	YES	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned zerofill			select,insert,update,references		
def	test	tb1	f29	21	NULL	YES	bigint	NULL	NULL	19	0	NULL	NULL	NULL	bigint(20)			select,insert,update,references		
def	test	tb1	f3	3	NULL	YES	char	1	1	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(1)			select,insert,update,references		
def	test	tb1	f30	22	NULL	YES	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned			select,insert,update,references		
def	test	tb1	f31	23	NULL	YES	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned zerofill			select,insert,update,references		
def	test	tb1	f32	24	NULL	YES	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned zerofill			select,insert,update,references		
def	test	tb1	f33	25	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb1	f34	26	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references		
def	test	tb1	f35	27	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f36	28	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f37	29	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb1	f38	30	10	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0)			select,insert,update,references		
def	test	tb1	f39	31	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references		
def	test	tb1	f40	32	10	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned			select,insert,update,references		
def	test	tb1	f41	33	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f42	34	0000000000000000000000000000000000000000000000000000000000000010	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f43	35	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f44	36	0000000000000000000000000000000000000000000000000000000000000010	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f45	37	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb1	f46	38	9.900000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30)			select,insert,update,references		
def	test	tb1	f47	39	10	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references		
def	test	tb1	f48	40	9.900000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned			select,insert,update,references		
def	test	tb1	f49	41	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f50	42	000000000000000000000000000000009.900000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references		
def	test	tb1	f51	43	0000000010	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f52	44	000000000000000000000000000000009.900000000000000000000000000000	NO	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references		
def	test	tb1	f53	45	99	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb1	f54	46	99	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references		
def	test	tb1	f55	47	0000000099	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f56	48	0000000099	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb1	f57	49	99	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb1	f58	50	99	NO	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0)			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	char	50	50	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(50)			select,insert,update,references		
def	test	tb3	f122	5	NULL	YES	char	50	50	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(50)			select,insert,update,references		
def	test	tb3	f129	6		NO	binary	1	1	NULL	NULL	NULL	NULL	NULL	binary(1)			select,insert,update,references		
def	test	tb3	f130	7	99	NO	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(4)			select,insert,update,references		
def	test	tb3	f131	8	99	NO	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned			select,insert,update,references		
def	test	tb3	f132	9	099	NO	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned zerofill			select,insert,update,references		
def	test	tb3	f133	10	099	NO	tinyint	NULL	NULL	3	0	NULL	NULL	NULL	tinyint(3) unsigned zerofill			select,insert,update,references		
def	test	tb3	f134	11	999	NO	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(6)			select,insert,update,references		
def	test	tb3	f135	12	999	NO	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned			select,insert,update,references		
def	test	tb3	f136	13	00999	NO	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned zerofill			select,insert,update,references		
def	test	tb3	f137	14	00999	NO	smallint	NULL	NULL	5	0	NULL	NULL	NULL	smallint(5) unsigned zerofill			select,insert,update,references		
def	test	tb3	f138	15	9999	NO	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(9)			select,insert,update,references		
def	test	tb3	f139	16	9999	NO	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned			select,insert,update,references		
def	test	tb3	f140	17	00009999	NO	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned zerofill			select,insert,update,references		
def	test	tb3	f141	18	00009999	NO	mediumint	NULL	NULL	7	0	NULL	NULL	NULL	mediumint(8) unsigned zerofill			select,insert,update,references		
def	test	tb3	f142	19	99999	NO	int	NULL	NULL	10	0	NULL	NULL	NULL	int(11)			select,insert,update,references		
def	test	tb3	f143	20	99999	NO	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned			select,insert,update,references		
def	test	tb3	f144	21	0000099999	NO	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned zerofill			select,insert,update,references		
def	test	tb3	f145	22	0000099999	NO	int	NULL	NULL	10	0	NULL	NULL	NULL	int(10) unsigned zerofill			select,insert,update,references		
def	test	tb3	f146	23	999999	NO	bigint	NULL	NULL	19	0	NULL	NULL	NULL	bigint(20)			select,insert,update,references		
def	test	tb3	f147	24	999999	NO	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned			select,insert,update,references		
def	test	tb3	f148	25	00000000000000999999	NO	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned zerofill			select,insert,update,references		
def	test	tb3	f149	26	00000000000000999999	NO	bigint	NULL	NULL	20	0	NULL	NULL	NULL	bigint(20) unsigned zerofill			select,insert,update,references		
def	test	tb3	f150	27	1000	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb3	f151	28	999	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references		
def	test	tb3	f152	29	0000001000	NO	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f153	30	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f154	31	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb3	f155	32	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0)			select,insert,update,references		
def	test	tb3	f156	33	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references		
def	test	tb3	f157	34	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned			select,insert,update,references		
def	test	tb3	f158	35	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f159	36	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f160	37	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f161	38	NULL	YES	decimal	NULL	NULL	64	0	NULL	NULL	NULL	decimal(64,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f162	39	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb3	f163	40	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30)			select,insert,update,references		
def	test	tb3	f164	41	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references		
def	test	tb3	f165	42	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned			select,insert,update,references		
def	test	tb3	f166	43	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f167	44	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references		
def	test	tb3	f168	45	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f169	46	NULL	YES	decimal	NULL	NULL	63	30	NULL	NULL	NULL	decimal(63,30) unsigned zerofill			select,insert,update,references		
def	test	tb3	f170	47	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb3	f171	48	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned			select,insert,update,references		
def	test	tb3	f172	49	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f173	50	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0) unsigned zerofill			select,insert,update,references		
def	test	tb3	f174	51	NULL	YES	decimal	NULL	NULL	10	0	NULL	NULL	NULL	decimal(10,0)			select,insert,update,references		
def	test	tb3	f175	52	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	f236	52	NULL	YES	char	95	95	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(95)			select,insert,update,references		
def	test	tb4	f237	54	NULL	YES	char	130	130	NULL	NULL	NULL	latin1	latin1_bin	char(130)			select,insert,update,references		
def	test	tb4	f238	55	NULL	YES	varchar	25000	25000	NULL	NULL	NULL	latin1	latin1_bin	varchar(25000)			select,insert,update,references		
def	test	tb4	f239	56	NULL	YES	varbinary	0	0	NULL	NULL	NULL	NULL	NULL	varbinary(0)			select,insert,update,references		
def	test	tb4	f240	57	NULL	YES	varchar	1200	1200	NULL	NULL	NULL	latin1	latin1_swedish_ci	varchar(1200)			select,insert,update,references		
def	test	tb4	f241	53	NULL	YES	char	255	255	NULL	NULL	NULL	latin1	latin1_swedish_ci	char(255)			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	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	set	latin1	latin1_swedish_ci
1.0000	varchar	latin1	latin1_swedish_ci
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	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	varbinary	NULL	NULL
NULL	year	NULL	NULL
--> 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)
1.0000	test	tb1	f1	char	1	1	latin1	latin1_swedish_ci	char(1)
1.0000	test	tb1	f2	char	1	1	latin1	latin1_bin	char(1)
1.0000	test	tb1	f3	char	1	1	latin1	latin1_swedish_ci	char(1)
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	char	50	50	latin1	latin1_swedish_ci	char(50)
1.0000	test	tb3	f122	char	50	50	latin1	latin1_swedish_ci	char(50)
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')
1.0000	test	tb4	f236	char	95	95	latin1	latin1_swedish_ci	char(95)
1.0000	test	tb4	f241	char	255	255	latin1	latin1_swedish_ci	char(255)
1.0000	test	tb4	f237	char	130	130	latin1	latin1_bin	char(130)
1.0000	test	tb4	f238	varchar	25000	25000	latin1	latin1_bin	varchar(25000)
NULL	test	tb4	f239	varbinary	0	0	NULL	NULL	varbinary(0)
1.0000	test	tb4	f240	varchar	1200	1200	latin1	latin1_swedish_ci	varchar(1200)
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)
SET sql_mode = default;
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;

${this.title}

Code Editor : is_columns_memory.result