Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL)
-
None
-
Cent OS 6.6, MariaDB 10.0.22
Description
Hi, All
set global binlog_annotate_row_events = 1;
|
CREATE TABLE `test11` (`id` int(11) NOT NULL,
|
`c1` int(11) DEFAULT NULL, PRIMARY KEY (`id`)
|
) ENGINE=InnoDB;
|
|
|
insert into test11 values (99,10)
|
on duplicate key update c1= c1 + 99;
|
|
|
insert into test11 values (99,10)
|
on duplicate key update c1= c1 + 9;
|
mysqlbinlog -vv mysql-bin.000009 , below red statement‘s length decrease one-digit than true length
|
....................
#151124 21:42:58 server id 5182 end_log_pos 1326 CRC32 0x4c49ef1e Annotate_rows:
#Q> insert into test11 values (99,10)
#Q> on duplicate key update c1= c1 + 9
....................
#151124 21:54:53 server id 5182 end_log_pos 1592 CRC32 0x2e42e7e6 Annotate_rows:
#Q> insert into test11 values (99,10)
#Q> on duplicate key update c1= c1 +
Attachments
Activity
alice, seeing your activity on the bug, does it really applies only 10.2 as of now?
This case may relate to a recent 10.4 support issue, so it'd be of great help if you could you try reproducing it on that version too (take angelique.sklavounos for training)?
Automated message:
----------------------------
Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.
Thanks for the report.
Apparently, it's not one symbol, it's more like "one symbol for each new line in the statement" (maybe something other than a new line can cause it too, I didn't check).
Test case
--source include/have_binlog_format_row.incset binlog_annotate_row_events = 1;create table t1 (i int);insert into t1 (i)values(1),(2),(3),(444444);flush binary logs;--let $datadir= `select @@datadir`--exec $MYSQL_BINLOG -vv $datadir/master-bin.000001drop table t1;Annotate output
#151225 21:06:52 server id 1 end_log_pos 544 Annotate_rows:#Q> insert into t1 (i)#Q> values#Q> (1),#Q> (2),#Q> (3),#Q> (44