Bug #6253 InnoDB: "index file is crashed" / same column named twice in index
Submitted: 25 Oct 2004 19:48 Modified: 27 Oct 2004 13:33
Reporter: Carsten Pedersen Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:4.1.6 OS:Linux (Linux / SuSE 9.1)
Assigned to: CPU Architecture:Any

[25 Oct 2004 19:48] Carsten Pedersen
Description:
When attempting to define the same column more than once in an index, InnoDB reports errno 126 - Index file is crashed.

The behaviour is as it should be (don't allow the creation of the index), but the error message does not convey the needed information.

How to repeat:
mysql> create table t (i1 int not null, primary key (i1, i1, i1)) engine=InnoDB;
ERROR 1005 (HY000): Can't create table './test/t.frm' (errno: 126)

$ perror 126
MySQL error:  126 = Index file is crashed

Suggested fix:
Generate a new error with text a la "Cannot specify column X more than once in index Y"
[25 Oct 2004 20:04] MySQL Verification Team
Verified also on windows.
[27 Oct 2004 13:33] Heikki Tuuri
This is a duplicate of #6126.
--Heikki