Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1266

Joint prefetches with fetch limit and offset do not work on Oracle

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 3.0M6, 3.0
    • 3.1M3
    • Database integration
    • None

    Description

      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

      Attachments

        1. joint-prefetches-oracle.patch
          3 kB
          Dzmitry Kazimirchyk
        2. joint-prefetches-oracle.patch
          4 kB
          Dzmitry Kazimirchyk
        3. joint-prefetches-oracle-test.patch
          2 kB
          Dzmitry Kazimirchyk
        4. joint-prefetches-oracle.patch
          3 kB
          Dzmitry Kazimirchyk

        Activity

          People

            Unassigned Unassigned
            antidote Andrey Razumovsky
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: