Bug #36065 MyISAM: duplicate key error on unique values
Submitted: 14 Apr 2008 17:08 Modified: 1 May 2008 14:00
Reporter: Philip Stoev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:6.0-falcon-team OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[14 Apr 2008 17:08] Philip Stoev
Description:
When executing a query workload with concurrent ALTER TABLE, a completely valid insert of the form:

INSERT INTO view1 (t1_uuid) VALUES (UUID())

will fail with

1022: Can't write; duplicate key in table

How to repeat:
A test case will hopefully follow shortly.
[1 May 2008 14:00] Philip Stoev
This was caused by a non-uniqueness in the UUID function, see bug #35514.