An error occurred fetching the project authors.
  1. 05 Jul, 2006 1 commit
    • guilhem@mysql.com's avatar
      Fix for BUG#20188 "REPLACE or ON DUPLICATE KEY UPDATE in · a43c4b02
      guilhem@mysql.com authored
      auto_increment breaks binlog":
      if slave's table had a higher auto_increment counter than master's (even
      though all rows of the two tables were identical), then in some cases,
      REPLACE and INSERT ON DUPLICATE KEY UPDATE failed to replicate
      statement-based (it inserted different values on slave from on master).
      write_record() contained a "thd->next_insert_id=0" to force an adjustment
      of thd->next_insert_id after the update or replacement. But it is this
      assigment introduced indeterminism of the statement on the slave, thus
      the bug. For ON DUPLICATE, we replace that assignment by a call to
      handler::adjust_next_insert_id_after_explicit_value() which is deterministic
      (does not depend on slave table's autoinc counter). For REPLACE, this
      assignment can simply be removed (as REPLACE can't insert a number larger
      than thd->next_insert_id).
      We also move a too early restore_auto_increment() down to when we really know
      that we can restore the value.
      a43c4b02
  2. 21 Apr, 2006 1 commit
  3. 26 Jan, 2006 1 commit
  4. 24 Feb, 2005 2 commits
  5. 14 Feb, 2005 1 commit
  6. 01 Feb, 2004 1 commit
  7. 10 Dec, 2003 1 commit
  8. 26 Jul, 2003 1 commit
  9. 26 May, 2003 1 commit
  10. 24 May, 2003 1 commit
  11. 08 Feb, 2003 1 commit
  12. 07 Feb, 2003 1 commit
  13. 28 Jan, 2003 2 commits