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

ANY_VALUE function

    XMLWordPrintable

Details

    Description

      Since version 5.7.5 Mysql has the "ONLY_FULL_GROUP_BY" flag by default enabled and I am trying to make some software that I maintain to be compatible with that.

      The most clean way to achieve that is with the ANY_VALUE() function. If you give a query like

      SELECT ANY_VALUE(var1), ANY_VALUE(var2), color FROM mybase GROUP BY color

      Mysql will not complain that var1 and var2 are not determined.

      Unfortunately when I use this under MariaDb I get the following error:

      MySQL error 1728: Cannot load from mysql.proc. The table is probably corrupted

      As soon as you remove the ANY_VALUE the error disappears - so it must be related to this function.

      See also MDEV-30766 where this function is needed for the query to return correct results

      It's also SQL-2023 standard feature T626

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40375 Error is expected after ANY_VALUE(DISTINCT ..)

          • Major - Major loss of function.
          • Needs Feedback
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12481 The ANY_VALUE() function is not yet included in MariaDB 10.2.5 (RC)

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30766 Issue with NOT IN (subquery that violates "FULL GROUP BY")

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

          DOCS-6309 Loading...

          links to

          Web Link SQL-2023 - ANY_VALUE (T626)

          Activity

            People

              alice Alice Sherepa
              musicpanda Wim Roffel
              Votes:
              15 Vote for this issue
              Watchers:
              18 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 3h 50m
                  3h 50m

                  Git Integration

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