[#DERBY-3349] Nested WHERE EXISTS queries need improved testing

Derby

Nested WHERE EXISTS queries need improved testing

Created: 24/Jan/08 11:50 AM Updated: 18/Feb/08 01:12 PM

Return to search

Component/s:

Test

Affects Version/s:

10.2.2.0, 10.3.2.1

Fix Version/s:

10.3.3.0, 10.4.1.3

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
d3349-1.diff	2008-02-07 03:46 PM	Thomas Nielsen	5 kB
d3349-1.stat	2008-02-07 03:46 PM	Thomas Nielsen	0.1 kB
d3349-2.diff	2008-02-07 04:12 PM	Thomas Nielsen	6 kB
d3349-3.diff	2008-02-16 01:13 PM	Thomas Nielsen	8 kB

Issue Links:

Reference

This issue is related to:

~~DERBY-3301~~ Incorrect result from query with nested EXIST

Resolution Date:

18/Feb/08 12:52 PM

Description

« Hide

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

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Repository	Revision	Date	User	Message
ASF	#628686	Mon Feb 18 11:32:15 UTC 2008	dyre	~~DERBY-3349~~: Nested WHERE EXISTS queries need improved testing Patch contributed by Thomas Nielsen Patch file: D3349-3.diff
				Files Changed
				MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/NestedWhereSubqueryTest.java

Repository	Revision	Date	User	Message
ASF	#628704	Mon Feb 18 12:36:20 UTC 2008	dyre	~~DERBY-3349~~, merging to 10.3: Nested WHERE EXISTS queries need improved testing Merged with svn merge -r 628685:628686 ../derby-repro Simple merge with no conflicts; no additional changes were necessary.
				Files Changed
				MODIFY /db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/lang/NestedWhereSubqueryTest.java