Changes between Version 4 and Version 5 of Ticket #35437, comment 2
- Timestamp:
- May 6, 2024, 6:57:04 PM (6 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #35437, comment 2
v4 v5 22 22 }}} 23 23 24 In other words, your distinct group is by `U0."id" = ("expressions_employee"."id")` so you'll always have matching rows even if the ordering is maintained. Try it out for yourself with the following patch 24 In other words, you only filter by `U0."id" = ("expressions_employee"."id")` so the current employee will always exists in the subquery and `DISTINCT` and `ORDER BY` have nothing to do with it. 25 26 Try it out for yourself with the following patch that avoids eliding the ordering part 25 27 26 28 {{{#!diff