← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_loaddata_map.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_loaddata_map.result
 
1
stop slave;
 
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
3
reset master;
 
4
reset slave;
 
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
6
start slave;
 
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
 
10
1
 
11
load data infile 'MYSQLTEST_VARDIR/tmp/bug30435_5k.txt' into table t2;
 
12
select count(*) from t2 /* 5 000 */;
 
13
count(*)
 
14
5000
 
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 */;
 
23
count(*)
 
24
5000
 
25
drop table t1, t2;
 
26
end of the tests