News for hackers. Stuff that matters.

A comment on UUIDs in MySQL are really not random.

Re:UUIDs in MySQL are really not random by ciupicri on Tuesday February 05, 2019 @12:23PM (#19087354)
They don't seem to have the same type (according to uuidparse from util-linux):

  UUID                                  VARIANT TYPE       TIME
  4f95de28-0fd1-48db-ad2e-34ecd169c483  DCE     random     
  4331cb9e-1d91-11e9-be2c-45923c63e8a2  DCE     time-based 2019-01-21 17:28:54,631107+02:00
  4331cc4c-1d91-11e9-be2c-45923c63e8a2  DCE     time-based 2019-01-21 17:28:54,631124+02:00
  c7e2f124-f6ba-4434-843f-89958a7436ec  DCE     random     
  3e18f8dd-b1d3-4e16-8a81-4bdceac91772  DCE     random
Explanation of the output:

  Variants
   DCE   The Open Software Foundation's (OSF) Distributed Computing Environment UUIDs.

  Types
   time-based   The DCE time based.
   random       RFC 4122 random.
[ Parent | on HN ]

There are no comments on this comment yet.