~linuxjedi/drizzle/trunk-bug-667053

SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
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 'MYSQL_TEST_DIR/suite/funcs_1/data/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(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 = memory;
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/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 'MYSQL_TEST_DIR/suite/funcs_1/data/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, 
f222 year, 
f223 year(3), 
f224 year(4), 
f225 enum("1enum","2enum"), 
f226 set("1set","2set"),
f236 char(95) unicode,
f241 char(255) unicode,
f237 char(130) binary,
f238 varchar(25000) binary,
f239 varbinary(0),
f240 varchar(1200) unicode
) engine = memory;
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/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(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 = memory;
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/memory_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 = 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 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t1;
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t2;
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t4;
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t10;
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/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 'MYSQL_TEST_DIR/suite/funcs_1/data/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 'MYSQL_TEST_DIR/suite/funcs_1/data/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 'MYSQL_TEST_DIR/suite/funcs_1/data/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 'MYSQL_TEST_DIR/suite/funcs_1/data/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 'MYSQL_TEST_DIR/suite/funcs_1/data/t9.txt' INTO TABLE t9;
DROP DATABASE IF EXISTS db_datadict;
CREATE DATABASE db_datadict;
SELECT *,
LEFT( table_comment,
IF(INSTR(table_comment,'InnoDB free') = 0
AND INSTR(table_comment,'number_of_replicas') = 0,
LENGTH(table_comment),
INSTR(table_comment,'InnoDB free')
+ INSTR(table_comment,'number_of_replicas') - 1))
AS "user_comment",
'-----------------------------------------------------' AS "Separator"
FROM information_schema.tables
WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
ORDER BY table_schema,table_name;
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t1
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t10
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t11
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t2
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t3
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t4
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t7
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t8
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t9
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	tb1
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	tb2
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	tb3
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	tb4
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test1
TABLE_NAME	tb2
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test4
TABLE_NAME	t6
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
DROP   USER testuser1@localhost;
CREATE USER testuser1@localhost;
GRANT SELECT ON db_datadict.* TO testuser1@localhost;
# Establish connection testuser1 (user=testuser1)
SELECT *,
LEFT( table_comment,
IF(INSTR(table_comment,'InnoDB free') = 0
AND INSTR(table_comment,'number_of_replicas') = 0,
LENGTH(table_comment),
INSTR(table_comment,'InnoDB free')
+ INSTR(table_comment,'number_of_replicas') - 1))
AS "user_comment",
'-----------------------------------------------------' AS "Separator"
FROM information_schema.tables
WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
ORDER BY table_schema,table_name;
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t1
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t10
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t11
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t2
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t3
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t4
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t7
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t8
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	t9
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	tb1
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	tb2
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	tb3
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
TABLE_CATALOG	NULL
TABLE_SCHEMA	test
TABLE_NAME	tb4
TABLE_TYPE	BASE TABLE
ENGINE	MEMORY
VERSION	10
ROW_FORMAT	Fixed
TABLE_ROWS	#TBLR#
AVG_ROW_LENGTH	#ARL#
DATA_LENGTH	#DL#
MAX_DATA_LENGTH	#MDL#
INDEX_LENGTH	#IL#
DATA_FREE	#DF#
AUTO_INCREMENT	NULL
CREATE_TIME	#CRT#
UPDATE_TIME	#UT#
CHECK_TIME	#CT#
TABLE_COLLATION	latin1_swedish_ci
CHECKSUM	NULL
CREATE_OPTIONS	#CO#
TABLE_COMMENT	#TC#
user_comment	
Separator	-----------------------------------------------------
# Switch to connection default and close connection testuser1
DROP USER testuser1@localhost;
DROP DATABASE db_datadict;
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;