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
            Ellerbrockr richardeaxon created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Issue Type Bug [ 1 ] Task [ 3 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 78431 ] MariaDB v4 [ 130550 ]
            tgross35 Trevor Gross made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Labels beginner-friendly
            bar Alexander Barkov made changes -
            Comment [ [~serg], what do you think about the returned data type? I guess it should be UUID, not just VARCHAR.
            ]
            danblack Daniel Black made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]
            bar Alexander Barkov made changes -
            Assignee Alexander Barkov [ bar ]
            bar Alexander Barkov made changes -
            Fix Version/s 11.5 [ 29506 ]
            bar Alexander Barkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            bar Alexander Barkov made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            bar Alexander Barkov made changes -
            Assignee Alexander Barkov [ bar ] Elena Stepanova [ elenst ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Alexander Barkov [ bar ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.6 [ 29515 ]
            Fix Version/s 11.5 [ 29506 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            bar Alexander Barkov made changes -
            Assignee Alexander Barkov [ bar ] Elena Stepanova [ elenst ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels beginner-friendly Preview_11.6 beginner-friendly
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Preview_11.6 beginner-friendly beginner-friendly
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.7 [ 29815 ]
            Fix Version/s 11.6 [ 29515 ]
            alice Alice Sherepa made changes -
            Assignee Elena Stepanova [ elenst ] Alice Sherepa [ alice ]
            serg Sergei Golubchik made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels beginner-friendly Preview_11.7 beginner-friendly
            alice Alice Sherepa made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            alice Alice Sherepa made changes -
            Assignee Alice Sherepa [ alice ] Alexander Barkov [ bar ]
            serg Sergei Golubchik made changes -
            Assignee Alexander Barkov [ bar ] Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Component/s Server [ 13907 ]
            Fix Version/s 11.7.1 [ 29913 ]
            Fix Version/s 11.7 [ 29815 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]

            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.