Changes between Version 4 and Version 5 of Ticket #35437, comment 2


Ignore:
Timestamp:
May 6, 2024, 6:57:04 PM (6 months ago)
Author:
Simon Charette

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #35437, comment 2

    v4 v5  
    2222}}}
    2323
    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
     24In 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
     26Try it out for yourself with the following patch that avoids eliding the ordering part
    2527
    2628{{{#!diff
Back to Top