Bug #38160 UUID() generates incorrectly formatted UUIDs
Submitted: 16 Jul 2008 4:20 Modified: 4 Dec 2008 16:29
Reporter: Tatiana Azundris Nuernberg Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: Tatiana Azundris Nuernberg CPU Architecture:Any

[16 Jul 2008 4:20] Tatiana Azundris Nuernberg 
Description:
my_uuid2str() has an off-by-one that results in the hyphens ending up two nibbles to the right of where they should be in the UUID.

How to repeat:
select uuid();

compare uuid() to that generated by 5.0 or 5.1 mysqld, or in fact any UUID. try to decode with random uuid tool.

Suggested fix:
void my_uuid2str(const uchar *guid, char *s)
{
  ...
  if(i == 3 || i == 5 || i == 7 || i == 9)
[21 Jul 2008 4:28] Tatiana Azundris Nuernberg 
pushed to 6.0.7-bugteam as p/o multi-patchset
[4 Dec 2008 4:36] Tatiana Azundris Nuernberg 
status of ticket was not auto-updated correctly
due to multi-patch.  see Bug#35848 for ChangeSet IDs.
[4 Dec 2008 16:29] Paul DuBois 
Noted in 6.0.7 changelog.

UUID() values could have hyphens in the wrong place.