Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
Description
The current way of handling uuid's in MariaDB is not very user friendly. If you want to do it right you have to replace all 4 "-" chars with "" and store it in a binary(16) type and so on. That is a lot of work and sadly people start to use just varchar() for it because it's easier. But that is a huge performence problem.
To fix that i would propose to add a "uuid" datatype to MariaDB the same way PostgreSQL did it. http://www.postgresql.org/docs/9.2/static/datatype-uuid.html
That would make working with uuid's a lot easier and faster.
Thanks and greetings
Leo
Attachments
Issue Links
- blocks
-
CONJ-899 Support UUID Object
- Closed
-
MDEV-15854 Implement uuid_to_bin, bin_to_uuid and is_uuid functions
- Open
- causes
-
MDEV-26615 uuid() function on default column value can violate PK/Unique constrants
- Closed
-
MDEV-26616 uuid data type - convert from text with binary data based on length
- Closed
-
MDEV-26664 Store UUIDs in a more efficient manner
- Closed
-
MDEV-26732 Assertion `0' failed in Item::val_native
- Closed
-
MDEV-26742 Assertion `field->type_handler() == this' failed in FixedBinTypeBundle<NATIVE_LEN, MAX_CHAR_LEN>::Type_handler_fbt::stored_field_cmp_to_item
- Closed
-
MDEV-26785 Hyphens inside the value of uuid datatype
- Closed
-
MDEV-34981 Functions missing from INFORMATION_SCHEMA.FUNCTIONS
- Open
- duplicates
-
MDEV-5593 Feature request native support for UUID's as a column type
- Closed
- is blocked by
-
MDEV-4912 Data type plugin API version 1
- Closed
-
MDEV-20890 Illegal mix of collations with UUID()
- Closed
- relates to
-
MDEV-27207 Assertion `!m_null_value' failed in int FixedBinTypeBundle<FbtImpl>::cmp_item_fbt::compare or in cmp_item_inet6::compare
- Closed
-
MDEV-31926 UUID v7 are compared incorrectly
- Closed
-
MDEV-33442 REPAIR TABLE corrupts UUIDs
- Closed
-
MDEV-8605 MariaDB not use DEFAULT value even when inserted NULL for NOT NULLABLE column.
- Closed
-
MDEV-11339 Support UUID v4 generation
- In Testing
-
MDEV-23748 support not-MAC-address based UUID versions
- Open
-
MDEV-27015 Assertion `!is_null()' failed in FixedBinTypeBundle<FbtImpl>::Fbt FixedBinTypeBundle<FbtImpl>::Field_fbt::to_fbt()
- Closed
-
MDEV-28491 Uuid. "UPDATE/DELETE" not working "WHERE id IN (SELECT id FROM ..)"
- Closed
-
MDEV-31137 UUID type is never used for user variables
- Closed
-
MDEV-33827 UUID() returns a NULL-able result
- Closed
- links to