Debian Codegraph @

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

raw
1 RESET MASTER;
2 CREATE DATABASE db1;
3 USE db1;
4 CREATE TABLE t1 (i INT);
5 INSERT INTO t1 VALUES(1);
6 INSERT INTO t1 VALUES(2);
7 UPDATE t1 SET i= i+1;
8 DELETE FROM t1 WHERE i=2;
9 [The use <db_name> is not suppressed in the general use of mysqlbinlog]
10 Matching lines are:
11 use `db1`/*!*/;
12 Occurrences of 'use `db1`' in the input file: 1
13 [The use <db_name> is suppressed on using rewrite-db option of mysqlbinlog]
14 Matching lines are:
15 None
16 Occurrences of 'use `db1`' in the input file: 0
17 CREATE DATABASE db2;
18 DROP DATABASE db1;
19 RESET MASTER;
20 SELECT * FROM db2.t1;
21 ERROR 42S02: Table 'db2.t1' doesn't exist
22 DROP DATABASE db1;
23 RESET MASTER;
24 [The event of table db1.t1 has been successfully applied to db2.t1]
25 include/assert.inc [Assert that table db2.t1 has no rows after applying the sql file.]
26 [CLEANUP]
27 DROP DATABASE db1;
28 DROP DATABASE db2;