Open skarum opened 4 years ago
I did a bit more digging and it looks like only the records that are transformed are returned. In the example above it's only the values that were uppercase before that are returned. When doing an ´upper´ instead I get all the results - except the one that was already uppercased.
This should be closed by bugfix: upper and lower setting null values in some instances #3947
When using lowercase on a field the group by results seems very reduced - also beyond the casing.
Group by on a field![image](https://user-images.githubusercontent.com/4727516/64957958-597f9580-d88e-11e9-855d-abed5f787e38.png)
Lowercase the field and group by:![image](https://user-images.githubusercontent.com/4727516/64958010-75833700-d88e-11e9-8c5c-a2a231bba721.png)
I would expect the results would be almost the same (only putting upper cased values together with lowercase).
Seems to be the same issue with
top()