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

Support UUID v4 generation

Details

    Description

      I need to use an external routine to generate RFC 4122 UUID's (https://tools.ietf.org/html/rfc4122) as MariaDB generates v1 UUID's. v1 UUID's are not opaque enough for our needs. I suggest that the uuid() function call accepts an optional parameter - uuid(4) to generate a v4 uuid, or create a new function call uuid4().

      The RFC document above includes C source code for UUID types 1 to 5.

      Attachments

        Issue Links

          is blocked by

          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
          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-10137 Providing compatibility to other databases

          • Major - Major loss of function.
          • Open

          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
          relates to

          Task - A task that needs to be done. MDEV-4958 Adding datatype UUID

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32637 Implement native UUID7 function

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

          Activity

            Ascending order - Click to sort in descending order
            View 12 older comments
            bar Alexander Barkov added a comment -

            Hi elenst,

            please find the stage branch with UUIDv4 here:

            https://github.com/MariaDB/server/tree/bb-11.5-bar-MDEV-11339

            Buildbots
            Thanks.

            bar Alexander Barkov added a comment - Hi elenst , please find the stage branch with UUIDv4 here: https://github.com/MariaDB/server/tree/bb-11.5-bar-MDEV-11339 Buildbots Thanks.
            danblack Daniel Black added a comment -

            Note - will need MDEV-32583 like fix.

            danblack Daniel Black added a comment - Note - will need MDEV-32583 like fix.
            danblack Daniel Black added a comment -

            Applied MDEV-32583 fix to bb-11.5-bar-MDEV-11339

            danblack Daniel Black added a comment - Applied MDEV-32583 fix to bb-11.5-bar- MDEV-11339
            serg Sergei Golubchik added a comment -

            bb-11.7-MDEV-33710-uuid is ready for testing. It has both UUIDv4 and UUIDv7

            serg Sergei Golubchik added a comment - bb-11.7- MDEV-33710 -uuid is ready for testing. It has both UUIDv4 and UUIDv7
            alice Alice Sherepa added a comment -

            Testing is done (bb-11.7-MDEV-33710-uuid e3dcdddea5fda111a3929de5e752f4944a1e6a9e), ok to push

            alice Alice Sherepa added a comment - Testing is done (bb-11.7- MDEV-33710 -uuid e3dcdddea5fda111a3929de5e752f4944a1e6a9e), ok to push

            People

              serg Sergei Golubchik
              Ellerbrockr richardeaxon
              Votes:
              12 Vote for this issue
              Watchers:
              17 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.