[rql2sql] fix handling of the ORDERBY clause when the aggregation function is "embedded"
ie. a situation like:
Any X GROUPBY X ORDERBY COUNT(Y) WHERE ...
works fine since the aggregation function (COUNT) if the first one, whereas a situation like the proposed test:
Any X GROUPBY X ORDERBY ABS(COUNT(Y)) WHERE ...
failed due to the fact we only checked the top aggratation function (ABS).
Closes #17108671
[MASTER]
load-plugins=cubicweb.pylintext
ignore=__pkginfo__
[MESSAGES CONTROL]
disable = too-many-ancestors,too-many-instance-attributes,too-many-public-methods,
too-few-public-methods,too-many-arguments,import-error
[BASIC]
function-rgx = [a-z_][a-z0-9_]{2,35}$
good-names=w,_
[TYPECHECK]
generated-members=debug,info,notice,warning,error,critical,exception
[CLASSES]
exclude-protected=_cw,_cnx,
# namedtuple public API.
_asdict,_fields,_replace,_source,_make
[FORMAT]
max-line-length=100
max-module-lines=2000