Bug #50393 insert DELAYED disabled for partitioned myisam
Submitted: 17 Jan 2010 0:46 Modified: 17 Jan 2010 9:01
Reporter: Mattias Jonsson Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1+ OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D5 (Feature request)

[17 Jan 2010 0:46] Mattias Jonsson
Description:
As seen in the forum post:
http://forums.mysql.com/read.php?106,299477,299477#msg-299477

INSERT DELAYED is disabled for partitioned tables. But just removing HA_CAN_INSERT_DELAYED from PARTITION_DISABLED_TABLE_FLAGS and running delayed.test (after changing all tables to be partitioned) shows that it seems to work

How to repeat:
Apply the suggested fix, and run INSERT DELAYED on partitioned tables (with engines that supports DELAYED).

Suggested fix:
=== modified file 'sql/ha_partition.h'
--- sql/ha_partition.h	2009-11-17 19:02:16 +0000
+++ sql/ha_partition.h	2010-01-17 00:06:41 +0000
@@ -53,7 +53,6 @@
                                         HA_CAN_FULLTEXT | \
                                         HA_DUPLICATE_POS | \
                                         HA_CAN_SQL_HANDLER | \
-                                        HA_CAN_INSERT_DELAYED | \
                                         HA_PRIMARY_KEY_REQUIRED_FOR_POSITION)
 class ha_partition :public handler
 {
[17 Jan 2010 9:01] Valeriy Kravchuk
As our manual (http://dev.mysql.com/doc/refman/5.1/en/insert-delayed.html) clearly says:

"INSERT DELAYED is not supported for partitioned tables."

formally this is still a feature request.