• Davi Arnaut's avatar
    Bug#34306: Can't make copy of log tables when server binary log is enabled · 35ffaf10
    Davi Arnaut authored
    The problem is that when statement-based replication was enabled,
    statements such as INSERT INTO .. SELECT FROM .. and CREATE TABLE
    .. SELECT FROM need to grab a read lock on the source table that
    does not permit concurrent inserts, which would in turn be denied
    if the source table is a log table because log tables can't be
    locked exclusively.
    
    The solution is to not take such a lock when the source table is
    a log table as it is unsafe to replicate log tables under statement
    based replication. Furthermore, the read lock that does not permits
    concurrent inserts is now only taken if statement-based replication
    is enabled and if the source table is not a log table.
    35ffaf10
log_tables.test 30.5 KB