Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CREATE TABLE t1 (
5 id INTEGER PRIMARY KEY,
6 f2 INTEGER
7 );
8 CREATE TABLE t2 (
9 id INT PRIMARY KEY,
10 t1_id INT NOT NULL,
11 f2 INTEGER NOT NULL,
12 KEY key_t1_id(t1_id),
13 CONSTRAINT key_t1_id FOREIGN KEY (t1_id) REFERENCES t1 (id) ON UPDATE CASCADE ON DELETE CASCADE
14 );
15 INSERT INTO t1 VALUES (1,0);
16 INSERT INTO t1 VALUES (2,0);
17 INSERT INTO t2 VALUES (1,1,1234);
18 connection slave;
19 connection slave;
20 SET @saved_dbug = @@GLOBAL.debug_dbug;
21 set @@global.debug_dbug= "+d,sync.rm_table_no_locks";
22 set global slave_exec_mode='IDEMPOTENT';
23 connection master;
24 DROP TABLE t2;
25 connection slave;
26 set debug_sync='now WAIT_FOR after_lock_table';
27 connection master;
28 START TRANSACTION;
29 INSERT INTO t1 VALUES (3,0);
30 COMMIT;
31 connection slave;
32 SET DEBUG_SYNC= 'RESET';
33 set debug_sync='now SIGNAL continue';
34 SET @@GLOBAL.debug_dbug = @saved_dbug;
35 set global slave_exec_mode='STRICT';
36 connection slave;
37 select * from t1;
38 id f2
39 1 0
40 2 0
41 3 0
42 select * from t2;
43 ERROR 42S02: Table 'test.t2' doesn't exist
44 connection master;
45 select * from t1;
46 id f2
47 1 0
48 2 0
49 3 0
50 select * from t2;
51 ERROR 42S02: Table 'test.t2' doesn't exist
52 DROP TABLE t1;
53 connection slave;
54 connection master;
55 CREATE TABLE t1 (
56 id INTEGER PRIMARY KEY,
57 f2 INTEGER
58 );
59 CREATE TABLE t2 (
60 id INT PRIMARY KEY,
61 t1_id INT NOT NULL,
62 f2 INTEGER NOT NULL,
63 KEY key_t1_id(t1_id),
64 CONSTRAINT key_t1_id FOREIGN KEY (t1_id) REFERENCES t1 (id) ON UPDATE CASCADE ON DELETE CASCADE
65 );
66 INSERT INTO t1 VALUES (1,0);
67 INSERT INTO t1 VALUES (2,0);
68 INSERT INTO t2 VALUES (1,1,1234);
69 connection slave;
70 connection slave;
71 SET @saved_dbug = @@GLOBAL.debug_dbug;
72 set @@global.debug_dbug= "+d,sync.rm_table_no_locks";
73 set global slave_exec_mode='STRICT';
74 connection master;
75 DROP TABLE t2;
76 connection slave;
77 set debug_sync='now WAIT_FOR after_lock_table';
78 connection master;
79 START TRANSACTION;
80 INSERT INTO t1 VALUES (3,0);
81 COMMIT;
82 connection slave;
83 SET DEBUG_SYNC= 'RESET';
84 set debug_sync='now SIGNAL continue';
85 SET @@GLOBAL.debug_dbug = @saved_dbug;
86 set global slave_exec_mode='STRICT';
87 connection slave;
88 select * from t1;
89 id f2
90 1 0
91 2 0
92 3 0
93 select * from t2;
94 ERROR 42S02: Table 'test.t2' doesn't exist
95 connection master;
96 select * from t1;
97 id f2
98 1 0
99 2 0
100 3 0
101 select * from t2;
102 ERROR 42S02: Table 'test.t2' doesn't exist
103 DROP TABLE t1;
104 connection slave;
105 include/rpl_end.inc