Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_binlog_format.result

raw
1 CREATE TABLE t1 (m INT, n INT) ENGINE=MYISAM;
2 CREATE TABLE t2 (b INT, c INT) ENGINE=BLACKHOLE;
3 CREATE TABLE t3 (e INT, f INT) ENGINE=NDB;
4 RESET MASTER;
5 SET SESSION BINLOG_FORMAT=STATEMENT;
6 Warnings:
7 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
8 INSERT INTO t1 VALUES (1,1), (1,2), (2,1), (2,2);
9 INSERT INTO t2 VALUES (1,1), (1,2), (2,1), (2,2);
10 UPDATE t1, t2 SET m = 2, b = 3 WHERE n = c;
11 START TRANSACTION;
12 INSERT INTO t3 VALUES (1,1), (1,2), (2,1), (2,2);
13 UPDATE t1, t3 SET m = 2, e = 3 WHERE n = f;
14 Warnings:
15 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
16 UPDATE t3, t2 SET e = 2, b = 3 WHERE f = c;
17 COMMIT;
18 include/show_binlog_events.inc
19 Log_name Pos Event_type Server_id End_log_pos Info
20 binlog.000001 # Query # # BEGIN
21 binlog.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1), (1,2), (2,1), (2,2)
22 binlog.000001 # Query # # COMMIT
23 binlog.000001 # Query # # BEGIN
24 binlog.000001 # Query # # use `test`; INSERT INTO t2 VALUES (1,1), (1,2), (2,1), (2,2)
25 binlog.000001 # Query # # COMMIT
26 binlog.000001 # Query # # BEGIN
27 binlog.000001 # Query # # use `test`; UPDATE t1, t2 SET m = 2, b = 3 WHERE n = c
28 binlog.000001 # Query # # COMMIT
29 binlog.000001 # Query # # BEGIN
30 binlog.000001 # Query # # use `test`; INSERT INTO t3 VALUES (1,1), (1,2), (2,1), (2,2)
31 binlog.000001 # Query # # use `test`; UPDATE t1, t3 SET m = 2, e = 3 WHERE n = f
32 binlog.000001 # Query # # use `test`; UPDATE t3, t2 SET e = 2, b = 3 WHERE f = c
33 binlog.000001 # Query # # COMMIT
34 DROP TABLE t1, t2, t3;