You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org> on 2008/09/23 20:43:12 UTC
[jira] Created: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
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.
[jira] Updated: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
Posted by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik updated CAY-1110:
---------------------------------
Attachment: (was: test.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: 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.
[jira] Closed: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
Posted by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik closed CAY-1110.
--------------------------------
Resolution: Fixed
> 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, limitIterator_1.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.
[jira] Updated: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
Posted by "Loiko Dima (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Loiko Dima updated CAY-1110:
----------------------------
Attachment: limitIterator.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: 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.
[jira] Updated: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
Posted by "Loiko Dima (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Loiko Dima updated CAY-1110:
----------------------------
Attachment: test_v_1.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: test.txt, test_v_1.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.
[jira] Updated: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
Posted by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik updated CAY-1110:
---------------------------------
Attachment: (was: test_v_1.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: 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.
[jira] Updated: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
Posted by "Loiko Dima (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Loiko Dima updated CAY-1110:
----------------------------
Attachment: test.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: test.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.
[jira] Updated: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
Posted by "Loiko Dima (JIRA)" <de...@cayenne.apache.org>.
[ 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.
[jira] Updated: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
Posted by "Loiko Dima (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Loiko Dima updated CAY-1110:
----------------------------
Attachment: test_v_2.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: test.txt, test_v_1.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.
[jira] Updated: (CAY-1110) fetchLimit + DistinctResultIterator =
fewer rows in the result
Posted by "Loiko Dima (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Loiko Dima updated CAY-1110:
----------------------------
Attachment: limitIterator_1.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, limitIterator_1.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.