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

["Andrus Adamchik (JIRA)" <ji...@apache.org>]

Andrus Adamchik created CAY-2092:
------------------------------------

             Summary: 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
(v6.3.4#6332)