Re: ERROR 1089 (HY000):
Hi,
As the error message indicates and as
http://dev.mysql.com/doc/mysql/en/mysql-cluster-limitations-in-4-1.html also mentions, Cluster does not support indexes on prefixes of columns. So you can not create a unique on the first 25 characters. As you indicated the 32 works because that is the entire column width (not a prefix).
The reason why this doesn't matter is because the UNIQUE is implemented as a hashed value. That means it will take up the same width in the index regardless of how many characters you use in it. Even non-unique indexes contain a direct pointer to the data rather than a copy since it is a t-tree.
Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
11671
February 15, 2005 06:27AM
Re: ERROR 1089 (HY000):
4908
February 15, 2005 08:10PM
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.