Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4958

Adding datatype UUID

Details

    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

          Task - A task that needs to be done. CONJ-899 Support UUID Object

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-15854 Implement uuid_to_bin, bin_to_uuid and is_uuid functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26615 uuid() function on default column value can violate PK/Unique constrants

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-26616 uuid data type - convert from text with binary data based on length

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26664 Store UUIDs in a more efficient manner

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26732 Assertion `0' failed in Item::val_native

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26742 Assertion `field->type_handler() == this' failed in FixedBinTypeBundle<NATIVE_LEN, MAX_CHAR_LEN>::Type_handler_fbt::stored_field_cmp_to_item

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26785 Hyphens inside the value of uuid datatype

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34981 Functions missing from INFORMATION_SCHEMA.SQL_FUNCTIONS

          • Major - Major loss of function.
          • Closed
          duplicates

          Task - A task that needs to be done. MDEV-5593 Feature request native support for UUID's as a column type

          • Major - Major loss of function.
          • Closed
          is blocked by

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-4912 Data type plugin API version 1

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20890 Illegal mix of collations with UUID()

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27207 Assertion `!m_null_value' failed in int FixedBinTypeBundle<FbtImpl>::cmp_item_fbt::compare or in cmp_item_inet6::compare

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31926 UUID v7 are compared incorrectly

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33442 REPAIR TABLE corrupts UUIDs

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8605 MariaDB not use DEFAULT value even when inserted NULL for NOT NULLABLE column.

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-11339 Support UUID v4 generation

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. MDEV-23748 support not-MAC-address based UUID versions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27015 Assertion `!is_null()' failed in FixedBinTypeBundle<FbtImpl>::Fbt FixedBinTypeBundle<FbtImpl>::Field_fbt::to_fbt()

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28491 Uuid. "UPDATE/DELETE" not working "WHERE id IN (SELECT id FROM ..)"

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31137 UUID type is never used for user variables

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33827 UUID() returns a NULL-able result

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35427 Assertion `is_null() >= item->null_value' failed in Timestamp_or_zero_datetime_native_null::Timestamp_or_zero_datetime_native_null on EXECUTE

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link NEWSEQUENTIALID (SQL Server)

          Activity

            Ascending order - Click to sort in descending order
            View 17 older comments
            danblack Daniel Black added a comment -

            To all those that are watching, a preview release is available for testing and feedback:

            https://mariadb.org/10-7-preview-feature-uuid-data-type/

            danblack Daniel Black added a comment - To all those that are watching, a preview release is available for testing and feedback: https://mariadb.org/10-7-preview-feature-uuid-data-type/
            alice Alice Sherepa added a comment -

            I think it could be merged into 10.7

            alice Alice Sherepa added a comment - I think it could be merged into 10.7
            eXsio Slawomir Dymitrow added a comment -

            Hi guys, so excited to see the UUID data type as a feature! One question - does the actually implemented feature use the bits-shuffle solution to optimize performance? Or was this only an idea that didn't get implemented?

            eXsio Slawomir Dymitrow added a comment - Hi guys, so excited to see the UUID data type as a feature! One question - does the actually implemented feature use the bits-shuffle solution to optimize performance? Or was this only an idea that didn't get implemented?
            greenman Ian Gilfillan added a comment -

            eXsio see MDEV-26664

            greenman Ian Gilfillan added a comment - eXsio see MDEV-26664
            bar Alexander Barkov added a comment -

            eXsio,

            Also please see these comments:
            https://github.com/MariaDB/server/blob/10.7/plugin/type_uuid/sql_type_uuid.h#L29

            bar Alexander Barkov added a comment - eXsio , Also please see these comments: https://github.com/MariaDB/server/blob/10.7/plugin/type_uuid/sql_type_uuid.h#L29

            People

              alice Alice Sherepa
              leo.unglaub Leo Unglaub
              Votes:
              36 Vote for this issue
              Watchers:
              37 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.