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

Functions missing from INFORMATION_SCHEMA.SQL_FUNCTIONS

Details

    Description

      Not all functions are listed in the INFORMATION_SCHEMA.FUNCTIONS table. In particular, noticed that UUID is listed in 10.6, but not 10.11. UUIDv4 and UUIDv7 are also not listed in 11.7.0.

      MariaDB 10.6.19:

      SELECT * FROM INFORMATION_SCHEMA.SQL_FUNCTIONS ORDER BY FUNCTION;
      		 
      +---------------------------+
      		 
      | FUNCTION                  |
      		 
      +---------------------------+
      		 
      ...
      		 
      | UPPER                     |
      		 
      | UUID                      |
      		 
      | UUID_SHORT                |
      		 
      | VARIANCE                  |
      		 
      ...
      		 
      +---------------------------+

      MariaDB 10.11.5:

      SELECT * FROM INFORMATION_SCHEMA.SQL_FUNCTIONS ORDER BY FUNCTION;
      		 
      +---------------------------+
      		 
      | FUNCTION                  |
      		 
      +---------------------------+
      		 
      ...
      		 
      | UPPER                     |
      		 
      | UUID_SHORT                |
      		 
      | VARIANCE                  |
      		 
      ...

      Attachments

        Issue Links

          is caused by

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

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

          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
            bar Alexander Barkov added a comment - - edited

            sanja, please review:

            https://github.com/MariaDB/server/commit/ffea2a7bc9a0f4ef41981cc555c832abcf28381b

            bar Alexander Barkov added a comment - - edited sanja , please review: https://github.com/MariaDB/server/commit/ffea2a7bc9a0f4ef41981cc555c832abcf28381b
            sanja Oleksandr Byelkin added a comment -

            OK to push

            sanja Oleksandr Byelkin added a comment - OK to push

            People

              bar Alexander Barkov
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.