cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Huss (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAY-1130) Joint prefetching on to-many produces trimmed result with fetch limit
Date Tue, 15 Nov 2016 15:47:58 GMT

    [ 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)

Mime
View raw message