[MDEV-22269] Mariadb lacks GROUPING() function Created: 2020-04-17 Updated: 2023-11-13 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Subquery |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Philip orleans | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 6 |
| Labels: | compat80 | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
MySQL 8 already allows this: 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. |
| Comments |
| Comment by Yitzchak [ 2021-08-03 ] |
|
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. |
| Comment by Philip orleans [ 2021-08-03 ] |
|
I was referring to MySQL 8 and MSSQL, both offer his feature. |
| Comment by Mark [ 2023-05-14 ] |
|
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. |
| Comment by Philip orleans [ 2023-05-15 ] |
|
I hope so too. |