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
Comments
Commented by: Derryck welas (welas) zipped database for the testcase created in fb 2.5Alpha |
Modified by: Derryck welas (welas)Attachment: TEST.zip [ 11292 ] |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Commented by: @dyemanov This issue is resolved in v2.5 Beta (only). It will be closed after the code review and appropriate testing. |
Commented by: Derryck welas (welas) Yes, test1 is oke with snapshot / 2.5.0.22381 |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 Beta 1 [ 10251 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: No test => Cannot be tested Test Details: Broken link to attachment. |
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.
The text was updated successfully, but these errors were encountered: