2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
create table t2 (id int not null primary key auto_increment);
8
select @@session.read_buffer_size - @@session.max_allowed_packet > 0 ;
9
@@session.read_buffer_size - @@session.max_allowed_packet > 0
11
load data infile 'MYSQLTEST_VARDIR/tmp/bug30435_5k.txt' into table t2;
12
select count(*) from t2 /* 5 000 */;
15
show binlog events in 'master-bin.000002' from <binlog_start>;
16
Log_name Pos Event_type Server_id End_log_pos Info
17
master-bin.000002 # Query # # use `test`; create table t2 (id int not null primary key auto_increment)
18
master-bin.000002 # Begin_load_query # # ;file_id=#;block_len=#
19
master-bin.000002 # Append_block # # ;file_id=#;block_len=#
20
master-bin.000002 # Append_block # # ;file_id=#;block_len=#
21
master-bin.000002 # Execute_load_query # # use `test`; load data infile 'MYSQLTEST_VARDIR/tmp/bug30435_5k.txt' into table t2 ;file_id=#
22
select count(*) from t2 /* 5 000 */;