Bug #19622 DOC BUG: DELAYED not supported by INNODB in mysql 5.0
Submitted: 8 May 2006 18:09 Modified: 8 May 2006 22:44
Reporter: Rolf Martin-Hoster Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:
Assigned to: CPU Architecture:Any

[8 May 2006 18:09] Rolf Martin-Hoster
Description:
The documentation doesn't mention this.

mysql> REPLACE DELAYED INTO `online_users` SET `session_id`='3580cc4e61117c0785372c426eddd11c', `user_id` = '233', `page` = '/', `lastview` = NOW();
ERROR 1031 (HY000): Table storage engine for 'online_users' doesn't have this option

How to repeat:
mysql> REPLACE DELAYED INTO `online_users` SET `session_id`='3580cc4e61117c0785372c426eddd11c', `user_id` = '233', `page` = '/', `lastview` = NOW();
ERROR 1031 (HY000): Table storage engine for 'online_users' doesn't have this option

Suggested fix:
Mention this in the docs?
[8 May 2006 19:02] Paul DuBois
As the manual says, REPLACE is very similar to INSERT.
The section on INSERT DELAYED mentions that DELAYED
is supported only for certain storage engines.  InnoDB is
not one of them.

http://dev.mysql.com/doc/refman/5.0/en/insert-delayed.html
[8 May 2006 21:34] Rolf Martin-Hoster
It wasnt listed in the migration docs then and probably should have been?
[8 May 2006 22:44] MySQL Verification Team
Thank you for the bug report. I think Paul already commented the reason
for it isn't a bug.