• unknown's avatar
    Bug #50407 mysqlbinlog --database=X produces bad output for SAVEPOINTs · 454c003a
    unknown authored
    When mysqlbinlog was given the --database=X flag, it always printed
    'ROLLBACK TO', but the corresponding 'SAVEPOINT' statement was not
    printed. The replicated filter(replicated-do/ignore-db) and binlog
    filter (binlog-do/ignore-db) has the same problem. They are solved
    in this patch together.
    
    After this patch, We always check whether the query is 'SAVEPOINT'
    statement or not. Because this is a literal check, 'SAVEPOINT' and
    'ROLLBACK TO' statements are also binlogged in uppercase with no
    any comments.
    
    The binlog before this patch can be handled correctly except one case
    that any comments are in front of the keywords. for example:
     /* bla bla */ SAVEPOINT a;
     /* bla bla */ ROLLBACK TO a;
    454c003a
rpl_innodb_mixed_dml.result 33.7 KB