• Sujatha Sivakumar's avatar
    Bug#11829838: ALTER TABLE NOT BINLOGGED WITH · 5745b67e
    Sujatha Sivakumar authored
    --BINLOG-IGNORE-DB AND FULLY QUALIFIED TABLE
          
    Problem:
    =======
    An ALTER TABLE statement is not written to binlog if server
    started with "--binlog-ignore-db some database" and 'fully
    qualified' table names are used in the ALTER TABLE statement
    altering table different from current database context.
          
    Analysis:
    ========
    The above mentioned problem not only affects "ALTER TABLE"
    statements but also to all kind of statements. Once the 
    current default database becomes "NULL" none of the 
    statements will be binlogged.
          
    The current behaviour is such that if the user has specified
    restrictions on which database needs to be replicated and the
    default db is not specified, then do not replicate.
    This means that "NULL" is considered to be equivalent to
    everything (default db = null implied ignore don't log the
    statement).
          
    Fix:
    ===
    "NULL" should not be considered as equivalent to everything.
    Since the filtering criteria is not equal to "NULL" the
    statement should be logged into binlog.
    5745b67e
rpl_loaddata_m.test 1.34 KB