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

[Romain Manni-Bucau (JIRA)]

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)