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

Incorrect offset handling on some queries against database with supported LIMIT/OFFSET clauses

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.1M1
    • 3.1M3
    • Database integration
    • None
    • Apache Cayenne 3.1-SNAPSHOT from trunk, PostgreSQL 8.4.

    Description

      Select queries with offset set and suppressed DISTINCT clause running against database like PostgreSQL (with OFFSET/LIMIT clauses supported) are handled incorrectly. Now, DISTINCT suppressing in SelectTranslator also suppress LIMIT/OFFSET SQL query clauses, but in-memory offset returned by SelectAction.getInMemoryOffset() remain unchanged, effectively zeroing offset for these queries against databases like PostgreSQL.

      Attachments

        1. select_action_offset_handling.patch
          0.8 kB
          Victor Antonovich

        Activity

          People

            Unassigned Unassigned
            kapyar Victor Antonovich
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: