Bug #20830 INSERT DELAYED does not honour SET INSERT_ID

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.

It is a similar problem reported in bug#20627.

The fix for this bug is contained in the fix for Bug#20627.

Patch approved as for Bug#20627.

Pushed to 5.1-engines and 5.0-engines.

Fixed in 5.0.26, 5.1.12.

Noted in 5.0.26, 5.1.12 changelogs.

INSERT DELAYED did not honor SET INSERT_ID or the auto_increment_*
system variables.

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.

Pushed into 6.0.4-alpha

Pushed into 5.1.23-rc

Pushed into 5.0.54