[MDEV-5593] Feature request native support for UUID's as a column type Created: 2014-01-30  Updated: 2015-11-17  Resolved: 2014-07-21

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Mikhail Gavrilov Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-4958 Adding datatype UUID Closed
Relates
relates to MDEV-4912 Data type plugin API version 1 Closed

 Description   

Feature request native support for UUID's as a column type instead of having to resort to a binary(16)

  • more comfortable because they do not have to do hex / unhex and remove dash
  • faster index than varchar variant
  • automatic generation of UUID if inserted record with NULL PK

 Comments   
Comment by Daniël van Eeden [ 2014-07-21 ]

This looks like a duplicate of MDEV-4958?

Comment by Mikhail Gavrilov [ 2014-07-21 ]

I don't see recommendation do it as separate type and also I don't see recommendation to validate UUID value and automatic generate if inserted record with NULL PK
My description of this feature is more accurately

Comment by Sergei Golubchik [ 2014-07-21 ]

Still, MDEV-4958 was created first. Instead of creating a duplicate you could've added your clarifications as a comment to that, already existing, task. I've now done that, so your input won't be lost.

Generated at Thu Feb 08 07:05:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.