Details

    Description

      MySQL 8 already allows this:
      Using GROUPING() to substitute labels for the super-aggregate NULL values makes the result easier to interpret:
      SELECT
      IF(GROUPING(name) = 1, 'All items', name) AS name,
      IF(GROUPING(size) = 1, 'All sizes', size) AS size,
      SUM(quantity) AS quantity
      FROM t1
      GROUP BY name, size WITH ROLLUP;

      This is an old feature of MsSQL. Over the years I have filed a few times a request so MariaDB fixes this problem because we cannot return nulls in the grouping cells, we need to add a meaningful label. Please stop procrastinating and listen to the business people. We cannot work efficiently as it is.
      https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html

      Attachments

        Issue Links

          Activity

            ysth Yitzchak added a comment -

            Is there a label for things mysql 8 has that mariadb does not? I see Compatibility, but that seems to have a lot of other stuff in it.

            ysth Yitzchak added a comment - Is there a label for things mysql 8 has that mariadb does not? I see Compatibility, but that seems to have a lot of other stuff in it.
            philip_38 Philip orleans added a comment - - edited

            I was referring to MySQL 8 and MSSQL, both offer his feature.

            philip_38 Philip orleans added a comment - - edited I was referring to MySQL 8 and MSSQL, both offer his feature.
            mark.jira@manngo.net Mark added a comment - - edited

            PostgreSQL and Oracle also include this.

            I presume this is an oversight and that MariaDB is just waiting for the right moment to announce that it’s ready to go.

            I’ve noticed a few things now where MariaDB has slipped behind MySQL.

            mark.jira@manngo.net Mark added a comment - - edited PostgreSQL and Oracle also include this. I presume this is an oversight and that MariaDB is just waiting for the right moment to announce that it’s ready to go. I’ve noticed a few things now where MariaDB has slipped behind MySQL.

            I hope so too.

            philip_38 Philip orleans added a comment - I hope so too.

            People

              Unassigned Unassigned
              philip_38 Philip orleans
              Votes:
              6 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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