exemple de rql moche avec having
dans activités, Any W,WO,T,B ORDERBY B DESC WHERE W split_into WO, WO eid E HAVING T != B WITH WO,B,T BEING (Any WO,B,SUM(D) GROUPBY WO,B WHERE X is Commitment, X commit_for WO, WO budget B, X duration D)
fonctionne, mais on aurait préféré pouvoir écrire plus simplement Any WO,B,SUM(D) GROUPBY WO,B WHERE X is Commitment, X commit_for WO, WO budget B, X duration D HAVING B != SUM(D)
Erreur avec RQL 0.41.0:
GroupingError: when doing the query 'SELECT DISTINCT _X.cw_eid
FROM commit_for_relation AS rel_commit_for0, cw_Commitment AS _X, cw_WorkOrder AS _WO
WHERE rel_commit_for0.eid_from=_X.cw_eid AND rel_commit_for0.eid_to=_WO.cw_eid
HAVING _WO.cw_budget!=SUM(_X.cw_duration)' with the args '{}' got the error 'column "_x.cw_eid" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT DISTINCT _X.cw_eid