Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 SET SQL_LOG_BIN=0;
4 CREATE TABLE t (a int, b int, c int, key(b));
5 SET SQL_LOG_BIN=1;
6 connection slave;
7 CREATE TABLE t (a int, b int, c int);
8 connection master;
9 INSERT INTO t VALUES (1,2,4);
10 INSERT INTO t VALUES (4,3,4);
11 DELETE FROM t;
12 connection slave;
13 connection master;
14 DROP TABLE t;
15 connection slave;
16 include/rpl_reset.inc
17 connection master;
18 CREATE TABLE t (a int, b int, c int, key(b));
19 connection slave;
20 ALTER TABLE t DISABLE KEYS;
21 connection master;
22 INSERT INTO t VALUES (1,2,4);
23 INSERT INTO t VALUES (4,3,4);
24 DELETE FROM t;
25 connection slave;
26 connection master;
27 DROP TABLE t;
28 connection slave;
29 include/rpl_reset.inc
30 connection master;
31 CREATE TABLE t1 (c1 INT NOT NULL, c2 INT NOT NULL, c3 INT, UNIQUE KEY(c1,c3), KEY(c2));
32 INSERT INTO t1(c1,c2) VALUES(1,1);
33 INSERT INTO t1(c1,c2) VALUES(1,2);
34 UPDATE t1 SET c1=1000 WHERE c2=2;
35 connection slave;
36 include/diff_tables.inc [master:t1, slave:t1]
37 connection master;
38 DROP TABLE t1;
39 connection slave;
40 include/rpl_end.inc