1RESET MASTER; 2CREATE TABLE t1 (id int); 3CREATE TABLE t2 (id int); 4CREATE TABLE t3 (txt TEXT); 5CREATE TABLE t4 (a int) ENGINE= InnoDB; 6INSERT INTO t1 VALUES (1); 7INSERT INTO t1 VALUES (2); 8INSERT INTO t2 VALUES (1); 9INSERT INTO t2 VALUES (2); 10INSERT INTO t1 VALUES (3); 11LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/words.dat' INTO TABLE t3; 12INSERT INTO t1 VALUES (4); 13CREATE DATABASE b42941; 14use b42941; 15CREATE TABLE t1 (id int); 16CREATE TABLE t2 (id int); 17CREATE TABLE t3 (txt TEXT); 18CREATE TABLE t4 (a int) ENGINE= InnoDB; 19INSERT INTO t1 VALUES (1); 20INSERT INTO t1 VALUES (2); 21INSERT INTO t2 VALUES (1); 22INSERT INTO t2 VALUES (2); 23INSERT INTO t1 VALUES (3); 24LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/words.dat' INTO TABLE t3; 25INSERT INTO t1 VALUES (4); 26INSERT INTO test.t1 VALUES (5); 27FLUSH LOGS; 28UPDATE test.t1 t11, b42941.t1 t12 SET t11.id=10, t12.id=100; 29BEGIN; 30INSERT INTO test.t4 VALUES (1); 31INSERT INTO b42941.t4 VALUES (1); 32UPDATE test.t4 tn4, b42941.t4 tt4 SET tn4.a= 10, tt4.a= 100; 33COMMIT; 34FLUSH LOGS; 35SET @b42941_output.1= LOAD_FILE('MYSQLTEST_VARDIR/tmp/b42941-mysqlbinlog.1'); 36SET @b42941_output.2= LOAD_FILE('MYSQLTEST_VARDIR/tmp/b42941-mysqlbinlog.2'); 37SET @b42941_output.1= LOAD_FILE('MYSQLTEST_VARDIR/tmp/b42941-mysqlbinlog.1'); 38SET @b42941_output.2= LOAD_FILE('MYSQLTEST_VARDIR/tmp/b42941-mysqlbinlog.2'); 39SET @b42941_output.1= LOAD_FILE('MYSQLTEST_VARDIR/tmp/b42941-mysqlbinlog.1'); 40SET @b42941_output.2= LOAD_FILE('MYSQLTEST_VARDIR/tmp/b42941-mysqlbinlog.2'); 41DROP DATABASE b42941; 42use test; 43DROP TABLE t1, t2, t3, t4; 44