/*!40019 SET @@session.max_insert_delayed_threads=0*/;
# at 4
#041116 17:09:10 server id 33410  log_pos 4 	Start: binlog v 3, server v 4.1.8-debug-log created 041116 17:09:10 at startup
# at 79
#041116 17:09:49 server id 33410  log_pos 79 	Query	thread_id=1	exec_time=0	error_code=0
use test;
SET TIMESTAMP=1100650189;
SET @@session.pseudo_thread_id=1;
create temporary table foo (id int);
# at 149
#041116 17:10:06 server id 33410  log_pos 149 	Query	thread_id=2	exec_time=0	error_code=0
SET TIMESTAMP=1100650206;
SET @@session.pseudo_thread_id=2;
create temporary table foo (id int);
# at 219
# LOAD DATA INFILE '../ones.txt' INTO TABLE `foo` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (id);
# file_id: 1  block_len: 20
# at 314
#041116 17:10:36 server id 33410  log_pos 314 
#Exec_load: file_id=1
LOAD DATA LOCAL INFILE '/var/tmp/ones.txt-1-0' INTO TABLE `foo` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (id);
# file_id: 1  block_len: 20
# at 337
#041116 17:10:49 server id 33410  log_pos 337 	Query	thread_id=1	exec_time=0	error_code=0
SET TIMESTAMP=1100650249;
drop table if exists x;
# at 394
# LOAD DATA INFILE '../twos.txt' INTO TABLE `foo` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (id);
# file_id: 2  block_len: 42
# at 511
#041116 17:11:19 server id 33410  log_pos 511 
#Exec_load: file_id=2
LOAD DATA LOCAL INFILE '/var/tmp/twos.txt-2-0' INTO TABLE `foo` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (id);
# file_id: 2  block_len: 42
# at 534
#041116 17:11:22 server id 33410  log_pos 534 	Query	thread_id=1	exec_time=0	error_code=0
SET TIMESTAMP=1100650282;
SET @@session.pseudo_thread_id=1;
create table x select * from foo;
# at 601
#041116 17:11:33 server id 33410  log_pos 601 	Query	thread_id=2	exec_time=0	error_code=0
SET TIMESTAMP=1100650293;
drop table if exists y;
# at 658
#041116 17:11:40 server id 33410  log_pos 658 	Query	thread_id=2	exec_time=0	error_code=0
SET TIMESTAMP=1100650300;
SET @@session.pseudo_thread_id=2;
create table y select * from foo;
# at 725
#041116 17:13:00 server id 33410  log_pos 725 	Query	thread_id=2	exec_time=0	error_code=0
SET TIMESTAMP=1100650380;
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `test`.`foo`;
# at 815
#041116 17:13:04 server id 33410  log_pos 815 	Query	thread_id=1	exec_time=0	error_code=0
SET TIMESTAMP=1100650384;
SET @@session.pseudo_thread_id=1;
DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `test`.`foo`;