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] [Closed] (CAY-1928) Second INNER join generated for OUTER flattended relationships in disjoint prefetches
Date Sun, 04 May 2014 14:47:15 GMT

     [ https://issues.apache.org/jira/browse/CAY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Andrus Adamchik closed CAY-1928.
--------------------------------

       Resolution: Fixed
    Fix Version/s: 3.2.M2
                   3.1 (final)

> Second INNER join generated for OUTER flattended relationships in disjoint prefetches
> -------------------------------------------------------------------------------------
>
>                 Key: CAY-1928
>                 URL: https://issues.apache.org/jira/browse/CAY-1928
>             Project: Cayenne
>          Issue Type: Bug
>    Affects Versions: 3.1M3, 3.2M1
>            Reporter: Andrus Adamchik
>            Assignee: Andrus Adamchik
>             Fix For: 3.1 (final), 3.2.M2
>
>
> In a situation when a query qualifier contains an outer join hint for a flattened relationship,
Cayenne correctly generates a pair of OUTER joins in the root query SQL. However all disjoint
prefetch queries are only using OUTER for the first join, and INNER for the second. This causes
subtle issues, such as prefetch queries returning a trucated result (when a root object doesn't
have anything on the target side of OUTER relationship).



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message