[#CORE-925] ALL predicate works incorrectly for some subqueries

Firebird Core

ALL predicate works incorrectly for some subqueries

Created: 12/Sep/06 02:40 AM Updated: 17/Jun/07 11:48 AM

Component/s:

Engine

Affects Version/s:

1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.5.0, 1.5.1, 1.5.2, 1.5.3, 2.0 RC1, 2.0 RC2, 2.0 RC3, 2.0 RC4

Fix Version/s:

2.1 Alpha 1

Time Tracking:

Not Specified

Environment:

Win32

Issue Links:

Relate

This issue is related to:

~~QA-44~~ Test for CORE-925

~~VLC-23~~ Vulcan throws fb_assert with incorrect RSB type in join operation

Description

« Hide

Test case can be found in ~~VLC-23~~. The query is:

SELECT EMPNUM
FROM WORKS
GROUP BY EMPNUM
HAVING EMPNUM = ALL
( SELECT WORKS.EMPNUM
FROM WORKS JOIN STAFF ON WORKS.EMPNUM = STAFF.EMPNUM )

it should return an empty rowset, but it wrongly returns 4 rows.

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Pavel Cisar added a comment - 21/Apr/07 11:53 AM

For which release version it was fixed? Can't confirm the fix for 2.1 Alpha 1.

[ Permalink | « Hide ]

Dmitry Yemanov added a comment - 21/Apr/07 01:37 PM

Just tried with 2.1.0.15199 Alpha 1 and the query returns no rows. v2.0.1 returns four rows. Both tests done on WinXP, over localhost TCP connection.

[ Permalink | « Hide ]

Pavel Cisar added a comment - 21/Apr/07 03:42 PM

Sorry, mea culpa. I have used the query from ~~VLC-23~~ instead this one. You're correct, it's fixed.