MySQL Forums
Forum List  »  NDB clusters

Prefixed indexes
Posted by: Bruno ASTIER
Date: September 11, 2015 04:21AM

Hi all,


In documentation, prefix index are supposed to be ignored as not compatible with ndb engine
http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-limitations-unsupported.html

In fact, prefix are not ignored and error is raised by the server
ERROR 1089 (HY000): Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys


Is there an option that I missed somewhere to force ignoring prefix on indexes ?


Regards, Bruno.

Server version: 5.6.25-ndb-7.4.7-cluster-gpl MySQL Cluster Community Server (GPL)

Options: ReplyQuote


Subject
Views
Written By
Posted
Prefixed indexes
1987
September 11, 2015 04:21AM
886
September 14, 2015 05:38AM
817
September 14, 2015 06:18AM
561
September 14, 2015 11:28AM
502
September 15, 2015 02:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.