Bug #50393 insert DELAYED disabled for partitioned myisam

• Submitted: 17 Jan 2010 0:46
• Modified: 17 Jan 2010 9:01
• Reporter: Mattias Jonsson
• Status: Verified
• Category: MySQL Server: Partitions
• Severity: S3 (Non-critical)
• Version: 5.1+
• OS: Any
• CPU Architecture: Any

[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.