MySQL Bugs: #19622: DOC BUG: DELAYED not supported by INNODB in mysql 5.0

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

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?

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

It wasnt listed in the migration docs then and probably should have been?

Thank you for the bug report. I think Paul already commented the reason
for it isn't a bug.