New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ALL predicate works incorrectly for some subqueries [CORE925] #1325
Comments
Modified by: @dyemanovLink: This issue is related to VLC-23 [ VLC-23 ] |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.1 [ 10041 ] |
Commented by: @pcisar For which release version it was fixed? Can't confirm the fix for 2.1 Alpha 1. |
Commented by: @dyemanov 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. |
Commented by: @pcisar Sorry, mea culpa. I have used the query from VLC-23 instead this one. You're correct, it's fixed. |
Commented by: @pcisar Fix confirmed for 2.1 Alpha 1. Test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11198 ] => Firebird [ 15309 ] |
Modified by: @dyemanovLink: This issue is related to VLC-23 [ VLC-23 ] => |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: @dyemanov
Is related to QA44
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.
Commits: a4f78f4
The text was updated successfully, but these errors were encountered: