Bug #24820 | CREATE INDEX ....USING HASH on NDB table creates ordered index, not HASH index | ||
---|---|---|---|
Submitted: | 5 Dec 2006 13:27 | Modified: | 25 Jan 2007 4:23 |
Reporter: | Roland Bouman | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S3 (Non-critical) |
Version: | 5.1.14, 5.0 | OS: | Linux (ubuntu edgy) |
Assigned to: | Martin Skold | CPU Architecture: | Any |
Tags: | hash, INDEX, ndb, ordered |
[5 Dec 2006 13:27]
Roland Bouman
[6 Dec 2006 14:01]
Hartmut Holzgraefe
USING HASH only works with UNIQUE indexes, you can't have a hash index on something that allows duplicates. It should generate a warning though.
[8 Jan 2007 9:39]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/17711 ChangeSet@1.2293, 2007-01-08 10:38:53+01:00, mskold@mysql.com +3 -0 bug#24820 CREATE INDEX ....USING HASH on NDB table creates ordered index, not HASH index: Added error checking
[8 Jan 2007 10:42]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/17717 ChangeSet@1.2382, 2007-01-08 11:42:32+01:00, mskold@mysql.com +3 -0 bug#24820 CREATE INDEX ....USING HASH on NDB table creates ordered index, not HASH index: Added error checking
[8 Jan 2007 12:53]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/17726 ChangeSet@1.2294, 2007-01-08 13:53:37+01:00, mskold@mysql.com +2 -0 bug#24820 CREATE INDEX ....USING HASH on NDB table creates ordered index, not HASH index: Changed test since error mesage wasn't predictable
[8 Jan 2007 13:20]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/17729 ChangeSet@1.2385, 2007-01-08 14:20:35+01:00, mskold@mysql.com +2 -0 bug#24820 CREATE INDEX ....USING HASH on NDB table creates ordered index, not HASH index: Merged up test 5.0 case
[24 Jan 2007 1:55]
Tomas Ulin
pushed to 5.1.15
[24 Jan 2007 7:52]
Tomas Ulin
pushed to 5.0.36
[25 Jan 2007 4:23]
Jon Stephens
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 bug fix. More information about accessing the source trees is available at http://dev.mysql.com/doc/en/installing-source.html Documented bugfix in 5.0.36 and 5.1.15 changelogs.