[jira] Created: (CAY-1110) fetchLimit + DistinctResultIterator = fewer rows in the result

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Tue Sep 23 2008 - 14:43:12 EDT

Next message: Andrey Razumovsky (JIRA): "[jira] Commented: (CAY-1080) Support for copy/paste of entities/attributes/relationships"

Previous message: Andrey Razumovsky (JIRA): "[jira] Assigned: (CAY-1109) Non-physical delete (through update) does not work properly"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.

Next message: Andrey Razumovsky (JIRA): "[jira] Commented: (CAY-1080) Support for copy/paste of entities/attributes/relationships"
Previous message: Andrey Razumovsky (JIRA): "[jira] Assigned: (CAY-1109) Non-physical delete (through update) does not work properly"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Tue Sep 23 2008 - 14:43:38 EDT