| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection master] |
| 6 |
# Test non-transaction |
| 7 |
create table t1(a int, b int) engine= myisam; |
| 8 |
insert into t1(a,b) values(1,1),(2,1); |
| 9 |
update t1 set a = a + 5 where b = 1 LIMIT 1; |
| 10 |
delete from t1 where a = 6; |
| 11 |
# Test transaction |
| 12 |
create table t2(a int, b int) engine=innodb; |
| 13 |
begin; |
| 14 |
insert into t2(a,b) values(2,1),(3,1); |
| 15 |
update t2 set a = a + 5 where b = 1; |
| 16 |
delete from t2 where a = 7; |
| 17 |
commit; |
| 18 |
# Test mixed transaction |
| 19 |
begin; |
| 20 |
insert into t1(a,b) values(1,5); |
| 21 |
insert into t2(a,b) values(2,5); |
| 22 |
insert into t2(a,b) values(2,6); |
| 23 |
insert into t1(a,b) values(1,7); |
| 24 |
commit; |
| 25 |
drop table t1, t2; |
| 26 |
create table t3(a int, b int) engine= myisam; |
| 27 |
create table t4(a int, b int) engine= myisam; |
| 28 |
create table t5(a int, b int) engine= myisam; |
| 29 |
insert into t3(a, b) values(1,1); |
| 30 |
# Test the Rows_query log event will be filtered out if slave applys |
| 31 |
# '--replicate-ignore-table' option on the table |
| 32 |
insert into t4(a, b) values(2,1); |
| 33 |
# Test the Rows_query log event will be relayed if slave |
| 34 |
# filters out part Rows event from a rows statement |
| 35 |
update t3,t4 set t3.a=3, t4.a=4 where t3.b=t4.b; |
| 36 |
# Test the Rows_query log event will be filtered out if slave applys |
| 37 |
# '--replicate-wild-ignore-table' option on the table |
| 38 |
insert into t5(a, b) values(3,1); |
| 39 |
# Test the Rows_query log event will be filtered out if slave filters |
| 40 |
# out all its related tables by replication filtering rules |
| 41 |
update t4,t5 set t4.a=4, t5.a=5 where t4.b=t5.b; |
| 42 |
FLUSH TABLES; |
| 43 |
# Test load data infile |
| 44 |
create table t6(a VARCHAR(60)) engine= myisam; |
| 45 |
load data infile '../../std_data/words.dat' into table t6; |
| 46 |
drop table t3, t6; |
| 47 |
drop table t4, t5; |
| 48 |
# SHOW BINLOG EVENTS ON MASTER before '--exec MYSQL_BINLOG' |
| 49 |
include/show_binlog_events.inc |
| 50 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 51 |
master-bin.000001 # Query # # use `test`; create table t1(a int, b int) engine= myisam |
| 52 |
master-bin.000001 # Query # # BEGIN |
| 53 |
master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,1),(2,1) |
| 54 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 55 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 56 |
master-bin.000001 # Query # # COMMIT |
| 57 |
master-bin.000001 # Query # # BEGIN |
| 58 |
master-bin.000001 # Rows_query # # # update t1 set a = a + 5 where b = 1 LIMIT 1 |
| 59 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 60 |
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F |
| 61 |
master-bin.000001 # Query # # COMMIT |
| 62 |
master-bin.000001 # Query # # BEGIN |
| 63 |
master-bin.000001 # Rows_query # # # delete from t1 where a = 6 |
| 64 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 65 |
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F |
| 66 |
master-bin.000001 # Query # # COMMIT |
| 67 |
master-bin.000001 # Query # # use `test`; create table t2(a int, b int) engine=innodb |
| 68 |
master-bin.000001 # Query # # BEGIN |
| 69 |
master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,1),(3,1) |
| 70 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 71 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 72 |
master-bin.000001 # Rows_query # # # update t2 set a = a + 5 where b = 1 |
| 73 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 74 |
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F |
| 75 |
master-bin.000001 # Rows_query # # # delete from t2 where a = 7 |
| 76 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 77 |
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F |
| 78 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 79 |
master-bin.000001 # Query # # BEGIN |
| 80 |
master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,5) |
| 81 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 82 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 83 |
master-bin.000001 # Query # # COMMIT |
| 84 |
master-bin.000001 # Query # # BEGIN |
| 85 |
master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,7) |
| 86 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 87 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 88 |
master-bin.000001 # Query # # COMMIT |
| 89 |
master-bin.000001 # Query # # BEGIN |
| 90 |
master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,5) |
| 91 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 92 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 93 |
master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,6) |
| 94 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 95 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 96 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 97 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ |
| 98 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */ |
| 99 |
master-bin.000001 # Query # # use `test`; create table t3(a int, b int) engine= myisam |
| 100 |
master-bin.000001 # Query # # use `test`; create table t4(a int, b int) engine= myisam |
| 101 |
master-bin.000001 # Query # # use `test`; create table t5(a int, b int) engine= myisam |
| 102 |
master-bin.000001 # Query # # BEGIN |
| 103 |
master-bin.000001 # Rows_query # # # insert into t3(a, b) values(1,1) |
| 104 |
master-bin.000001 # Table_map # # table_id: # (test.t3) |
| 105 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 106 |
master-bin.000001 # Query # # COMMIT |
| 107 |
master-bin.000001 # Query # # BEGIN |
| 108 |
master-bin.000001 # Rows_query # # # insert into t4(a, b) values(2,1) |
| 109 |
master-bin.000001 # Table_map # # table_id: # (test.t4) |
| 110 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 111 |
master-bin.000001 # Query # # COMMIT |
| 112 |
master-bin.000001 # Query # # BEGIN |
| 113 |
master-bin.000001 # Rows_query # # # update t3,t4 set t3.a=3, t4.a=4 where t3.b=t4.b |
| 114 |
master-bin.000001 # Table_map # # table_id: # (test.t3) |
| 115 |
master-bin.000001 # Table_map # # table_id: # (test.t4) |
| 116 |
master-bin.000001 # Update_rows # # table_id: # |
| 117 |
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F |
| 118 |
master-bin.000001 # Query # # COMMIT |
| 119 |
master-bin.000001 # Query # # BEGIN |
| 120 |
master-bin.000001 # Rows_query # # # insert into t5(a, b) values(3,1) |
| 121 |
master-bin.000001 # Table_map # # table_id: # (test.t5) |
| 122 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 123 |
master-bin.000001 # Query # # COMMIT |
| 124 |
master-bin.000001 # Query # # BEGIN |
| 125 |
master-bin.000001 # Rows_query # # # update t4,t5 set t4.a=4, t5.a=5 where t4.b=t5.b |
| 126 |
master-bin.000001 # Table_map # # table_id: # (test.t4) |
| 127 |
master-bin.000001 # Table_map # # table_id: # (test.t5) |
| 128 |
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F |
| 129 |
master-bin.000001 # Query # # COMMIT |
| 130 |
master-bin.000001 # Query # # use `test`; FLUSH TABLES |
| 131 |
master-bin.000001 # Query # # use `test`; create table t6(a VARCHAR(60)) engine= myisam |
| 132 |
master-bin.000001 # Query # # BEGIN |
| 133 |
master-bin.000001 # Rows_query # # # load data infile '../../std_data/words.dat' into table t6 |
| 134 |
master-bin.000001 # Table_map # # table_id: # (test.t6) |
| 135 |
master-bin.000001 # Write_rows # # table_id: # |
| 136 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 137 |
master-bin.000001 # Query # # COMMIT |
| 138 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t3` /* generated by server */ |
| 139 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t6` /* generated by server */ |
| 140 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t4` /* generated by server */ |
| 141 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t5` /* generated by server */ |
| 142 |
FLUSH LOGS; |
| 143 |
RESET MASTER; |
| 144 |
# MYSQL_BINLOG output based on a saved copy of master-bin.000001 |
| 145 |
include/mysqlbinlog.inc |
| 146 |
# The proper term is pseudo_replica_mode, but we use this compatibility alias |
| 147 |
# to make the statement usable on server versions 8.0.24 and older. |
| 148 |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; |
| 149 |
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; |
| 150 |
DELIMITER /*!*/; |
| 151 |
# at # |
| 152 |
# # server id # end_log_pos # CRC32 # Start: binlog v #, server v # created # at startup |
| 153 |
ROLLBACK/*!*/; |
| 154 |
# at # |
| 155 |
# # server id # end_log_pos # CRC32 # Previous-GTIDs |
| 156 |
# [empty] |
| 157 |
# at # |
| 158 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 159 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 160 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 161 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 162 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 163 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 164 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 165 |
# at # |
| 166 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 167 |
use `test`/*!*/; |
| 168 |
SET TIMESTAMP=#/*!*/; |
| 169 |
SET @@session.pseudo_thread_id=#/*!*/; |
| 170 |
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; |
| 171 |
SET @@session.sql_mode=1168113696/*!*/; |
| 172 |
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; |
| 173 |
/*!\C utf8mb4 *//*!*/; |
| 174 |
SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/; |
| 175 |
SET @@session.lc_time_names=0/*!*/; |
| 176 |
SET @@session.collation_database=DEFAULT/*!*/; |
| 177 |
/*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/; |
| 178 |
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/; |
| 179 |
create table t1(a int, b int) engine= myisam |
| 180 |
/*!*/; |
| 181 |
# at # |
| 182 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 183 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 184 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 185 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 186 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 187 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 188 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 189 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 190 |
# at # |
| 191 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 192 |
SET TIMESTAMP=#/*!*/; |
| 193 |
BEGIN |
| 194 |
/*!*/; |
| 195 |
# at # |
| 196 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 197 |
# insert into t1(a,b) values(1,1),(2,1) |
| 198 |
# at # |
| 199 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number # |
| 200 |
# has_generated_invisible_primary_key=0 |
| 201 |
# at # |
| 202 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 203 |
### INSERT INTO `test`.`t1` |
| 204 |
### SET |
| 205 |
### @1=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 206 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 207 |
### INSERT INTO `test`.`t1` |
| 208 |
### SET |
| 209 |
### @1=2 /* INT meta=0 nullable=1 is_null=0 */ |
| 210 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 211 |
# at # |
| 212 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 213 |
SET TIMESTAMP=#/*!*/; |
| 214 |
COMMIT |
| 215 |
/*!*/; |
| 216 |
# at # |
| 217 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 218 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 219 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 220 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 221 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 222 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 223 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 224 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 225 |
# at # |
| 226 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 227 |
SET TIMESTAMP=#/*!*/; |
| 228 |
BEGIN |
| 229 |
/*!*/; |
| 230 |
# at # |
| 231 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 232 |
# update t1 set a = a + 5 where b = 1 LIMIT 1 |
| 233 |
# at # |
| 234 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number # |
| 235 |
# has_generated_invisible_primary_key=0 |
| 236 |
# at # |
| 237 |
# # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F |
| 238 |
### UPDATE `test`.`t1` |
| 239 |
### WHERE |
| 240 |
### @1=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 241 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 242 |
### SET |
| 243 |
### @1=6 /* INT meta=0 nullable=1 is_null=0 */ |
| 244 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 245 |
# at # |
| 246 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 247 |
SET TIMESTAMP=#/*!*/; |
| 248 |
COMMIT |
| 249 |
/*!*/; |
| 250 |
# at # |
| 251 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 252 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 253 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 254 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 255 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 256 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 257 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 258 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 259 |
# at # |
| 260 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 261 |
SET TIMESTAMP=#/*!*/; |
| 262 |
BEGIN |
| 263 |
/*!*/; |
| 264 |
# at # |
| 265 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 266 |
# delete from t1 where a = 6 |
| 267 |
# at # |
| 268 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number # |
| 269 |
# has_generated_invisible_primary_key=0 |
| 270 |
# at # |
| 271 |
# # server id # end_log_pos # CRC32 # Delete_rows: table id # flags: STMT_END_F |
| 272 |
### DELETE FROM `test`.`t1` |
| 273 |
### WHERE |
| 274 |
### @1=6 /* INT meta=0 nullable=1 is_null=0 */ |
| 275 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 276 |
# at # |
| 277 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 278 |
SET TIMESTAMP=#/*!*/; |
| 279 |
COMMIT |
| 280 |
/*!*/; |
| 281 |
# at # |
| 282 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 283 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 284 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 285 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 286 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 287 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 288 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 289 |
# at # |
| 290 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = # |
| 291 |
SET TIMESTAMP=#/*!*/; |
| 292 |
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/; |
| 293 |
create table t2(a int, b int) engine=innodb |
| 294 |
/*!*/; |
| 295 |
# at # |
| 296 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 297 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 298 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 299 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 300 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 301 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 302 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 303 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 304 |
# at # |
| 305 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 306 |
SET TIMESTAMP=#/*!*/; |
| 307 |
BEGIN |
| 308 |
/*!*/; |
| 309 |
# at # |
| 310 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 311 |
# insert into t2(a,b) values(2,1),(3,1) |
| 312 |
# at # |
| 313 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number # |
| 314 |
# has_generated_invisible_primary_key=0 |
| 315 |
# at # |
| 316 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 317 |
### INSERT INTO `test`.`t2` |
| 318 |
### SET |
| 319 |
### @1=2 /* INT meta=0 nullable=1 is_null=0 */ |
| 320 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 321 |
### INSERT INTO `test`.`t2` |
| 322 |
### SET |
| 323 |
### @1=3 /* INT meta=0 nullable=1 is_null=0 */ |
| 324 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 325 |
# at # |
| 326 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 327 |
# update t2 set a = a + 5 where b = 1 |
| 328 |
# at # |
| 329 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number # |
| 330 |
# has_generated_invisible_primary_key=0 |
| 331 |
# at # |
| 332 |
# # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F |
| 333 |
### UPDATE `test`.`t2` |
| 334 |
### WHERE |
| 335 |
### @1=2 /* INT meta=0 nullable=1 is_null=0 */ |
| 336 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 337 |
### SET |
| 338 |
### @1=7 /* INT meta=0 nullable=1 is_null=0 */ |
| 339 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 340 |
### UPDATE `test`.`t2` |
| 341 |
### WHERE |
| 342 |
### @1=3 /* INT meta=0 nullable=1 is_null=0 */ |
| 343 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 344 |
### SET |
| 345 |
### @1=8 /* INT meta=0 nullable=1 is_null=0 */ |
| 346 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 347 |
# at # |
| 348 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 349 |
# delete from t2 where a = 7 |
| 350 |
# at # |
| 351 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number # |
| 352 |
# has_generated_invisible_primary_key=0 |
| 353 |
# at # |
| 354 |
# # server id # end_log_pos # CRC32 # Delete_rows: table id # flags: STMT_END_F |
| 355 |
### DELETE FROM `test`.`t2` |
| 356 |
### WHERE |
| 357 |
### @1=7 /* INT meta=0 nullable=1 is_null=0 */ |
| 358 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 359 |
# at # |
| 360 |
# # server id # end_log_pos # CRC32 # Xid = # |
| 361 |
COMMIT/*!*/; |
| 362 |
# at # |
| 363 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 364 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 365 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 366 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 367 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 368 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 369 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 370 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 371 |
# at # |
| 372 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 373 |
SET TIMESTAMP=#/*!*/; |
| 374 |
BEGIN |
| 375 |
/*!*/; |
| 376 |
# at # |
| 377 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 378 |
# insert into t1(a,b) values(1,5) |
| 379 |
# at # |
| 380 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number # |
| 381 |
# has_generated_invisible_primary_key=0 |
| 382 |
# at # |
| 383 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 384 |
### INSERT INTO `test`.`t1` |
| 385 |
### SET |
| 386 |
### @1=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 387 |
### @2=5 /* INT meta=0 nullable=1 is_null=0 */ |
| 388 |
# at # |
| 389 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 390 |
SET TIMESTAMP=#/*!*/; |
| 391 |
COMMIT |
| 392 |
/*!*/; |
| 393 |
# at # |
| 394 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 395 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 396 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 397 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 398 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 399 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 400 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 401 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 402 |
# at # |
| 403 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 404 |
SET TIMESTAMP=#/*!*/; |
| 405 |
BEGIN |
| 406 |
/*!*/; |
| 407 |
# at # |
| 408 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 409 |
# insert into t1(a,b) values(1,7) |
| 410 |
# at # |
| 411 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number # |
| 412 |
# has_generated_invisible_primary_key=0 |
| 413 |
# at # |
| 414 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 415 |
### INSERT INTO `test`.`t1` |
| 416 |
### SET |
| 417 |
### @1=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 418 |
### @2=7 /* INT meta=0 nullable=1 is_null=0 */ |
| 419 |
# at # |
| 420 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 421 |
SET TIMESTAMP=#/*!*/; |
| 422 |
COMMIT |
| 423 |
/*!*/; |
| 424 |
# at # |
| 425 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 426 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 427 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 428 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 429 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 430 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 431 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 432 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 433 |
# at # |
| 434 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 435 |
SET TIMESTAMP=#/*!*/; |
| 436 |
BEGIN |
| 437 |
/*!*/; |
| 438 |
# at # |
| 439 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 440 |
# insert into t2(a,b) values(2,5) |
| 441 |
# at # |
| 442 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number # |
| 443 |
# has_generated_invisible_primary_key=0 |
| 444 |
# at # |
| 445 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 446 |
### INSERT INTO `test`.`t2` |
| 447 |
### SET |
| 448 |
### @1=2 /* INT meta=0 nullable=1 is_null=0 */ |
| 449 |
### @2=5 /* INT meta=0 nullable=1 is_null=0 */ |
| 450 |
# at # |
| 451 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 452 |
# insert into t2(a,b) values(2,6) |
| 453 |
# at # |
| 454 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number # |
| 455 |
# has_generated_invisible_primary_key=0 |
| 456 |
# at # |
| 457 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 458 |
### INSERT INTO `test`.`t2` |
| 459 |
### SET |
| 460 |
### @1=2 /* INT meta=0 nullable=1 is_null=0 */ |
| 461 |
### @2=6 /* INT meta=0 nullable=1 is_null=0 */ |
| 462 |
# at # |
| 463 |
# # server id # end_log_pos # CRC32 # Xid = # |
| 464 |
COMMIT/*!*/; |
| 465 |
# at # |
| 466 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 467 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 468 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 469 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 470 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 471 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 472 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 473 |
# at # |
| 474 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 475 |
SET TIMESTAMP=#/*!*/; |
| 476 |
DROP TABLE `t1` /* generated by server */ |
| 477 |
/*!*/; |
| 478 |
# at # |
| 479 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 480 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 481 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 482 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 483 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 484 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 485 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 486 |
# at # |
| 487 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = # |
| 488 |
SET TIMESTAMP=#/*!*/; |
| 489 |
DROP TABLE `t2` /* generated by server */ |
| 490 |
/*!*/; |
| 491 |
# at # |
| 492 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 493 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 494 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 495 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 496 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 497 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 498 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 499 |
# at # |
| 500 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 501 |
SET TIMESTAMP=#/*!*/; |
| 502 |
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/; |
| 503 |
create table t3(a int, b int) engine= myisam |
| 504 |
/*!*/; |
| 505 |
# at # |
| 506 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 507 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 508 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 509 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 510 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 511 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 512 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 513 |
# at # |
| 514 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 515 |
SET TIMESTAMP=#/*!*/; |
| 516 |
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/; |
| 517 |
create table t4(a int, b int) engine= myisam |
| 518 |
/*!*/; |
| 519 |
# at # |
| 520 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 521 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 522 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 523 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 524 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 525 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 526 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 527 |
# at # |
| 528 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 529 |
SET TIMESTAMP=#/*!*/; |
| 530 |
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/; |
| 531 |
create table t5(a int, b int) engine= myisam |
| 532 |
/*!*/; |
| 533 |
# at # |
| 534 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 535 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 536 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 537 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 538 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 539 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 540 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 541 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 542 |
# at # |
| 543 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 544 |
SET TIMESTAMP=#/*!*/; |
| 545 |
BEGIN |
| 546 |
/*!*/; |
| 547 |
# at # |
| 548 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 549 |
# insert into t3(a, b) values(1,1) |
| 550 |
# at # |
| 551 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t3` mapped to number # |
| 552 |
# has_generated_invisible_primary_key=0 |
| 553 |
# at # |
| 554 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 555 |
### INSERT INTO `test`.`t3` |
| 556 |
### SET |
| 557 |
### @1=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 558 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 559 |
# at # |
| 560 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 561 |
SET TIMESTAMP=#/*!*/; |
| 562 |
COMMIT |
| 563 |
/*!*/; |
| 564 |
# at # |
| 565 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 566 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 567 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 568 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 569 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 570 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 571 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 572 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 573 |
# at # |
| 574 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 575 |
SET TIMESTAMP=#/*!*/; |
| 576 |
BEGIN |
| 577 |
/*!*/; |
| 578 |
# at # |
| 579 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 580 |
# insert into t4(a, b) values(2,1) |
| 581 |
# at # |
| 582 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t4` mapped to number # |
| 583 |
# has_generated_invisible_primary_key=0 |
| 584 |
# at # |
| 585 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 586 |
### INSERT INTO `test`.`t4` |
| 587 |
### SET |
| 588 |
### @1=2 /* INT meta=0 nullable=1 is_null=0 */ |
| 589 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 590 |
# at # |
| 591 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 592 |
SET TIMESTAMP=#/*!*/; |
| 593 |
COMMIT |
| 594 |
/*!*/; |
| 595 |
# at # |
| 596 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 597 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 598 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 599 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 600 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 601 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 602 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 603 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 604 |
# at # |
| 605 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 606 |
SET TIMESTAMP=#/*!*/; |
| 607 |
BEGIN |
| 608 |
/*!*/; |
| 609 |
# at # |
| 610 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 611 |
# update t3,t4 set t3.a=3, t4.a=4 where t3.b=t4.b |
| 612 |
# at # |
| 613 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t3` mapped to number # |
| 614 |
# has_generated_invisible_primary_key=0 |
| 615 |
# at # |
| 616 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t4` mapped to number # |
| 617 |
# has_generated_invisible_primary_key=0 |
| 618 |
# at # |
| 619 |
# # server id # end_log_pos # CRC32 # Update_rows: table id # |
| 620 |
# at # |
| 621 |
# # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F |
| 622 |
### UPDATE `test`.`t3` |
| 623 |
### WHERE |
| 624 |
### @1=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 625 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 626 |
### SET |
| 627 |
### @1=3 /* INT meta=0 nullable=1 is_null=0 */ |
| 628 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 629 |
### UPDATE `test`.`t4` |
| 630 |
### WHERE |
| 631 |
### @1=2 /* INT meta=0 nullable=1 is_null=0 */ |
| 632 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 633 |
### SET |
| 634 |
### @1=4 /* INT meta=0 nullable=1 is_null=0 */ |
| 635 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 636 |
# at # |
| 637 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 638 |
SET TIMESTAMP=#/*!*/; |
| 639 |
COMMIT |
| 640 |
/*!*/; |
| 641 |
# at # |
| 642 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 643 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 644 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 645 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 646 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 647 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 648 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 649 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 650 |
# at # |
| 651 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 652 |
SET TIMESTAMP=#/*!*/; |
| 653 |
BEGIN |
| 654 |
/*!*/; |
| 655 |
# at # |
| 656 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 657 |
# insert into t5(a, b) values(3,1) |
| 658 |
# at # |
| 659 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t5` mapped to number # |
| 660 |
# has_generated_invisible_primary_key=0 |
| 661 |
# at # |
| 662 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 663 |
### INSERT INTO `test`.`t5` |
| 664 |
### SET |
| 665 |
### @1=3 /* INT meta=0 nullable=1 is_null=0 */ |
| 666 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 667 |
# at # |
| 668 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 669 |
SET TIMESTAMP=#/*!*/; |
| 670 |
COMMIT |
| 671 |
/*!*/; |
| 672 |
# at # |
| 673 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 674 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 675 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 676 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 677 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 678 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 679 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 680 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 681 |
# at # |
| 682 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 683 |
SET TIMESTAMP=#/*!*/; |
| 684 |
BEGIN |
| 685 |
/*!*/; |
| 686 |
# at # |
| 687 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 688 |
# update t4,t5 set t4.a=4, t5.a=5 where t4.b=t5.b |
| 689 |
# at # |
| 690 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t4` mapped to number # |
| 691 |
# has_generated_invisible_primary_key=0 |
| 692 |
# at # |
| 693 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t5` mapped to number # |
| 694 |
# has_generated_invisible_primary_key=0 |
| 695 |
# at # |
| 696 |
# # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F |
| 697 |
### UPDATE `test`.`t5` |
| 698 |
### WHERE |
| 699 |
### @1=3 /* INT meta=0 nullable=1 is_null=0 */ |
| 700 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 701 |
### SET |
| 702 |
### @1=5 /* INT meta=0 nullable=1 is_null=0 */ |
| 703 |
### @2=1 /* INT meta=0 nullable=1 is_null=0 */ |
| 704 |
# at # |
| 705 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 706 |
SET TIMESTAMP=#/*!*/; |
| 707 |
COMMIT |
| 708 |
/*!*/; |
| 709 |
# at # |
| 710 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 711 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 712 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 713 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 714 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 715 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 716 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 717 |
# at # |
| 718 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 719 |
SET TIMESTAMP=#/*!*/; |
| 720 |
FLUSH TABLES |
| 721 |
/*!*/; |
| 722 |
# at # |
| 723 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 724 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 725 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 726 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 727 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 728 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 729 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 730 |
# at # |
| 731 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 732 |
SET TIMESTAMP=#/*!*/; |
| 733 |
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/; |
| 734 |
create table t6(a VARCHAR(60)) engine= myisam |
| 735 |
/*!*/; |
| 736 |
# at # |
| 737 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 738 |
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; |
| 739 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 740 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 741 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 742 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 743 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 744 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 745 |
# at # |
| 746 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 747 |
SET TIMESTAMP=#/*!*/; |
| 748 |
BEGIN |
| 749 |
/*!*/; |
| 750 |
# at # |
| 751 |
# # server id # end_log_pos # CRC32 # Rows_query |
| 752 |
# load data infile '../../std_data/words.dat' into table t6 |
| 753 |
# at # |
| 754 |
# # server id # end_log_pos # CRC32 # Table_map: `test`.`t6` mapped to number # |
| 755 |
# has_generated_invisible_primary_key=0 |
| 756 |
# at # |
| 757 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # |
| 758 |
# at # |
| 759 |
# # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F |
| 760 |
### INSERT INTO `test`.`t6` |
| 761 |
### SET |
| 762 |
### @1='Aarhus' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 763 |
### INSERT INTO `test`.`t6` |
| 764 |
### SET |
| 765 |
### @1='Aaron' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 766 |
### INSERT INTO `test`.`t6` |
| 767 |
### SET |
| 768 |
### @1='Ababa' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 769 |
### INSERT INTO `test`.`t6` |
| 770 |
### SET |
| 771 |
### @1='aback' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 772 |
### INSERT INTO `test`.`t6` |
| 773 |
### SET |
| 774 |
### @1='abaft' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 775 |
### INSERT INTO `test`.`t6` |
| 776 |
### SET |
| 777 |
### @1='abandon' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 778 |
### INSERT INTO `test`.`t6` |
| 779 |
### SET |
| 780 |
### @1='abandoned' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 781 |
### INSERT INTO `test`.`t6` |
| 782 |
### SET |
| 783 |
### @1='abandoning' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 784 |
### INSERT INTO `test`.`t6` |
| 785 |
### SET |
| 786 |
### @1='abandonment' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 787 |
### INSERT INTO `test`.`t6` |
| 788 |
### SET |
| 789 |
### @1='abandons' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 790 |
### INSERT INTO `test`.`t6` |
| 791 |
### SET |
| 792 |
### @1='Aarhus' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 793 |
### INSERT INTO `test`.`t6` |
| 794 |
### SET |
| 795 |
### @1='Aaron' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 796 |
### INSERT INTO `test`.`t6` |
| 797 |
### SET |
| 798 |
### @1='Ababa' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 799 |
### INSERT INTO `test`.`t6` |
| 800 |
### SET |
| 801 |
### @1='aback' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 802 |
### INSERT INTO `test`.`t6` |
| 803 |
### SET |
| 804 |
### @1='abaft' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 805 |
### INSERT INTO `test`.`t6` |
| 806 |
### SET |
| 807 |
### @1='abandon' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 808 |
### INSERT INTO `test`.`t6` |
| 809 |
### SET |
| 810 |
### @1='abandoned' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 811 |
### INSERT INTO `test`.`t6` |
| 812 |
### SET |
| 813 |
### @1='abandoning' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 814 |
### INSERT INTO `test`.`t6` |
| 815 |
### SET |
| 816 |
### @1='abandonment' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 817 |
### INSERT INTO `test`.`t6` |
| 818 |
### SET |
| 819 |
### @1='abandons' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 820 |
### INSERT INTO `test`.`t6` |
| 821 |
### SET |
| 822 |
### @1='abase' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 823 |
### INSERT INTO `test`.`t6` |
| 824 |
### SET |
| 825 |
### @1='abased' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 826 |
### INSERT INTO `test`.`t6` |
| 827 |
### SET |
| 828 |
### @1='abasement' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 829 |
### INSERT INTO `test`.`t6` |
| 830 |
### SET |
| 831 |
### @1='abasements' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 832 |
### INSERT INTO `test`.`t6` |
| 833 |
### SET |
| 834 |
### @1='abases' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 835 |
### INSERT INTO `test`.`t6` |
| 836 |
### SET |
| 837 |
### @1='abash' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 838 |
### INSERT INTO `test`.`t6` |
| 839 |
### SET |
| 840 |
### @1='abashed' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 841 |
### INSERT INTO `test`.`t6` |
| 842 |
### SET |
| 843 |
### @1='abashes' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 844 |
### INSERT INTO `test`.`t6` |
| 845 |
### SET |
| 846 |
### @1='abashing' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 847 |
### INSERT INTO `test`.`t6` |
| 848 |
### SET |
| 849 |
### @1='abasing' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 850 |
### INSERT INTO `test`.`t6` |
| 851 |
### SET |
| 852 |
### @1='abate' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 853 |
### INSERT INTO `test`.`t6` |
| 854 |
### SET |
| 855 |
### @1='abated' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 856 |
### INSERT INTO `test`.`t6` |
| 857 |
### SET |
| 858 |
### @1='abatement' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 859 |
### INSERT INTO `test`.`t6` |
| 860 |
### SET |
| 861 |
### @1='abatements' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 862 |
### INSERT INTO `test`.`t6` |
| 863 |
### SET |
| 864 |
### @1='abater' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 865 |
### INSERT INTO `test`.`t6` |
| 866 |
### SET |
| 867 |
### @1='abates' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 868 |
### INSERT INTO `test`.`t6` |
| 869 |
### SET |
| 870 |
### @1='abating' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 871 |
### INSERT INTO `test`.`t6` |
| 872 |
### SET |
| 873 |
### @1='Abba' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 874 |
### INSERT INTO `test`.`t6` |
| 875 |
### SET |
| 876 |
### @1='abbe' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 877 |
### INSERT INTO `test`.`t6` |
| 878 |
### SET |
| 879 |
### @1='abbey' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 880 |
### INSERT INTO `test`.`t6` |
| 881 |
### SET |
| 882 |
### @1='abbeys' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 883 |
### INSERT INTO `test`.`t6` |
| 884 |
### SET |
| 885 |
### @1='abbot' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 886 |
### INSERT INTO `test`.`t6` |
| 887 |
### SET |
| 888 |
### @1='abbots' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 889 |
### INSERT INTO `test`.`t6` |
| 890 |
### SET |
| 891 |
### @1='Abbott' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 892 |
### INSERT INTO `test`.`t6` |
| 893 |
### SET |
| 894 |
### @1='abbreviate' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 895 |
### INSERT INTO `test`.`t6` |
| 896 |
### SET |
| 897 |
### @1='abbreviated' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 898 |
### INSERT INTO `test`.`t6` |
| 899 |
### SET |
| 900 |
### @1='abbreviates' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 901 |
### INSERT INTO `test`.`t6` |
| 902 |
### SET |
| 903 |
### @1='abbreviating' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 904 |
### INSERT INTO `test`.`t6` |
| 905 |
### SET |
| 906 |
### @1='abbreviation' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 907 |
### INSERT INTO `test`.`t6` |
| 908 |
### SET |
| 909 |
### @1='abbreviations' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 910 |
### INSERT INTO `test`.`t6` |
| 911 |
### SET |
| 912 |
### @1='Abby' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 913 |
### INSERT INTO `test`.`t6` |
| 914 |
### SET |
| 915 |
### @1='abdomen' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 916 |
### INSERT INTO `test`.`t6` |
| 917 |
### SET |
| 918 |
### @1='abdomens' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 919 |
### INSERT INTO `test`.`t6` |
| 920 |
### SET |
| 921 |
### @1='abdominal' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 922 |
### INSERT INTO `test`.`t6` |
| 923 |
### SET |
| 924 |
### @1='abduct' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 925 |
### INSERT INTO `test`.`t6` |
| 926 |
### SET |
| 927 |
### @1='abducted' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 928 |
### INSERT INTO `test`.`t6` |
| 929 |
### SET |
| 930 |
### @1='abduction' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 931 |
### INSERT INTO `test`.`t6` |
| 932 |
### SET |
| 933 |
### @1='abductions' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 934 |
### INSERT INTO `test`.`t6` |
| 935 |
### SET |
| 936 |
### @1='abductor' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 937 |
### INSERT INTO `test`.`t6` |
| 938 |
### SET |
| 939 |
### @1='abductors' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 940 |
### INSERT INTO `test`.`t6` |
| 941 |
### SET |
| 942 |
### @1='abducts' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 943 |
### INSERT INTO `test`.`t6` |
| 944 |
### SET |
| 945 |
### @1='Abe' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 946 |
### INSERT INTO `test`.`t6` |
| 947 |
### SET |
| 948 |
### @1='abed' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 949 |
### INSERT INTO `test`.`t6` |
| 950 |
### SET |
| 951 |
### @1='Abel' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 952 |
### INSERT INTO `test`.`t6` |
| 953 |
### SET |
| 954 |
### @1='Abelian' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 955 |
### INSERT INTO `test`.`t6` |
| 956 |
### SET |
| 957 |
### @1='Abelson' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 958 |
### INSERT INTO `test`.`t6` |
| 959 |
### SET |
| 960 |
### @1='Aberdeen' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 961 |
### INSERT INTO `test`.`t6` |
| 962 |
### SET |
| 963 |
### @1='Abernathy' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 964 |
### INSERT INTO `test`.`t6` |
| 965 |
### SET |
| 966 |
### @1='aberrant' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 967 |
### INSERT INTO `test`.`t6` |
| 968 |
### SET |
| 969 |
### @1='aberration' /* VARSTRING(240) meta=240 nullable=1 is_null=0 */ |
| 970 |
# at # |
| 971 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 972 |
SET TIMESTAMP=#/*!*/; |
| 973 |
COMMIT |
| 974 |
/*!*/; |
| 975 |
# at # |
| 976 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 977 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 978 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 979 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 980 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 981 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 982 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 983 |
# at # |
| 984 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 985 |
SET TIMESTAMP=#/*!*/; |
| 986 |
DROP TABLE `t3` /* generated by server */ |
| 987 |
/*!*/; |
| 988 |
# at # |
| 989 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 990 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 991 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 992 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 993 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 994 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 995 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 996 |
# at # |
| 997 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 998 |
SET TIMESTAMP=#/*!*/; |
| 999 |
DROP TABLE `t6` /* generated by server */ |
| 1000 |
/*!*/; |
| 1001 |
# at # |
| 1002 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 1003 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 1004 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 1005 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 1006 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 1007 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 1008 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 1009 |
# at # |
| 1010 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 1011 |
SET TIMESTAMP=#/*!*/; |
| 1012 |
DROP TABLE `t4` /* generated by server */ |
| 1013 |
/*!*/; |
| 1014 |
# at # |
| 1015 |
# # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=# |
| 1016 |
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 1017 |
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ) |
| 1018 |
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/; |
| 1019 |
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/; |
| 1020 |
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/; |
| 1021 |
SET @@SESSION.GTID_NEXT= '#'/*!*/; |
| 1022 |
# at # |
| 1023 |
# # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 |
| 1024 |
SET TIMESTAMP=#/*!*/; |
| 1025 |
DROP TABLE `t5` /* generated by server */ |
| 1026 |
/*!*/; |
| 1027 |
# at # |
| 1028 |
# # server id # end_log_pos # CRC32 # Rotate to master-bin.000002 pos: 4 |
| 1029 |
SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; |
| 1030 |
DELIMITER ; |
| 1031 |
# End of log file |
| 1032 |
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; |
| 1033 |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; |
| 1034 |
# Test the Rows_query log event can be applied |
| 1035 |
# SHOW BINLOG EVENTS ON MASTER after '--exec MYSQL_BINLOG' |
| 1036 |
include/show_binlog_events.inc |
| 1037 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1038 |
master-bin.000001 # Query # # use `test`; create table t1(a int, b int) engine= myisam |
| 1039 |
master-bin.000001 # Query # # BEGIN |
| 1040 |
master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,1),(2,1) |
| 1041 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1042 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1043 |
master-bin.000001 # Query # # COMMIT |
| 1044 |
master-bin.000001 # Query # # BEGIN |
| 1045 |
master-bin.000001 # Rows_query # # # update t1 set a = a + 5 where b = 1 LIMIT 1 |
| 1046 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1047 |
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F |
| 1048 |
master-bin.000001 # Query # # COMMIT |
| 1049 |
master-bin.000001 # Query # # BEGIN |
| 1050 |
master-bin.000001 # Rows_query # # # delete from t1 where a = 6 |
| 1051 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1052 |
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F |
| 1053 |
master-bin.000001 # Query # # COMMIT |
| 1054 |
master-bin.000001 # Query # # use `test`; create table t2(a int, b int) engine=innodb |
| 1055 |
master-bin.000001 # Query # # BEGIN |
| 1056 |
master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,1),(3,1) |
| 1057 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1058 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1059 |
master-bin.000001 # Rows_query # # # update t2 set a = a + 5 where b = 1 |
| 1060 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1061 |
master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F |
| 1062 |
master-bin.000001 # Rows_query # # # delete from t2 where a = 7 |
| 1063 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1064 |
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F |
| 1065 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1066 |
master-bin.000001 # Query # # BEGIN |
| 1067 |
master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,5) |
| 1068 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1069 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1070 |
master-bin.000001 # Query # # COMMIT |
| 1071 |
master-bin.000001 # Query # # BEGIN |
| 1072 |
master-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,7) |
| 1073 |
master-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1074 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1075 |
master-bin.000001 # Query # # COMMIT |
| 1076 |
master-bin.000001 # Query # # BEGIN |
| 1077 |
master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,5) |
| 1078 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1079 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1080 |
master-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,6) |
| 1081 |
master-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1082 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1083 |
master-bin.000001 # Xid # # COMMIT /* XID */ |
| 1084 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ |
| 1085 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */ |
| 1086 |
# SHOW BINLOG EVENTS ON 2nd CONNECTION TO MASTE |
| 1087 |
set @@session.binlog_rows_query_log_events= off; |
| 1088 |
# Test statements from the 2nd connection have no comment event |
| 1089 |
# when setting binlog_rows_query_log_events= off |
| 1090 |
create table t7(a bigint) engine= myisam; |
| 1091 |
insert into t7(a) values(1),(2); |
| 1092 |
delete from t7 where a = 1; |
| 1093 |
set session binlog_format=mixed; |
| 1094 |
Warnings: |
| 1095 |
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release. |
| 1096 |
set @@session.binlog_rows_query_log_events= on; |
| 1097 |
# Test the comment event is sent in mixed mode for special |
| 1098 |
# functions when setting binlog_rows_query_log_events= on |
| 1099 |
insert into t7(a) values(UUID_SHORT()); |
| 1100 |
drop table t7; |
| 1101 |
include/show_binlog_events.inc |
| 1102 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1103 |
master-bin.000001 # Query # # use `test`; create table t7(a bigint) engine= myisam |
| 1104 |
master-bin.000001 # Query # # BEGIN |
| 1105 |
master-bin.000001 # Table_map # # table_id: # (test.t7) |
| 1106 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1107 |
master-bin.000001 # Query # # COMMIT |
| 1108 |
master-bin.000001 # Query # # BEGIN |
| 1109 |
master-bin.000001 # Table_map # # table_id: # (test.t7) |
| 1110 |
master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F |
| 1111 |
master-bin.000001 # Query # # COMMIT |
| 1112 |
master-bin.000001 # Query # # BEGIN |
| 1113 |
master-bin.000001 # Rows_query # # # insert into t7(a) values(UUID_SHORT()) |
| 1114 |
master-bin.000001 # Table_map # # table_id: # (test.t7) |
| 1115 |
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1116 |
master-bin.000001 # Query # # COMMIT |
| 1117 |
master-bin.000001 # Query # # use `test`; DROP TABLE `t7` /* generated by server */ |
| 1118 |
include/start_slave.inc |
| 1119 |
include/sync_slave_sql_with_master.inc |
| 1120 |
# Test The Rows_query log event can be relayed. |
| 1121 |
# SHOW BINLOG EVENTS ON SLAVE |
| 1122 |
include/show_binlog_events.inc |
| 1123 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 1124 |
slave-bin.000001 # Query # # use `test`; create table t1(a int, b int) engine= myisam |
| 1125 |
slave-bin.000001 # Query # # BEGIN |
| 1126 |
slave-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,1),(2,1) |
| 1127 |
slave-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1128 |
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1129 |
slave-bin.000001 # Query # # COMMIT |
| 1130 |
slave-bin.000001 # Query # # BEGIN |
| 1131 |
slave-bin.000001 # Rows_query # # # update t1 set a = a + 5 where b = 1 LIMIT 1 |
| 1132 |
slave-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1133 |
slave-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F |
| 1134 |
slave-bin.000001 # Query # # COMMIT |
| 1135 |
slave-bin.000001 # Query # # BEGIN |
| 1136 |
slave-bin.000001 # Rows_query # # # delete from t1 where a = 6 |
| 1137 |
slave-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1138 |
slave-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F |
| 1139 |
slave-bin.000001 # Query # # COMMIT |
| 1140 |
slave-bin.000001 # Query # # use `test`; create table t2(a int, b int) engine=innodb |
| 1141 |
slave-bin.000001 # Query # # BEGIN |
| 1142 |
slave-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,1),(3,1) |
| 1143 |
slave-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1144 |
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1145 |
slave-bin.000001 # Rows_query # # # update t2 set a = a + 5 where b = 1 |
| 1146 |
slave-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1147 |
slave-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F |
| 1148 |
slave-bin.000001 # Rows_query # # # delete from t2 where a = 7 |
| 1149 |
slave-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1150 |
slave-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F |
| 1151 |
slave-bin.000001 # Xid # # COMMIT /* XID */ |
| 1152 |
slave-bin.000001 # Query # # BEGIN |
| 1153 |
slave-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,5) |
| 1154 |
slave-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1155 |
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1156 |
slave-bin.000001 # Query # # COMMIT |
| 1157 |
slave-bin.000001 # Query # # BEGIN |
| 1158 |
slave-bin.000001 # Rows_query # # # insert into t1(a,b) values(1,7) |
| 1159 |
slave-bin.000001 # Table_map # # table_id: # (test.t1) |
| 1160 |
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1161 |
slave-bin.000001 # Query # # COMMIT |
| 1162 |
slave-bin.000001 # Query # # BEGIN |
| 1163 |
slave-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,5) |
| 1164 |
slave-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1165 |
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1166 |
slave-bin.000001 # Rows_query # # # insert into t2(a,b) values(2,6) |
| 1167 |
slave-bin.000001 # Table_map # # table_id: # (test.t2) |
| 1168 |
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1169 |
slave-bin.000001 # Xid # # COMMIT /* XID */ |
| 1170 |
slave-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ |
| 1171 |
slave-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */ |
| 1172 |
slave-bin.000001 # Query # # use `test`; create table t7(a bigint) engine= myisam |
| 1173 |
slave-bin.000001 # Query # # BEGIN |
| 1174 |
slave-bin.000001 # Table_map # # table_id: # (test.t7) |
| 1175 |
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1176 |
slave-bin.000001 # Query # # COMMIT |
| 1177 |
slave-bin.000001 # Query # # BEGIN |
| 1178 |
slave-bin.000001 # Table_map # # table_id: # (test.t7) |
| 1179 |
slave-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F |
| 1180 |
slave-bin.000001 # Query # # COMMIT |
| 1181 |
slave-bin.000001 # Query # # BEGIN |
| 1182 |
slave-bin.000001 # Rows_query # # # insert into t7(a) values(UUID_SHORT()) |
| 1183 |
slave-bin.000001 # Table_map # # table_id: # (test.t7) |
| 1184 |
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F |
| 1185 |
slave-bin.000001 # Query # # COMMIT |
| 1186 |
slave-bin.000001 # Query # # use `test`; DROP TABLE `t7` /* generated by server */ |
| 1187 |
include/rpl_end.inc |