Bug #60334 LOAD XML INFILE cannot be replicated correctly on SBR.

• Submitted: 4 Mar 2011 11:35
• Modified: 4 Mar 2011 11:42
• Reporter: Libing Song
• Status: Verified
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any
• Tags: mysql-5.5, mysql-trunk

[4 Mar 2011 11:35] Libing Song

Description:
LOAD XML is binlogged with a wrong query which generates different data on slave.

How to repeat:
source include/master-slave.inc;
source include/have_binlog_format_statement.inc;
create table t1 (a int, b varchar(64));
load xml infile '../../std_data/loadxml.dat' into table t1;
select * from t1;
source include/show_binlog_events.inc;
sync_slave_with_master;
select * from t1;

[4 Mar 2011 11:43] Valeriy Kravchuk

Verified with mysql-trunk on Linux:

openxs@ubuntu:/home2/openxs/dbs/trunk/mysql-test$ ./mtr bug60334
Logging: ./mtr  bug60334
110304 13:40:41 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.6.2
Checking supported features...
 - skipping ndbcluster
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: /home2/openxs/dbs/trunk/mysql-test/var
Removing old var directory...
Creating var directory '/home2/openxs/dbs/trunk/mysql-test/var'...
Installing system database...
Using server port 52600

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.bug60334                            [ fail ]
        Test ended at 2011-03-04 13:41:14

CURRENT_TEST: main.bug60334
--- /home2/openxs/dbs/trunk/mysql-test/r/bug60334.result	2011-03-04 14:40:00.000000000 +0300
+++ /home2/openxs/dbs/trunk/mysql-test/r/bug60334.reject	2011-03-04 14:41:13.000000000 +0300
@@ -0,0 +1,34 @@
+include/master-slave.inc
+[connection master]
+create table t1 (a int, b varchar(64));
+load xml infile '../../std_data/loadxml.dat' into table t1;
+select * from t1;
+a	b
+1	b1
+2	b2
+3	b3
+11	b11
+111	b111
+112	b112 & < > " ' &unknown; -- check entities
+212	b212
+213	b213
+214	b214
+215	b215
+216	&bb b;
+show binlog events from <binlog_start>;
+Log_name	Pos	Event_type	Server_id	End_log_pos	Info
+master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int, b varchar(64))
+master-bin.000001	#	Query	#	#	BEGIN
+master-bin.000001	#	Begin_load_query	#	#	;file_id=#;block_len=#
+master-bin.000001	#	Execute_load_query	#	#	use `test`; LOAD DATA INFILE '../../std_data/loadxml.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '<row>' (`a`, `b`) ;file_id=#
+master-bin.000001	#	Query	#	#	COMMIT
+select * from t1;
+a	b
+0	<table_structure name="t1">
+
+0	
+0	
+0	
+0	
+0	
+0	

mysqltest: Result length mismatch
...