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

Functions missing from INFORMATION_SCHEMA.SQL_FUNCTIONS

    XMLWordPrintable

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

          Activity

            People

              bar Alexander Barkov
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 4h 40m
                  4h 40m

                  Git Integration

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