[jira] [Updated] (DELTASPIKE-901) org.apache.deltaspike.data.impl.builder.postprocessor.CountQueryPostProcessor doesn't respect order by

["Gerhard Petracek (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DELTASPIKE-901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gerhard Petracek updated DELTASPIKE-901:
----------------------------------------
    Fix Version/s: 1.4.1

> 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
>            Assignee: Rafael Benevides
>             Fix For: 1.4.1
>
>         Attachments: DELTASPIKE-901.patch
>
>
> "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)