i|1|set global query_cache_size=10*1024*1024|
q|1|set global query_cache_size=10*1024*1024|
i|1|set global query_cache_type=1|
i|1|set global max_allowed_packet=1024*1024*1024|
#i|1|set global concurrent_insert=0|
i|1|/*!41000 set global innodb_flush_log_at_trx_commit=0*/|

#############CHAR#######################
i|10|drop table if exists `qa00`|
i|1|create table `qa00` ( `c1` char(1),`c2` char(10), `c3` char(255), `c4` varchar (255),key(`c1`),key(`c2`),key(`c3`),key(`c4`))engine=myisam|

n|10|insert into `qa00`(`c1`,`c2`,`c3`,`c4`) values (if((rand()*100) < 10,NULL,'?'),if((rand()*100) < 10,NULL,'?'),if((rand()*100) < 10,NULL,'?'),if((rand()*100) < 10,NULL,'?'))|varchar ,varchar ,varchar ,varchar 
p|10|insert into `qa00`(`c1`,`c2`,`c3`,`c4`) values (if((rand()*100) < 10,NULL,?),if((rand()*100) < 10,NULL,?),if((rand()*100) < 10,NULL,?),if((rand()*100) < 10,NULL,?))|varchar ,varchar ,varchar ,varchar 
n|10|select `c1` from `qa00`|
n|10|select `c2` from `qa00`|
n|10|select `c3` from `qa00`|
n|10|select `c4` from `qa00`|
n|10|select * from `qa00`|

n|1|show table status|
n|1|show processlist|
n|1|show innodb status|
n|1|show global status|

n|10|select * from `qa00` where `c1` = '?'|varchar 
n|10|select * from `qa00` where `c1` = '?' or `c2` = '?'|varchar ,varchar 
n|10|select * from `qa00` where `c2` = '?' or `c3` = '?' or `c4` = '?'|varchar ,varchar ,varchar 
n|10|select * from `qa00` where `c3` in ('?','?','?','?','?','?','?','?','?','?','?','?')|varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar 
n|10|select * from `qa00` where `c4` <> '?'|varchar 


p|10|select `c1` from `qa00`|
p|10|select `c2` from `qa00`|
p|10|select `c3` from `qa00`|
p|10|select `c4` from `qa00`|
p|10|select * from `qa00`|
p|10|select * from `qa00` where `c1` = ?|varchar 
p|10|select * from `qa00` where `c1` = ? or `c2` = ?|varchar ,varchar 
p|10|select * from `qa00` where `c2` = ? or `c3` = ? or `c4` = ?|varchar ,varchar ,varchar 
p|10|select * from `qa00` where `c3` in (?,?,?,?,?,?,?,?,?,?,?,?)|varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar ,varchar 
p|10|select * from `qa00` where `c4` <> ?|varchar 
#############CHAR#######################




#############INT########################
i|10|drop table if exists `qa01`|
i|1|create table `qa01` (`c1` tinyint, `c2` smallint, `c3` mediumint, `c4` int, `c5` bigint,key(`c1`),key(`c2`),key(`c3`),key(`c4`),key(`c5`))engine=myisam|

n|10|insert into `qa01`(`c1`,`c2`,`c3`,`c4`,`c5`) values (if((rand()*100) < (?%90),NULL,?),if((rand()*100) < (?%90),NULL,?),if((rand()*100) < (?%90),NULL,?),if((rand()*100) < (?%90),NULL,?),if((rand()*100) < (?%90),NULL,?))|tinyint,tinyint,tinyint,smallint,tinyint,mediumint,tinyint,int,tinyint,bigint
p|10|insert into `qa01`(`c1`,`c2`,`c3`,`c4`,`c5`) values (if((rand()*100) < (?%90),NULL,?),if((rand()*100) < (?%90),NULL,?),if((rand()*100) < (?%90),NULL,?),if((rand()*100) < (?%90),NULL,?),if((rand()*100) < (?%90),NULL,?))|tinyint,tinyint,tinyint,smallint,tinyint,mediumint,tinyint,int,tinyint,bigint
n|10|select `c1` from `qa01`|
n|10|select `c2` from `qa01`|
n|10|select `c3` from `qa01`|
n|10|select `c4` from `qa01`|
n|10|select `c5` from `qa01`|
n|10|select * from `qa01`|
n|10|select * from `qa01` where `c1` = ?|tinyint
n|10|select * from `qa01` where `c1` = ? or `c2` = ?|tinyint,smallint
n|10|select * from `qa01` where `c2` = ? or `c3` = ? or `c4` = ?|smallint,mediumint,int
n|10|select * from `qa01` where `c3` = ?|mediumint
n|10|select * from `qa01` where `c4` in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)|int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int
n|10|select * from `qa01` where `c5` <> ?|bigint

