SQLite Forum

bug report : adding constant to GROUP BY leads to different output
Login
Chronological Hierarchical 
> But when we add a constant to the GROUP BY clause, just like:
> 
> SELECT * FROM t0 GROUP BY c0, NULL;

NULL is not a constant, because this does not return TRUE (or 1):

```
SELECT null=null
```
But this (adding a constant):
```
SELECT * FROM t0 GROUP BY c0, '42';
```

gives the correct output.