Bug #41568 | Create index HASH | ||
---|---|---|---|
Submitted: | 17 Dec 2008 22:45 | Modified: | 18 Dec 2008 5:06 |
Reporter: | Francesco Maisano | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S5 (Performance) |
Version: | 5.1.24 | OS: | Linux (RedHat 5.2-64 bit) |
Assigned to: | CPU Architecture: | Any |
[17 Dec 2008 22:45]
Francesco Maisano
[18 Dec 2008 5:06]
Valeriy Kravchuk
This is a documented limitation. Please, read the manual, http://dev.mysql.com/doc/refman/5.1/en/create-index.html: "For indexes on NDBCLUSTER table columns, the USING clause can be specified only for a unique index or primary key. In such cases, the USING HASH clause prevents the creation of an implicit ordered index. Without USING HASH, a statement defining a unique index or primary key automatically results in the creation of a HASH index in addition to the ordered index, both of which index the same set of columns."