DeNADev/HandlerSocket-Plugin-for-MySQL — Issue #76: The binlog execute time is wrong
Author: rj03hou
Created: 2012-02-22 11:00:48+00:00
State: open

# at 3739797
#700101 8:00:00 server id 211603306 end_log_pos 3739693 Delete_rows: table id 46 flags: STMT_END_F

BINLOG '
AAAAABNqz5wMLQAAAAcQOQAAAC4AAAAAAAEABHRlc3QABXRlc3QyAAIDAwAA
AAAAABlqz5wMJgAAAC0QOQAAAC4AAAAAAAEAAv/8DicAAAIAAAA=
'/*!*/;
### DELETE FROM test.test2
### WHERE
### @1=9998 /* INT meta=0 nullable=0 is_null=0 */
### @2=2 /* INT meta=0 nullable=0 is_null=0 */

# at 574
#700101 8:00:00 server id 211603306 end_log_pos 574 Table_map: `test`.`ctest` mapped to number 33
#700101 8:00:00 server id 211603306 end_log_pos 620 Write_rows: table id 33 flags: STMT_END_F

BINLOG '
AAAAABNqz5wMLgAAAD4CAAAAACEAAAAAAAEABHRlc3QABWN0ZXN0AAMIAwMAAA==
AAAAABdqz5wMLgAAAGwCAAAAACEAAAAAAAEAA//4UiHtMAAAAAABAAAAAgAAAA==
'/*!*/;
### INSERT INTO test.ctest
### SET
### @1=820846930 /* LONGINT meta=0 nullable=0 is_null=0 */
### @2=1 /* INT meta=0 nullable=0 is_null=0 */
### @3=2 /* INT meta=0 nullable=0 is_null=0 */
# at 620

the time of the execute is always "700101 8:00:00"

client:python,perl
server:Percona 5.5.17-55 5.5.17-55
compile handlersocket version:1.0.6-97-g0986a75