[DERBY-3349] Nested WHERE EXISTS queries need improved testing

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.2.0, 10.3.2.1
• Fix Version/s: 10.3.3.0, 10.4.1.3
• Component/s: Test
• Assignee: Thomas Nielsen
• Reporter: Thomas Nielsen
• Created: 24/Jan/08 11:50
• Updated: 18/Feb/08 13:12
• Resolved: 18/Feb/08 12:52

Description

DERBY-3301 reported an error in subquery flattening of nested WHERE EXISTS clauses, or WHERE EXISTS subqueries. The query returned the wrong number of rows.

There is currently some tests for WHERE EXISTS, but none for nested WHERE EXISTS clauses.
See DERBY-3301 for a full sql repro.

Issue Links

• is related to: DERBY-3301 Incorrect result from query with nested EXIST