• svoj@mysql.com/june.mysql.com's avatar
    BUG#34768 - nondeterministic INSERT using LIMIT logged in stmt mode if · 6dfb184f
    svoj@mysql.com/june.mysql.com authored
                binlog_format=mixed
    
    Statement-based replication of DELETE ... LIMIT, UPDATE ... LIMIT,
    INSERT ... SELECT ... LIMIT is not safe as order of rows is not
    defined.
    
    With this fix, we issue a warning that this statement is not safe to
    replicate in statement mode, or go to row-based mode in mixed mode.
    
    Note that we may consider a statement as safe if ORDER BY primary_key
    is present. However it may confuse users to see very similiar statements
    replicated differently.
    
    Note 2: regular UPDATE statement (w/o LIMIT) is unsafe as well, but
    this patch doesn't address this issue. See comment from Kristian
    posted 18 Mar 10:55.
    6dfb184f
sql_update.cc 61.5 KB