When using `WITH ROLLUP` I receive this error:

> 
> **#1305** - FUNCTION GROUPING does not exist
> 
> 
> 

My DB version:

```
innodb_version  5.7.28
version     10.2.30-MariaDB

```

Strange that `WITH ROLLUP` works, but not `GROUPING()`. I would like to replace the nulls

Any idea?

My SQL:

```
SELECT
IF(GROUPING(`Categorie`), 'All Categorie',`Categorie`) AS `Categorie`,
`Grootboek`,
SUM(`Bedrag2020`) AS `Bedrag2020` 
FROM `vw_resultaat_ytd` 
Group by
`Categorie`,
`Grootboek` WITH ROLLUP;

```

As described in:
<https://www.mysqltutorial.org/mysql-rollup/>