p|10|select `c1` from `qa01`|
p|10|select `c2` from `qa01`|
p|10|select `c3` from `qa01`|
p|10|select `c4` from `qa01`|
p|10|select `c5` from `qa01`|
p|10|select * from `qa01`|
p|10|select * from `qa01` where `c1` = ?|tinyint
p|10|select * from `qa01` where `c1` = ? or `c2` = ?|tinyint,smallint
p|10|select * from `qa01` where `c2` = ? or `c3` = ? or `c4` = ?|smallint,mediumint,int
p|10|select * from `qa01` where `c3` = ?|mediumint
p|10|select * from `qa01` where `c4` in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)|int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int
p|10|select * from `qa01` where `c5` <> ?|bigint
#############INT########################



#############DATES######################
i|10|drop table if exists `qa02`|
i|1|create table `qa02` (`c1` year, `c2` time, `c3` date, `c4` datetime, `c5` timestamp, `c6` timestamp,key(`c1`),key(`c2`),key(`c3`),key(`c4`),key(`c5`),key(`c6`))engine=myisam|

n|10|insert into `qa02`(`c1`,`c2`,`c3`,`c4`,`c5`,`c6`) values ('?','?','?','?','?','?')|year,time,date,datetime,timestamp,timestamp
p|10|insert into `qa02`(`c1`,`c2`,`c3`,`c4`,`c5`,`c6`) values (?,?,?,?,?,?)|year,time,date,datetime,timestamp,timestamp

n|10|select `c1` from `qa02`|
n|10|select `c2` from `qa02`|
n|10|select `c3` from `qa02`|
n|10|select `c4` from `qa02`|
n|10|select `c5` from `qa02`|
n|10|select `c6` from `qa02`|
n|10|select * from `qa02`|

n|10|select * from `qa02` where `c1` = ?|year
n|10|select * from `qa02` where `c1` = ? or `c2` = '?'|year,time
n|10|select * from `qa02` where `c1` = ? or `c2` = '?' or `c3` = '?'|year,time,date
n|10|select * from `qa02` where `c1` = ? or `c2` = '?' or `c3` = '?' or `c4` = '?'|year,time,date,datetime
n|10|select * from `qa02` where `c1` = ? or `c2` = '?' or `c3` = '?' or `c4` = '?' or `c5` = '?'|year,time,date,datetime,timestamp
n|10|select * from `qa02` where `c1` = ? or `c2` = '?' or `c3` = '?' or `c4` = '?' or `c5` = '?' or `c6` = '?'|year,time,date,datetime,timestamp,timestamp

p|10|select `c1` from `qa02`|
p|10|select `c2` from `qa02`|
p|10|select `c3` from `qa02`|
p|10|select `c4` from `qa02`|
p|10|select `c5` from `qa02`|
p|10|select `c6` from `qa02`|
p|10|select * from `qa02`|

p|10|select * from `qa02` where `c1` = ?|year
p|10|select * from `qa02` where `c1` = ? or `c2` = ?|year,time
p|10|select * from `qa02` where `c1` = ? or `c2` = ? or `c3` = ?|year,time,date
p|10|select * from `qa02` where `c1` = ? or `c2` = ? or `c3` = ? or `c4` = ?|year,time,date,datetime
p|10|select * from `qa02` where `c1` = ? or `c2` = ? or `c3` = ? or `c4` = ? or `c5` = ?|year,time,date,datetime,timestamp
p|10|select * from `qa02` where `c1` = ? or `c2` = ? or `c3` = ? or `c4` = ? or `c5` = ? or `c6` = ?|year,time,date,datetime,timestamp,timestamp

#############DATES######################


