• 's avatar
    Bug #50407 mysqlbinlog --database=X produces bad output for SAVEPOINTs · 2049d1af
    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;
    2049d1af
mysqlbinlog.result 22.4 KB