Bug #28781 InnoDB increments auto-increment value incorrectly with ON DUPLICATE KEY UPDATE
Submitted: 30 May 2007 19:24 Modified: 27 Feb 2008 14:42
Reporter: Todd Farmer
Status: Closed
Category:Server: Docs Severity:S2 (Serious)
Version:5.0.42 OS:Any
Assigned to: Paul DuBois Target Version:5.0+
Tags: bfsm_2007_06_21
Triage: D2 (Serious)

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-28781.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[8 Aug 2007 7:26] Inaam Rana
patch for 5.0

Attachment: 28781.patch (text/x-diff), 1.56 KiB.

[10 Jan 2008 19:32] Inaam Rana
autoinc behaviour with different values of innodb_autoinc_lock_mode

Attachment: autoinc.out (application/octet-stream, text), 4.42 KiB.