Issue Details (XML | Word | Printable)

Key: NUCRDBMS-419
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Areg Beketovski
Votes: 0
Watchers: 0
Operations

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 testcase.zip (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