Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_innodb.result

raw
1 SET BINLOG_FORMAT=MIXED;
2 Warnings:
3 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
4 RESET MASTER;
5 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=INNODB;
6 INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6);
7 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
8 BEGIN;
9 UPDATE t1 SET b = 2*a WHERE a > 1;
10 COMMIT;
11 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
12 BEGIN;
13 UPDATE t1 SET b = a * a WHERE a > 3;
14 COMMIT;
15 SET BINLOG_FORMAT=STATEMENT;
16 Warnings:
17 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
18 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
19 BEGIN;
20 UPDATE t1 SET b = 1*a WHERE a > 1;
21 ERROR HY000: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
22 COMMIT;
23 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
24 BEGIN;
25 UPDATE t1 SET b = 2*a WHERE a > 2;
26 ERROR HY000: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
27 COMMIT;
28 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
29 BEGIN;
30 UPDATE t1 SET b = 3*a WHERE a > 3;
31 COMMIT;
32 SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
33 BEGIN;
34 UPDATE t1 SET b = 4*a WHERE a > 4;
35 COMMIT;
36 SET BINLOG_FORMAT=MIXED;
37 Warnings:
38 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
39 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
40 BEGIN;
41 UPDATE t1 SET b = 1*a WHERE a > 1;
42 COMMIT;
43 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
44 BEGIN;
45 UPDATE t1 SET b = 2*a WHERE a > 2;
46 COMMIT;
47 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
48 BEGIN;
49 UPDATE t1 SET b = 3*a WHERE a > 3;
50 COMMIT;
51 SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
52 BEGIN;
53 UPDATE t1 SET b = 4*a WHERE a > 4;
54 COMMIT;
55 SET BINLOG_FORMAT='ROW';
56 Warnings:
57 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
58 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
59 BEGIN;
60 UPDATE t1 SET b = 1*a WHERE a > 1;
61 COMMIT;
62 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
63 BEGIN;
64 UPDATE t1 SET b = 2*a WHERE a > 2;
65 COMMIT;
66 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
67 BEGIN;
68 UPDATE t1 SET b = 3*a WHERE a > 3;
69 COMMIT;
70 SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
71 BEGIN;
72 UPDATE t1 SET b = 4*a WHERE a > 4;
73 COMMIT;
74 include/show_binlog_events.inc
75 Log_name Pos Event_type Server_id End_log_pos Info
76 binlog.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=INNODB
77 binlog.000001 # Query # # BEGIN
78 binlog.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6)
79 binlog.000001 # Xid # # COMMIT /* XID */
80 binlog.000001 # Query # # BEGIN
81 binlog.000001 # Query # # use `test`; UPDATE t1 SET b = 2*a WHERE a > 1
82 binlog.000001 # Xid # # COMMIT /* XID */
83 binlog.000001 # Query # # BEGIN
84 binlog.000001 # Table_map # # table_id: # (test.t1)
85 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
86 binlog.000001 # Xid # # COMMIT /* XID */
87 binlog.000001 # Query # # BEGIN
88 binlog.000001 # Query # # use `test`; UPDATE t1 SET b = 3*a WHERE a > 3
89 binlog.000001 # Xid # # COMMIT /* XID */
90 binlog.000001 # Query # # BEGIN
91 binlog.000001 # Query # # use `test`; UPDATE t1 SET b = 4*a WHERE a > 4
92 binlog.000001 # Xid # # COMMIT /* XID */
93 binlog.000001 # Query # # BEGIN
94 binlog.000001 # Table_map # # table_id: # (test.t1)
95 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
96 binlog.000001 # Xid # # COMMIT /* XID */
97 binlog.000001 # Query # # BEGIN
98 binlog.000001 # Table_map # # table_id: # (test.t1)
99 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
100 binlog.000001 # Xid # # COMMIT /* XID */
101 binlog.000001 # Query # # BEGIN
102 binlog.000001 # Query # # use `test`; UPDATE t1 SET b = 3*a WHERE a > 3
103 binlog.000001 # Xid # # COMMIT /* XID */
104 binlog.000001 # Query # # BEGIN
105 binlog.000001 # Query # # use `test`; UPDATE t1 SET b = 4*a WHERE a > 4
106 binlog.000001 # Xid # # COMMIT /* XID */
107 binlog.000001 # Query # # BEGIN
108 binlog.000001 # Table_map # # table_id: # (test.t1)
109 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
110 binlog.000001 # Xid # # COMMIT /* XID */
111 binlog.000001 # Query # # BEGIN
112 binlog.000001 # Table_map # # table_id: # (test.t1)
113 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
114 binlog.000001 # Xid # # COMMIT /* XID */
115 binlog.000001 # Query # # BEGIN
116 binlog.000001 # Table_map # # table_id: # (test.t1)
117 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
118 binlog.000001 # Xid # # COMMIT /* XID */
119 binlog.000001 # Query # # BEGIN
120 binlog.000001 # Table_map # # table_id: # (test.t1)
121 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
122 binlog.000001 # Xid # # COMMIT /* XID */
123 DROP TABLE t1;
124 flush status;
125 show status like "binlog_cache_use";
126 Variable_name Value
127 Binlog_cache_use 0
128 show status like "binlog_cache_disk_use";
129 Variable_name Value
130 Binlog_cache_disk_use 0
131 create table t1 (a int) engine=innodb;
132 show status like "binlog_cache_use";
133 Variable_name Value
134 Binlog_cache_use 2
135 show status like "binlog_cache_disk_use";
136 Variable_name Value
137 Binlog_cache_disk_use 1
138 begin;
139 delete from t1;
140 commit;
141 show status like "binlog_cache_use";
142 Variable_name Value
143 Binlog_cache_use 3
144 show status like "binlog_cache_disk_use";
145 Variable_name Value
146 Binlog_cache_disk_use 1
147 drop table t1;
148 End of tests