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

Wrong result set with the IN / NOT IN predicate [CORE2277] #2703

Closed
firebird-automations opened this issue Jan 16, 2009 · 10 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Derryck welas (welas)

Is related to CORE2164

Attachments:
TEST.zip

Hi ,

we get wrong results with the following case .

SELECT * FROM CTRY_TEST
WHERE
/* test1) WRONG RESULT SET*/
TO_CTRY IN (SELECT A.CTRY_OBJID FROM CTRY_GROUP_COLLECTION a,CTRY_GROUP b WHERE a.ctry_GROUP_OBJID=b.objid and B.GROUPCODE='EUROPE' )
AND SOLD_CTRY NOT IN (SELECT A.CTRY_OBJID FROM CTRY_GROUP_COLLECTION a,CTRY_GROUP b WHERE a.ctry_GROUP_OBJID=b.objid and B.GROUPCODE='EUROPE' )

/**test 2)WORKS OKE**/
--TO_CTRY IN (1,2)
--AND SOLD_CTRY NOT IN (1,2 )

/**test3) WORKS OKE**/
--TO_CTRY IN (SELECT A.CTRY_OBJID FROM CTRY_GROUP_COLLECTION a WHERE a.ctry_GROUP_OBJID=1 )
--AND SOLD_CTRY NOT IN (SELECT A.CTRY_OBJID FROM CTRY_GROUP_COLLECTION a WHERE a.ctry_GROUP_OBJID=1 )

This works oke with fb 1.5x
the attached database is fb 2.5Alpha ods.

====== Test Details ======

Broken link to attachment.

@firebird-automations
Copy link
Collaborator Author

Commented by: Derryck welas (welas)

zipped database for the testcase

created in fb 2.5Alpha

@firebird-automations
Copy link
Collaborator Author

Modified by: Derryck welas (welas)

Attachment: TEST.zip [ 11292 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is related to CORE2164 [ CORE2164 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

This issue is resolved in v2.5 Beta (only). It will be closed after the code review and appropriate testing.
You could try the latest snapshots in order to validate the fix.

@firebird-automations
Copy link
Collaborator Author

Commented by: Derryck welas (welas)

Yes, test1 is oke with snapshot / 2.5.0.22381

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Cannot be tested

Test Details: Broken link to attachment.

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