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 Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1.23-rc-debug OS:Any
Assigned to: CPU Architecture:Any

[28 Nov 2007 12:13] Philip Stoev
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.