Nested WHERE EXITS queries need improved testing
------------------------------------------------
Key: DERBY-3349
URL: https://issues.apache.org/jira/browse/DERBY-3349
Project: Derby
Issue Type: Improvement
Components: Test
Reporter: Thomas Nielsen
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.