Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mysqlbinlog_rewrite_db.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 [Syntax error in the use of the new option: The from database name is missing]
10 [Syntax error in the use of the new option: The '->' is missing]
11 [Syntax error in the use of the new option: The to database name is missing]
12 [VALID SYNTAX,The from->to database names is correctly mentioned]
13 [VALID SYNTAX read from remote server ,The from->to database names are correctly mentioned]
14 [VALID SYNTAX read from remote server in raw mode, the from->to database names are correctly mentioned]
15 [VALID SYNTAX, but during the application of rewrite_db filter an invalid event is found. Hence mysqlbinlog tool should exit with an appropriate error]
16 [ERROR: Got fatal error while applying rewrite db filter.]
17 #Dropping the database db1 and creating the table in the new database new_db1.
18 CREATE DATABASE new_db1;
19 DROP DATABASE db1;
20 RESET MASTER;
21 SELECT * FROM new_db1.t1;
22 ERROR 42S02: Table 'new_db1.t1' doesn't exist
23 DROP DATABASE db1;
24 RESET MASTER;
25 [The event of table db1.t1 has been successfully applied to new_db1.t1]
26 include/assert.inc [Assert that table new_db1.t1 has one row after applying the sql file.]
27 DROP DATABASE db1;
28 DROP DATABASE new_db1;
29 CREATE DATABASE new_db1;
30 RESET MASTER;
31 [The event of table db1.t1 has been successfully applied to new_db1.t1]
32 include/assert.inc [Assert that table new_db1.t1 has one row after applying the sql file.]
33 DROP DATABASE db1;
34 DROP DATABASE new_db1;
35 CREATE DATABASE new_db1;
36 RESET MASTER;
37 [The event of table db1.t1 has been successfully applied to new_db1.t1 from raw mode]
38 include/assert.inc [Assert that table new_db1.t1 has one row after applying the sql file from raw binlog dump.]
39 CLEANUP
40 DROP DATABASE db1;
41 DROP DATABASE new_db1;