Problemunvalidated
Trying to replace a working native Postgres query that uses ARRAY_AGG with a non-native Spring Data JPA query and projection. Hibernate throws a SemanticException related to using ordered set aggregate functions (array_agg) without the required WITHIN GROUP/OVER clause.
73bef4b3-c000-4085-8535-08d360c8bb1e
Trying to replace a working native Postgres query that uses ARRAY_AGG with a non-native Spring Data JPA query and projection. Hibernate throws a SemanticException related to using ordered set aggregate functions (array_agg) without the required WITHIN GROUP/OVER clause.