#############FLOAT######################
i|10|drop table if exists `qa03`|
i|1|create table `qa03` (`c1` float, `c2` double)engine=myisam|

n|10|insert into `qa03`(`c1`,`c2`) values (?,?)|float,double
p|10|insert into `qa03`(`c1`,`c2`) values (?,?)|float,double

n|10|select `c1` from `qa03`|
n|10|select `c2` from `qa03`|
n|10|select * from `qa03`|

p|10|select `c1` from `qa03`|
p|10|select `c2` from `qa03`|
p|10|select * from `qa03`|
#############FLOAT######################





############DECIMAL#####################
i|10|drop table if exists `qa04`|
i|1|create table `qa04`(`c1` decimal(2,1), `c2` decimal(15,10),`c3` decimal(7,6),`c4` decimal(30,20),key(`c1`),key(`c2`),key(`c3`),key(`c4`))engine=myisam|

n|10|insert into `qa04`(`c1`,`c2`) values (?,?)|decimal,decimal
p|10|insert into `qa04`(`c1`,`c2`) values (?,?)|decimal,decimal

n|10|select `c1` from `qa04`|
n|10|select `c2` from `qa04`|
n|10|select * from `qa04`|
n|10|select * from `qa04` where `c1` > ?|decimal
n|10|select * from `qa04` where `c1` > ? or `c2` < ?|decimal,decimal
n|10|select * from `qa04` where `c1` > ? or `c2` < ? and `c3` > ?|decimal,decimal,decimal
n|10|select * from `qa04` where `c1` > ? or `c2` < ? and `c3` > ? or `c4` <= ?|decimal,decimal,decimal,decimal

p|10|select `c1` from `qa04`|
p|10|select `c2` from `qa04`|
p|10|select * from `qa04`|
p|10|select * from `qa04` where `c1` > ?|decimal
p|10|select * from `qa04` where `c1` > ? or `c2` < ?|decimal,decimal
p|10|select * from `qa04` where `c1` > ? or `c2` < ? and `c3` > ?|decimal,decimal,decimal
p|10|select * from `qa04` where `c1` > ? or `c2` < ? and `c3` > ? or `c4` <= ?|decimal,decimal,decimal,decimal
############DECIMAL#####################



############UTF8#######################
n|10|/*!41000 set names utf8*/|
i|10|drop table if exists `qa05`|
i|1|create table `qa05`(`id` int not null auto_increment primary key,`c1` varchar(10) /*!41000 charset 'utf8'*/, `c2` varchar(255) /*!41000 charset 'utf8'*/, index(`c1`),index(`c2`))engine=myisam|
n|10|insert into `qa05`(`c1`,`c2`) values ('?','?')|utf8,utf8
p|10|insert into `qa05`(`c1`,`c2`) values (?,?)|utf8,utf8

n|10|select `c2` from `qa05` order by `c1`|
n|10|select `c1` from `qa05` order by `c2`|
n|10|select `c1`,`c2` from `qa05` order by `c2`|
n|10|select * from `qa05` order by `c2`|
n|10|select * from `qa05` where `c1` <> '?' and `c2` not in('?','?','?') order by `c2`|utf8,utf8,utf8,utf8
n|10|select 1 from `qa05` where `c1` <> '?' and `c2` not in('?','?','?') order by `c2`|utf8,utf8,utf8,utf8
n|10|select `c1`, `c2`, `id` from `qa05` where `c1` = '?' or `c2` in(substr('?',1),substr('?',1),substr('?',1)) order by `c2`|utf8,utf8,utf8,utf8

p|10|select `c2` from `qa05` order by `c1`|
p|10|select `c1` from `qa05` order by `c2`|
p|10|select `c1`,`c2` from `qa05` order by `c2`|
p|10|select * from `qa05` order by `c2`|
p|10|select * from `qa05` where `c1` <> ? and `c2` not in(?,?,?) order by `c2`|utf8,utf8,utf8,utf8
p|10|select 1 from `qa05` where `c1` <> ? and `c2` not in(?,?,?) order by `c2`|utf8,utf8,utf8,utf8
p|10|select `c1`, `c2`, `id` from `qa05` where `c1` = ? or `c2` in(substr(?,1),substr(?,1),substr(?,1)) order by `c2`|utf8,utf8,utf8,utf8
n|10|reconnect|
############UTF8#####################



