DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Areg Beketovski
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

DISTINCT is not set for the result size calculation query when the base query is cached at the datastore level

Created: 16/Jun/10 08:20 PM   Updated: 27/Jun/10 08:57 AM   Resolved: 17/Jun/10 04:25 PM
Component/s: Queries
Affects Version/s: 2.1.0.release
Fix Version/s: 2.1.1

File Attachments: 1. Text File JDOQLQuery.patch (0.7 kB)
2. Zip Archive (4 kB)

Datastore: H2

 Description  « Hide
Running an already cached at the datastore level query for the second time. Returned size() of the result collection is incorrect. "SELECT COUNT()" SQL is produced instead of "SELECT COUNT(DISTINCT)".

Please see attached testcase for H2.

Sort Order: Ascending order - Click to sort in descending order
Areg Beketovski added a comment - 16/Jun/10 08:21 PM - edited
Testcase reproducing the issue.

Areg Beketovski added a comment - 17/Jun/10 01:35 PM
Proposed patch fixing the issue.

Andy Jefferson added a comment - 17/Jun/10 04:25 PM
SVN trunk has this patch. Thx