[jira] [Commented] (CAY-1130) Joint prefetching on to-many produces trimmed result with fetch limit

["John Huss (JIRA)" <ji...@apache.org>]

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

John Huss commented on CAY-1130:
--------------------------------

I got hit by this in some generic code where is wasn't obvious that this would be a problem.  There should be an exception thrown or it should automatically switch the prefetch to be disjoint.

> Joint prefetching on to-many produces trimmed result with fetch limit
> ---------------------------------------------------------------------
>
>                 Key: CAY-1130
>                 URL: https://issues.apache.org/jira/browse/CAY-1130
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Core Library
>    Affects Versions: 3.0
>            Reporter: Andrus Adamchik
>            Assignee: Andrus Adamchik
>             Fix For: Short term future
>
>
> when testing for CAY-1025 (switching default prefetching to joint prefetches), I realized that it won't work when the query uses fetch limit and to-many relationship is prefetched. The result is trimmed as Cayenne adds a LIMIT clause. Need to test both scenarious - select with a LIMIT SQL clause and in memory LimitResultIterator



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)