[jira] [Commented] (CAY-2092) Exception for query that uses pagination and sorting on to-many

["Guðmundur Stefán Þorvaldsson (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAY-2092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16796665#comment-16796665 ] 

Guðmundur Stefán Þorvaldsson commented on CAY-2092:
---------------------------------------------------

I just managed to produce this exception in my project, using both pagination and ordering, just as described.

Why does it not make sense to order before pagination? 

Would it be possible for someone to look into this?

> Exception for query that uses pagination and sorting on to-many
> ---------------------------------------------------------------
>
>                 Key: CAY-2092
>                 URL: https://issues.apache.org/jira/browse/CAY-2092
>             Project: Cayenne
>          Issue Type: Bug
>    Affects Versions: 4.0.M3
>            Reporter: Andrus Adamchik
>            Priority: Minor
>
> Somehow we haven't seen this reported before, perhaps because the combination makes no practical sense. I was able to find it during regression testing of a LinkRest app that translates REST calls to Cayenne SelectQueries. Anyways, a query that uses pagination and also ordering on a property of a to-many relationship (the ordering part doesn't make sense) ends up generating the following exception, even though all the data is there:
> org.apache.cayenne.CayenneRuntimeException: [v.4.0.M3 Feb 08 2016 16:38:05] Some ObjectIds are missing from the database. Expected 62, fetched 31
> 	at org.apache.cayenne.access.IncrementalFaultList.checkPageResultConsistency(IncrementalFaultList.java:323)
> 	at org.apache.cayenne.access.IncrementalFaultList.resolveInterval(IncrementalFaultList.java:262)
> 	at org.apache.cayenne.access.IncrementalFaultList.get(IncrementalFaultList.java:507)
> 	at com.nhl.link.rest.encoder.ListEncoder.visit(ListEncoder.java:168)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)