Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
3.1M1
-
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.