Bug #32812 ALTER TABLE ANALYZE PARTITION fails on Memory tables

• Submitted: 28 Nov 2007 12:13
• Modified: 6 Dec 2007 10:11
• Reporter: Philip Stoev
• Status: Duplicate
• Category: MySQL Server: Partitions
• Severity: S3 (Non-critical)
• Version: 5.1.23-rc-debug
• OS: Any
• CPU Architecture: Any

[28 Nov 2007 12:13] Philip Stoev

Description:
ALTER TABLE ANALYSE PARTITION fails on Memory tables with a non-descriptive error message.

How to repeat:
mysql> CREATE TABLE t1 (f1 integer) Type=Memory PARTITION BY KEY (f1);
Query OK, 0 rows affected, 1 warning (0.02 sec)

mysql> alter table t1 analyze partition p0;
ERROR 1030 (HY000): Got error -1 from storage engine

Suggested fix:
If partitioning is not supported on memory tables, then the manual and the error messages should reflect this.

[6 Dec 2007 10:11] Mattias Jonsson

Duplicate of Bug#27429.