Issue Details (XML | Word | Printable)

Key: RDBMS-96
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
JPOX RDBMS (ARCHIVED)

JDOQL : contains() of an expression can lead to meaningless WHERE clauses

Created: 31/Jan/08 05:18 PM   Updated: 08/Jan/09 11:26 AM   Resolved: 31/Jan/08 05:56 PM
Component/s: Queries
Affects Version/s: 1.2.0-beta-5, 1.2.0-rc-1
Fix Version/s: 1.2.0


 Description  « Hide
JDOQL queries such as
SELECT FROM Office WHERE dept.name.equals("Finance") && departments.contains(dept)

are performing contains(ObjectExpression) which leads to "and" conditions in the SQL such as
THIS_DEPARTMENTS.DEPARTMENT_ID_EID = THIS_DEPARTMENTS.DEPARTMENT_ID_EID

This only occurs for the cases not using EXISTS

Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 31/Jan/08 05:56 PM
SVN trunk fixes this