mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
5530c5e38d
QUOTING IN REPLICATION Problem: Misquoting or unquoted identifiers may lead to incorrect statements to be logged to the binary log. Fix: we use specialized functions to append quoted identifiers in the statements generated by the server.
161 lines
2.7 KiB
Text
161 lines
2.7 KiB
Text
Verbose statements from : write-partial-row.binlog
|
|
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
|
|
stmt
|
|
### INSERT INTO `mysql`.`ndb_apply_status`
|
|
### SET
|
|
### @1=1
|
|
### @2=25769803786
|
|
### @3=''
|
|
### @4=0
|
|
### @5=0
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=3
|
|
### @2=3
|
|
### @3=3
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=1
|
|
### @2=1
|
|
### @3=1
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=2
|
|
### @2=2
|
|
### @3=2
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @3=40
|
|
### DELETE FROM `test`.`ba`
|
|
### WHERE
|
|
### @1=2
|
|
drop table raw_binlog_rows;
|
|
Verbose statements from : write-full-row.binlog
|
|
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
|
|
stmt
|
|
### INSERT INTO `mysql`.`ndb_apply_status`
|
|
### SET
|
|
### @1=2
|
|
### @2=25769803786
|
|
### @3=''
|
|
### @4=0
|
|
### @5=0
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=3
|
|
### @2=3
|
|
### @3=3
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=1
|
|
### @2=1
|
|
### @3=1
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=2
|
|
### @2=2
|
|
### @3=2
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=40
|
|
### DELETE FROM `test`.`ba`
|
|
### WHERE
|
|
### @1=2
|
|
drop table raw_binlog_rows;
|
|
Verbose statements from : update-partial-row.binlog
|
|
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
|
|
stmt
|
|
### INSERT INTO `mysql`.`ndb_apply_status`
|
|
### SET
|
|
### @1=3
|
|
### @2=25769803786
|
|
### @3=''
|
|
### @4=0
|
|
### @5=0
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=3
|
|
### @2=3
|
|
### @3=3
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=1
|
|
### @2=1
|
|
### @3=1
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=2
|
|
### @2=2
|
|
### @3=2
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### UPDATE `test`.`ba`
|
|
### WHERE
|
|
### @1=4
|
|
### @3=4
|
|
### SET
|
|
### @1=4
|
|
### @3=40
|
|
### DELETE FROM `test`.`ba`
|
|
### WHERE
|
|
### @1=2
|
|
drop table raw_binlog_rows;
|
|
Verbose statements from : update-full-row.binlog
|
|
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
|
|
stmt
|
|
### INSERT INTO `mysql`.`ndb_apply_status`
|
|
### SET
|
|
### @1=4
|
|
### @2=25769803786
|
|
### @3=''
|
|
### @4=0
|
|
### @5=0
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=3
|
|
### @2=3
|
|
### @3=3
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=1
|
|
### @2=1
|
|
### @3=1
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=2
|
|
### @2=2
|
|
### @3=2
|
|
### INSERT INTO `test`.`ba`
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### UPDATE `test`.`ba`
|
|
### WHERE
|
|
### @1=4
|
|
### @2=4
|
|
### @3=4
|
|
### SET
|
|
### @1=4
|
|
### @2=4
|
|
### @3=40
|
|
### DELETE FROM `test`.`ba`
|
|
### WHERE
|
|
### @1=2
|
|
drop table raw_binlog_rows;
|