Bug #38160 UUID() generates incorrectly formatted UUIDs
Submitted: 16 Jul 2008 6:20 Modified: 4 Dec 2008 17:29
Reporter: Tatjana A. Nuernberg
Status: Closed
Category:Server: General Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: Tatjana A. Nuernberg Target Version:6.0-beta
Triage: Triaged: D2 (Serious)

[16 Jul 2008 6:20] Tatjana A. 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 6:28] Tatjana A. Nuernberg
pushed to 6.0.7-bugteam as p/o multi-patchset
[4 Dec 2008 5:36] Tatjana A. Nuernberg
status of ticket was not auto-updated correctly
due to multi-patch.  see Bug#35848 for ChangeSet IDs.
[4 Dec 2008 17:29] Paul DuBois
Noted in 6.0.7 changelog.

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