1. 18 Mar, 2008 1 commit
    • 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
  2. 07 Mar, 2008 13 commits
  3. 06 Mar, 2008 2 commits
  4. 04 Mar, 2008 1 commit
  5. 03 Mar, 2008 3 commits
  6. 29 Feb, 2008 3 commits
  7. 28 Feb, 2008 6 commits
  8. 27 Feb, 2008 10 commits
  9. 26 Feb, 2008 1 commit