cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (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:57:58 GMT

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

Andrus Adamchik commented on CAY-1130:
--------------------------------------

I agree. If we can reliably detect that a to-many is present  in prefetches, we should complain.
Even with disjoint I suspect it may be problematic when LIMIT is used (as we can't apply the
limit to the second query). disjoint-by-id is probably the safest option.

> 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