Romain Manni-Bucau created DELTASPIKE-901: ---------------------------------------------
Summary: org.apache.deltaspike.data.impl.builder.postprocessor.CountQueryPostProcessor doesn't respect order by Key: DELTASPIKE-901 URL: https://issues.apache.org/jira/browse/DELTASPIKE-901 Project: DeltaSpike Issue Type: Bug Affects Versions: 1.3.0 Reporter: Romain Manni-Bucau "using select p from MyEntity p order by p.someString" and {code} @Query(named = "MyEntity.findAll") QueryResult<MyEntity> all(@FirstResult int start, @MaxResults int pageSize); {code} I get {code} org.apache.openjpa.lib.jdbc.ReportingSQLException: expression not in aggregate or GROUP BY columns: T0.PROPERTY_KEY {SELECT COUNT(t0.property_key), t0.property_key FROM properties t0} [code=-5574, state=42574] {code} the count post processor doesn't handle the order by correctly. Wonder if we should add order by parameters in the select clause or just ignore it. -- This message was sent by Atlassian JIRA (v6.3.4#6332)