db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Nielsen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3349) Nested WHERE EXISTS queries need improved testing
Date Thu, 07 Feb 2008 15:48:09 GMT

     [ 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.


Mime
View raw message