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 +