[
https://issues.apache.org/jira/browse/DERBY-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas Nielsen updated DERBY-3349:
----------------------------------
Attachment: d3349-1.diff
d3349-1.stat
I added the 5 other queries in the sql repro posted in DERBY-3301 to the new
junit NestedWhereSubqueryTest.
The updated test pass with the 1 patch applied.
I think this update should be commited to be on the safe side. But there is
still more work to be done to complete this issue, mainly around covering all
the combinations Army listed earlier in 3301.
> 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
>
>
> 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.
