i|1|drop table if exists `t1`|
i|1|drop table if exists `t2`|
i|1|drop table if exists `t3`|
i|1|drop table if exists `t4`|
i|1|create table `t1`(`id` int not null auto_increment primary key,`name` varchar(20),`birthday` datetime,key(`name`(5),`birthday`))engine=falcon|
i|1|create table `t2`(`birthday` datetime,`name` char(21),`id` int,key(`birthday`,`id`))engine=falcon|
i|1|create table `t3`(`id` int not null auto_increment primary key,`data` varchar(255),key(`data`(5)))engine=falcon|
i|1|create table `t4`(`id` int not null auto_increment primary key,`data` varchar(255),key(`data`(7)))engine=falcon|
#n|1|start transaction|
#n|1|set transaction isolation level read uncommitted|
n|1|set @name='?'|char
n|1|set @birthday='?'|datetime
n|1|set @data='?'|tinytext
n|1|insert into t1(name,birthday) values (@name,@birthday)|
n|1|set @id=last_insert_id()|
n|1|insert ignore into t2 (birthday,name,id) select birthday,name,id+1 from t1 where id=@id|
n|1|insert ignore into t3(data) values (concat(@name,@birthdate))|
n|1|insert ignore into t4(id,data) values(last_insert_id()+abs(?),'?')|tinyint,char
n|1|start transaction|
n|1|update t4 set data=reverse(data) order by id limit 1|
#n|1|commit|
n|1|select count(*) from t1,t2,t3 where t1.id=t2.id and t2.id=t3.id|
n|1|select count(*) from t1 where id%5=0|
n|1|select * from t3 where data like '?%'|char
#n|1|commit|
n|1|select max(id) from t1|
n|1|insert ignore into t4(id) select max(id)+1 from t2|
n|1|insert ignore into t3(id) select max(id)+1 from t2|
n|1|insert ignore into t2(id) select max(id)+1 from t1|
n|1|insert ignore into t1(id) select max(id)+1 from t2|
#q|1|flush tables|
#n|1|analyze table t1,t2,t3,t4|
#n|1|analyze table t1,t2,t4|
#n|1|analyze table t2,t1|