cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victor Antonovich (JIRA)" <j...@apache.org>
Subject [jira] Created: (CAY-1539) Incorrect offset handling on some queries against database with supported LIMIT/OFFSET clauses
Date Thu, 10 Feb 2011 09:25:03 GMT
Incorrect offset handling on some queries against database with supported LIMIT/OFFSET clauses
----------------------------------------------------------------------------------------------

                 Key: CAY-1539
                 URL: https://issues.apache.org/jira/browse/CAY-1539
             Project: Cayenne
          Issue Type: Bug
          Components: Database integration
    Affects Versions: 3.1M1
         Environment: Apache Cayenne 3.1-SNAPSHOT from trunk, PostgreSQL 8.4.
            Reporter: Victor Antonovich


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.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message