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