Bug #7884 Able to add invalid unique index on TIMESTAMP prefix

• Submitted: 13 Jan 2005 20:40
• Modified: 31 Jan 2005 20:24
• Reporter: Dean Ellis
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 4.1.10
• Assigned to: Dmitri Lenev

[13 Jan 2005 20:40] Dean Ellis

Description:
You can add an invalid index on a TIMESTAMP column prefix via ALTER TABLE.  (It is
rejected by CREATE TABLE).  Subsequent inserts can fail for some table definitions (in
MyISAM you receive "Invalid Keyfile" errors).

This was seen in 4.1.7 and verified in 4.1.10; does not occur in 4.0.24.

How to repeat:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 ( a TIMESTAMP, UNIQUE ( a(1) ) );
CREATE TABLE t1 ( a TIMESTAMP );
ALTER TABLE t1 ADD UNIQUE ( a(1) );

Suggested fix:
n/a

[26 Jan 2005 12:48] Dmitri Lenev

Fixed in 4.1.10 and 5.0.3

[31 Jan 2005 20:24] Paul DuBois

Mentioned in 4.1.10 and 5.0.3 change notes.