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

Add GROUPING function

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • N/A
    • compat80
    • None

    Description

      MySQL 8.0 added the GROUPING function, which is useful with SELECT WITH ROLLUP, as it distinguishes between between nulls in the data, and nulls generated by the rollup.

      This has been requested a number of times in the discussions at https://mariadb.com/kb/en/select-with-rollup/

      See https://dev.mysql.com/blog-archive/mysql-8-0-grouping-function/ and https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html#function_grouping

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-22269 Mariadb lacks GROUPING() function

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

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

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.