Skip to content
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

Closed
firebird-automations opened this issue Sep 12, 2006 · 18 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is related to VLC-23 [ VLC-23 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Fix confirmed for 2.1 Alpha 1. Test added.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Reopened to update ticket information.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Reopened [ 4 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue relate to QA44 [ QA44 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue relate to QA44 [ QA44 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA44 [ QA44 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11198 ] => Firebird [ 15309 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is related to VLC-23 [ VLC-23 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test => Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment