Bug #36984 INSERT DELAYED is converted to standard INSERT in Stored Procedure.
Submitted: 26 May 2008 16:31 Modified: 5 Jun 2008 14:33
Reporter: Matthew Montgomery Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0.56sp1 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[26 May 2008 16:31] Matthew Montgomery
http://dev.mysql.com/doc/refman/5.0/en/routine-restrictions.html does not mention that INSERT DELAYED is handled as INSERT in stored routines and triggers.

How to repeat:
In ./sql/sp_head.cc

  Upgrade the lock type because this table list will be used
  only in pre-locked mode, in which DELAYED inserts are always
  converted to normal inserts.
if (table->lock_type == TL_WRITE_DELAYED)
  table->lock_type= TL_WRITE;

However, not mentioned in docs.
[28 May 2008 16:52] Paul DuBois
Is this also true within events? (Is it a property of all stored programs?)
[4 Jun 2008 15:09] MySQL Verification Team
This behavior applies to EVENTS also.
[5 Jun 2008 14:33] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Added this note to the section:

Inserts cannot be delayed. INSERT DELAYED syntax is accepted but the
statement is handled as a normal INSERT.