Debian Codegraph @

mysql-test/suite/binlog/r/binlog_rewrite_db_noleak.result

raw
1 RESET MASTER;
2 CREATE DATABASE db1;
3 USE db1;
4 CREATE TABLE t1 (i INT);
5 INSERT INTO db1.t1 VALUES(1);
6 INSERT INTO db1.t1 VALUES(2);
7 UPDATE t1 SET i= i+1;
8 DELETE FROM t1 WHERE i=2;
9 CREATE DATABASE db2;
10 CREATE TABLE db2.t1 (i INT);
11 INSERT INTO db2.t1 VALUES(3);
12 INSERT INTO db2.t1 VALUES(4);
13 INSERT INTO db2.t1 VALUES(5);
14 UPDATE db2.t1 SET i= i+1;
15 DELETE FROM db2.t1 WHERE i=4;
16 call mtr.add_suppression("Replica SQL: Error executing row event:*");
17 Dropping the database db1 creating the new database db3.
18 DROP DATABASE db1;
19 CREATE DATABASE db3;
20 DROP DATABASE db2;
21 RESET MASTER;
22 [The sql file will be applied on the current database]
23 [The content of table db3.t1 and db2.t1 will be different confirming no leak]
24 include/assert.inc [The content of the table t1 in database db3 and db2 is different]
25 include/assert.inc [Table t1 in db3 have different row count than t1 in db2]
26 CLEANUP
27 DROP DATABASE db1;
28 DROP DATABASE db2;
29 DROP DATABASE db3;