[
https://issues.apache.org/jira/browse/DELTASPIKE-901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14546837#comment-14546837
]
Romain Manni-Bucau commented on DELTASPIKE-901:
-----------------------------------------------
Seems this commit fixed it
https://github.com/apache/deltaspike/commit/81f47b3260a4fffc7883d50ac2fc868001fb4bb7
Few more inputs in my case:
- was using openjpa
- order by was on primary key which was a String
If you have a test with these 2 constraints I'm happy :)
> 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)
