Debian Codegraph @

mysql-test/suite/rpl/r/rpl_loaddata_map.result

raw
1 include/master-slave.inc
2 [connection master]
3 ==== Create a big file ====
4 SET @@sql_log_bin= 0;
5 create table t1 (id int not null primary key auto_increment);
6 select * into outfile '$MYSQLTEST_VARDIR/tmp/bug30435_5k.txt' from t1;
7 DROP TABLE t1;
8 SET @@sql_log_bin= 1;
9 ==== Load our big file into a table ====
10 create table t2 (id int not null primary key auto_increment);
11 select @@session.read_buffer_size - @@session.max_allowed_packet > 0 ;
12 @@session.read_buffer_size - @@session.max_allowed_packet > 0
13 1
14 load data infile 'MYSQLTEST_VARDIR/tmp/bug30435_5k.txt' into table t2;
15 select count(*) from t2 /* 5 000 */;
16 count(*)
17 5000
18 include/show_binlog_events.inc
19 Log_name Pos Event_type Server_id End_log_pos Info
20 master-bin.000001 # Gtid # # GTID #-#-#
21 master-bin.000001 # Query # # use `test`; create table t2 (id int not null primary key auto_increment)
22 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
23 master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
24 master-bin.000001 # Append_block # # ;file_id=#;block_len=#
25 master-bin.000001 # Append_block # # ;file_id=#;block_len=#
26 master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/bug30435_5k.txt' INTO TABLE `t2` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`id`) ;file_id=#
27 master-bin.000001 # Query # # COMMIT
28 ==== Verify results on slave ====
29 connection slave;
30 select count(*) from t2 /* 5 000 */;
31 count(*)
32 5000
33 ==== Clean up ====
34 connection master;
35 drop table t2;
36 connection slave;
37 include/rpl_end.inc