SQL: GROUPing BY YEAR function applied on a CASTed AS DATE field results in NULL values

`SELECT YEAR(CAST(birth_date AS DATE)) FROM test_emp GROUP BY 1` results in 

```
YEAR(CAST(birth_date AS DATE))
------------------------------------
null
```