• Alfranio Correia's avatar
    BUG#50479 DDL stmt on row-only/stmt-only tables generate spurious binlog_format · 02fc237a
    Alfranio Correia authored
    errors
                
    In the fix of BUG#39934 in 5.1-rep+3, errors are generated when
    binlog_format=row and a statement modifies a table restricted to
    statement-logging (ER_BINLOG_ROW_MODE_AND_STMT_ENGINE); or if
    binlog_format=statement and a statement modifies a table restricted to
    row-logging (ER_BINLOG_STMT_MODE_AND_ROW_ENGINE).
                
    However, some DDL statements that lock tables (e.g. ALTER TABLE,
    CREATE INDEX and CREATE TRIGGER) were causing spurious errors,
    although no row might be inserted into the binary log.
                
    To fix the problem, we tagged statements that may generate
    rows into the binary log and thence the warning messages are
    only printed out when the appropriate conditions hold and rows
    might be changed.
    02fc237a
binlog_spurious_ddl_errors.test 4.01 KB