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

From: Loiko Dima (JIRA) ("Loiko)
Date: Thu Oct 09 2008 - 12:12:11 EDT

  • Next message: Ari Maniatis (JIRA): "[jira] Created: (CAY-1120) Deadlock CayenneContextGraphManager when committing from two threads"

         [ https://issues.apache.org/cayenne/browse/CAY-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Loiko Dima updated CAY-1110:
    ----------------------------

        Attachment: limit.txt

    > 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
    >
    > Attachments: limit.txt, limitIterator.txt, test_v_2.txt
    >
    >
    > 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.

    This archive was generated by hypermail 2.0.0 : Thu Oct 09 2008 - 12:13:03 EDT