[CAY-2673] Support ordering by aggregate functions

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.2.M2
• Component/s: Core Library
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 15/Sep/20 10:35
• Updated: 16/Sep/20 11:28
• Resolved: 16/Sep/20 11:28

Description

Ordering generated by expression like Parent.CHILD.count().asc() is formally valid and accepted by the Cayenne stack, but it generates invalid SQL. To be specific, Group By clause is missing in that case.
It doesn't seem important feature but we still should support this ordering, especially this doesn't require much effort in the current translator.