[jira] Updated: (CAY-1266) Joint prefetches do not work on Oracle

["Ari Maniatis (JIRA)" <ji...@apache.org>]

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

Ari Maniatis updated CAY-1266:
------------------------------

      Component/s: Core Library
         Priority: Blocker  (was: Major)
    Fix Version/s: 3.0RC2

This looks like it might be a blocker for release.

> Joint prefetches do not work on Oracle
> --------------------------------------
>
>                 Key: CAY-1266
>                 URL: https://issues.apache.org/jira/browse/CAY-1266
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Core Library
>    Affects Versions: 3.0M6
>            Reporter: Andrey Razumovsky
>            Priority: Blocker
>             Fix For: 3.0RC2
>
>
> Joint prefetches do not work on Oracle(when at least one column name in root and prefetched tables has the same name (this is the most common case - source and target join columns have the same name). Example of invalid SQL: 
> select * from ( select tid.*, ROWNUM rnum from (SELECT DISTINCT t0.DOCID, t0.DOCTYPEID, t0.DOCDATE, t0.TIMESTAMP, t0.DOCDATEBEGIN, t0.DOCDESC, t0.DOCNAME, t0.DOCEND, t0.DOCDATEEND, t0.DOCSTATUSID, t0.LABELID, t0.DOCNUMBER, t0.DELETED, t0.DBUSER, t0.FOLDERID, t0.DOCDATEAGREE, t1.DBUSER, t1.DELETED, t1.TIMESTAMP, t1.CUSTOMERID, t1.DOCID, t1.KCADOCID, t1.KCADOCTYPEID, t1.KCAID, t1.ORGSID FROM DOC t0 LEFT JOIN KCA_DOC t1 ON (t0.DOCID = t1.DOCID) WHERE t0.DOCTYPEID = ?) tid where ROWNUM <=30) where rnum  > 0

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.