Issue Details (XML | Word | Printable)

Key: CORE-925
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
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
 


 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: Ascending order - Click to sort in descending order
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.

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.

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.

Pavel Cisar added a comment - 21/Apr/07 03:43 PM
Fix confirmed for 2.1 Alpha 1. Test added.

Pavel Cisar added a comment - 26/Apr/07 11:41 AM
Reopened to update ticket information.