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