fetchLimit + DistinctResultIterator = fewer rows in the result
--------------------------------------------------------------
Key: CAY-1110
URL: https://issues.apache.org/cayenne/browse/CAY-1110
Project: Cayenne
Issue Type: Bug
Components: Cayenne Core Library
Affects Versions: 3.0
Reporter: Andrus Adamchik
Assignee: Andrus Adamchik
Fix For: 3.0
I don't have a test case yet, but I noticed in a SelectQuery with implicit
DISTINCT (due to a qualifier on to-many), if the root entity has columns that
force Cayenne into outside-of-db distinct check (e.g. CLOB columns), I am
getting fewer results than the fetch limit. This is due to fetch limit being
applied inside the inner result iterator (JDBCResultIterator) not the outer
filtering iterator (DistinctResultIterator)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
