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
• Status: Duplicate
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 4.1.6
• OS: Linux (Linux / SuSE 9.1)
• 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