MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes
Posted by: Michele Martiello
Date: June 06, 2018 03:33AM

According with Known Limitations of NDB Cluster
**
Column width. Attempting to create an index on an NDB table column whose width is greater than 3072 bytes succeeds, but only the first 3072 bytes are actually used for the index. In such cases, a warning Specified key was too long; max key length is 3072 bytes is issued, and a SHOW CREATE TABLE statement shows the length of the index as 3072.
**
So I'm expecting a warning when I try to create a table with a key on a varchar(2000) column,
but I get an error

ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes

and table is not definetively created

Is there any workaround for that ?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes
38186
Michele Martiello
June 06, 2018 03:33AM
Re: ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes
14029
Mikael Ronström
June 08, 2018 05:54AM


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.