cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dzmitry Kazimirchyk (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CAY-1266) Joint prefetches with fetch limit and offset do not work on Oracle
Date Fri, 29 Jul 2011 07:56:09 GMT

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

Dzmitry Kazimirchyk updated CAY-1266:
-------------------------------------

    Attachment: joint-prefetches-oracle.patch

> Joint prefetches with fetch limit and offset do not work on Oracle
> ------------------------------------------------------------------
>
>                 Key: CAY-1266
>                 URL: https://issues.apache.org/jira/browse/CAY-1266
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Database integration
>    Affects Versions: 3.0M6, 3.0
>            Reporter: Andrey Razumovsky
>            Priority: Critical
>             Fix For: Undefined future
>
>         Attachments: joint-prefetches-oracle-test.patch, joint-prefetches-oracle.patch,
joint-prefetches-oracle.patch
>
>
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message