MySQL Bugs: #17888: DD: ADD INDEX causes error 756 'Index on disk column is not supported

Bug #17888	DD: ADD INDEX causes error 756 'Index on disk column is not supported
Submitted:	3 Mar 2006 6:38	Modified:	8 Mar 2006 14:17
Reporter:	Nikolay Grishakin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	5.1	OS:	Linux (Linux)
Assigned to:	Martin Skold	CPU Architecture:	Any

Description:
ADD INDEX causes error error 756 'Index on disk column is not supported'
from NDBCLUSTER. If I don't create PRIMARY KEY on col1 it works fine.

 CREATE LOGFILE GROUP lg1
 ADD UNDOFILE 'undofile.dat'
 INITIAL_SIZE 16M 
 UNDO_BUFFER_SIZE = 1M
 ENGINE=NDB;

 CREATE TABLESPACE ts1
 ADD DATAFILE 'datafile.dat' 
 USE LOGFILE GROUP lg1
 INITIAL_SIZE 12M
 ENGINE NDB;

 CREATE TABLE table1 (col1 int, col2 int, col3 int, col4 int, PRIMARY 
 KEY(col1)) TABLESPACE ts1 STORAGE DISK ENGINE ndb;
 
 ALTER TABLE table1
 ADD INDEX col1and2_index (col1, col2);

 ERROR 1296 (HY000): Got error 756 'Index on disk column is not supported'
 from NDBCLUSTER

How to repeat:
see above

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix in 5.1.8 changelog. Closed.