###########BLOBS#####################
i|10|drop table if exists `qa06`|
i|1|create table `qa06`(`c0` int not null auto_increment primary key,`c1` tinyblob,`c2` blob,`c3` mediumblob,`c4` longblob)engine=myisam|
n|10|insert into `qa06`(`c1`,`c2`,`c3`,`c4`) values ('?','?','?','?')|tinyblob ,blob , mediumblob ,longblob 
p|10|insert into `qa06`(`c1`,`c2`,`c3`,`c4`) values (?,?,?,?)|tinyblob ,blob , mediumblob ,longblob 

n|10|select `c1` from `qa06` limit 10|
n|10|select `c2` from `qa06` limit 10|
n|10|select `c3` from `qa06` limit 10|
n|10|select `c4` from `qa06` limit 10|
n|10|select `c1`,`c2` from `qa06` limit 10|
n|10|select `c2`,`c3` from `qa06` limit 10|
n|10|select `c3`,`c4` from `qa06` limit 10|
n|10|select `c4` from `qa06` limit 10|
n|10|select * from `qa06` limit 10|
n|10|select * from `qa06` where `c0`='?'|int

p|10|select `c1` from `qa06` limit 10|
p|10|select `c2` from `qa06` limit 10|
p|10|select `c3` from `qa06` limit 10|
p|10|select `c4` from `qa06` limit 10|
p|10|select `c1`,`c2` from `qa06` limit 10|
p|10|select `c2`,`c3` from `qa06` limit 10|
p|10|select `c3`,`c4` from `qa06` limit 10|
p|10|select `c4` from `qa06` limit 10|
p|10|select * from `qa06` limit 10|
p|10|select * from `qa06` where `c0`=?|int

###########BLOBS#####################


###########TEXTS#####################
i|10|drop table if exists `qa07`|
i|1|create table `qa07`(`c0` int not null auto_increment primary key,`c1` tinytext,`c2` text,`c3` mediumtext,`c4` longtext)engine=myisam|
n|10|insert into `qa07`(`c1`,`c2`,`c3`,`c4`) values ('?','?','?','?')|tinytext ,text , mediumtext ,longtext 
p|10|insert into `qa07`(`c1`,`c2`,`c3`,`c4`) values (?,?,?,?)|tinytext ,text , mediumtext ,longtext 

n|10|select `c1` from `qa07` limit 10|
n|10|select `c2` from `qa07` limit 10|
n|10|select `c3` from `qa07` limit 10|
n|10|select `c4` from `qa07` limit 10|
n|10|select `c1`,`c2` from `qa07` limit 10|
n|10|select `c2`,`c3` from `qa07` limit 10|
n|10|select `c3`,`c4` from `qa07` limit 10|
n|10|select `c4` from `qa07` limit 10|
n|10|select * from `qa07` limit 10;
n|10|select * from `qa07` where `c0`='?'|int

p|10|select `c1` from `qa07` limit 10|
p|10|select `c2` from `qa07` limit 10|
p|10|select `c3` from `qa07` limit 10|
p|10|select `c4` from `qa07` limit 10|
p|10|select `c1`,`c2` from `qa07` limit 10|
p|10|select `c2`,`c3` from `qa07` limit 10|
p|10|select `c3`,`c4` from `qa07` limit 10|
p|10|select `c4` from `qa07` limit 10|
p|10|select * from `qa07` limit 10;
p|10|select * from `qa07` where `c0`=?|int

###########TEXTS#####################


#reconnections to server ...
n|10|reconnect|
n|1|commit|
n|1|rollback|
n|1|start transaction|

#misc, adhoc stuff, in large quantities

p|10|select 1|
n|10|select 1|
n|10|select now()|
n|1|select '?'|
n|1|select ?|int,int
n|1|select ???|int,int
p|10|select now()|
n|10|select null|
p|10|select null|

#c|10000|select now()|
#c|1|select sleep(10)|

#n|5|kill query|
#n|5|kill connection|


i|1|drop table if exists `qa08`|
i|1|drop table if exists `qa09`|

#{"BOOL",         
#{"SET",          
#{"ENUM",