Bug #20830 INSERT DELAYED does not honour SET INSERT_ID
Submitted: 3 Jul 2006 19:25 Modified: 5 Oct 2006 17:14
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.1-bk OS:Linux (Linux)
Assigned to: Ingo Strüwing CPU Architecture:Any

[3 Jul 2006 19:25] Guilhem Bichot
Description:
didn't test with 5.0.

How to repeat:
CREATE TABLE `auto` (
  `a` int(11) NOT NULL AUTO_INCREMENT,
  `b` int(11) DEFAULT NULL,
  PRIMARY KEY (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

set insert_id=50;
insert delayed into auto values(null,3);
select * from auto;
+---+------+
| a | b    |
+---+------+
| 1 |    3 |
+---+------+

If the DELAYED word is omitted (normal INSERT), (50,3) is inserted, as expected

Suggested fix:
fix it (by having a "next_insert_id" member in the delayed_row class) or document it.
[7 Jul 2006 15:52] Calvin Sun
It is a similar problem reported in bug#20627.
[15 Sep 2006 17:50] Ingo Strüwing
The fix for this bug is contained in the fix for Bug#20627.
[18 Sep 2006 17:02] Ingo Strüwing
Patch approved as for Bug#20627.
[29 Sep 2006 17:24] Ingo Strüwing
Pushed to 5.1-engines and 5.0-engines.
[3 Oct 2006 8:49] Sergey Vojtovich
Fixed in 5.0.26, 5.1.12.
[5 Oct 2006 17:14] Paul DuBois
Noted in 5.0.26, 5.1.12 changelogs.

INSERT DELAYED did not honor SET INSERT_ID or the auto_increment_*
system variables.
[26 Nov 2007 18:18] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/38549

ChangeSet@1.2593, 2007-11-26 19:16:23+01:00, istruewing@stella.local +2 -0
  Bug#20830 - INSERT DELAYED does not honour SET INSERT_ID
  Bug#20627 - INSERT DELAYED does not honour auto_increment_* variables
  Fixed wrong variable assignment.
[28 Nov 2007 10:23] Bugs System
Pushed into 6.0.4-alpha
[28 Nov 2007 10:25] Bugs System
Pushed into 5.1.23-rc
[28 Nov 2007 10:27] Bugs System
Pushed into 5.0.54