RootCauseunvalidated
In JPQL/HQL, Hibernate requires ordering for array_agg used as an ordered-set aggregate, and the JPQL version of ARRAY_AGG needs either a WITHIN GROUP or an OVER clause to satisfy Hibernate's parser/semantics. The attempt without the required ordering clause fails.
74d40be3-b613-4338-bd86-3ed194e95aa0
In JPQL/HQL, Hibernate requires ordering for array_agg used as an ordered-set aggregate, and the JPQL version of ARRAY_AGG needs either a WITHIN GROUP or an OVER clause to satisfy Hibernate's parser/semantics. The attempt without the required ordering clause fails.