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.

Reply via email to