[MDEV-32789] Add GROUPING function Created: 2023-11-13 Updated: 2023-11-13 Resolved: 2023-11-13 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | compat80 |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Ian Gilfillan | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| 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 |