Adding sorting to DQL query reduces the number of results

There is a known bug/feature (depends on who you ask) that if you order by a field that is not available it doesn’t do logical NULLS first nor NULLS last, but rather NO NULLS.

Let me go find a linked article about this if I remember.

Here it is: Expected behaviour for sort queries

So it was agreed upon to “fix” this, but I still don’t think it was fixed yet. :frowning:

@Naman @mrjn @aman-bansal