Bug #78441 | Prefixed indexes not ignore by engine when unique or primary | ||
---|---|---|---|
Submitted: | 15 Sep 2015 8:59 | Modified: | 8 Feb 2016 13:17 |
Reporter: | Bruno ASTIER | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
Version: | 5.6.25-ndb-7.4.7-cluster-gpl | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[15 Sep 2015 8:59]
Bruno ASTIER
[15 Sep 2015 9:01]
Bruno ASTIER
Discussed in forum http://forums.mysql.com/read.php?25,634944,634944#msg-634944
[15 Sep 2015 9:41]
MySQL Verification Team
Hello Bruno ASTIER, Thank you for the report and test case. Thanks, Umesh
[8 Feb 2016 13:17]
Jon Stephens
Documented fix as follows in the NDB 7.4.11 changelog: NDB failed to ignore index prefixes on primary and unique keys, causing CREATE TABLE and ALTER TABLE statements using these to be rejected. Closed.