[jira] [Commented] (OPENJPA-1365) DISTINCT keyword has no effect with JOIN FETCH queries

["Heath Thomann (JIRA)" <ji...@apache.org>]

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

Heath Thomann commented on OPENJPA-1365:
----------------------------------------

The Nabble link above doesn't work for me.  For history sake, I'm adding a link to MarkMail which seems to be the same discussion referenced by Mike:

http://markmail.org/thread/aaorycqwq45vw56y

> DISTINCT keyword has no effect with JOIN FETCH queries
> ------------------------------------------------------
>
>                 Key: OPENJPA-1365
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1365
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jpa, query
>    Affects Versions: 1.0.4, 1.2.2, 1.3.0, 2.0.0-beta
>            Reporter: Michael Dick
>         Attachments: OPENJPA-1365-1.0.x-patch.txt
>
>
> This issue occurs if the proposed fix for OPENJPA-894 is in place. Without that fix there results of a JOIN FETCH are always distinct when obtained from the database or non-distinct when returned from the persistence context's L1 cache. 
> I started a discussion on this topic on the dev mailing list. The entire thread can be seen on Nabble here : http://n2.nabble.com/How-should-we-handle-the-JPQL-DISTINCT-keyword-td3908400.html#a3908400



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)