[ https://issues.apache.org/jira/browse/DERBY-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Nielsen updated DERBY-3349: ---------------------------------- Attachment: d3349-3.diff Attaching updated d3349-3.diff that runs the last two combinations WHERE EXISTS ... WHERE ANY WHERE ANY ... WHERE ANY The test was made part of the suite as part of DERBY-3301. The updated test passes when run against the trunk. > Nested WHERE EXISTS 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 > Attachments: d3349-1.diff, d3349-1.stat, d3349-2.diff, d3349-3.diff > > > 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.