FlexMeasures / flexmeasures / 29341985964

82%

main: 82%

push

github

Fix sorting when combined with the assets search filter

Two bugs surfaced when sort_by/sort_dir was combined with a search
filter (which routes through a UNION ALL of private/public asset
queries):

- ID and Name sorting silently had no effect, because ORDER BY was
  applied to the individual UNION ALL members instead of the combined
  outer query; per SQL, ordering a union member doesn't guarantee the
  combined result is ordered. Sorting is now applied to the outer
  query instead.
- Sorting by Account raised a 500 (auto-correlation error): the
  account-name scalar subquery auto-correlated away its own FROM
  clause when the outer (private-assets) query already joined
  Account. Fixed by explicitly correlating only GenericAsset.

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01C2JTqYVFPmJgX7kN2DSvbE

7 of 8 new or added lines in 1 file covered. (87.5%)

14557 of 17855 relevant lines covered (81.53%)

0.82 hits per line