[
https://issues.apache.org/jira/browse/CAY-2092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16796813#comment-16796813
]
Andrus Adamchik edited comment on CAY-2092 at 3/20/19 5:38 AM:
---------------------------------------------------------------
> Why does it not make sense to order before pagination?
It does make sense in a general case of course. Here I was talking about a very
specific case - ordering on a to-many relationship. E.g. you are fetching
Artists, but ordering on Artist's "paintings.name" property. This seems valid,
but not very useful, no?
was (Author: andrus):
> Why does it not make sense to order before pagination?
It does make sense in a general case of course. Here I was talking about very
specific case - ordering on a to-many relationship. E.g. you are fetching
Artists, but ordering on Artist's "paintings.name" property. This seems valid,
but not very useful, no?
> 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)
