[JDO-435] Query with projected variables returns duplicates and extra results that do not satisfy filter

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: JDO 2 final (2.0)
• Fix Version/s: JDO 2 maintenance release 2 (2.2)
• Component/s: tck
• Assignee: Craig L Russell
• Reporter: Craig L Russell
• Created: 12/Oct/06 18:23
• Updated: 02/May/13 02:29
• Resolved: 31/May/08 21:43

Description

org.apache.jdo.tck.query.result.VariableInResult fails with several queries that return variables that are mapped to one-many and many-many relationships. In some cases, the filter is not satisfied. In others, duplicate results are returned.

Issue Links

• depends upon: DERBY-3301 Incorrect result from query with nested EXIST
• relates to: JDO-573 RI creates bad SQL for navigational queries