Issue Details (XML | Word | Printable)

Key: CORE-2886
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Poul Dige
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Query with "NOT IN <subselect from view>" fails

Created: 25/Feb/10 08:24 AM   Updated: 15/Jun/11 12:10 PM
Component/s: Engine
Affects Version/s: 2.5 RC2
Fix Version/s: 2.5 RC3, 3.0 Alpha 1

Time Tracking:
Not Specified

Environment: Checked for 32 bit embedded mode, FB2.5 RC2, 2.5.0.25920 on Win2003 server
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
I try to run following case on FB2.5 RC2, 2.5.0.25920 Embedded. I havent tried to verify the problem for a server install yet.
 
 
********************************************
SET SQL DIALECT 3;
SET NAMES ISO8859_1;
SET CLIENTLIB 'fbclient.dll';
 
CREATE DATABASE 'crash.FDB'
USER 'SYSDBA' PASSWORD 'MASTERKEY'
PAGE_SIZE 4096
DEFAULT CHARACTER SET ISO8859_1;
 
CREATE TABLE T (ID INTEGER NOT NULL);

CREATE VIEW V( ID) AS select ID from T;
 
INSERT INTO T (ID) VALUES (1);
INSERT INTO T (ID) VALUES (2);
INSERT INTO T (ID) VALUES (3);
 
COMMIT WORK;
 
SELECT ID FROM T
WHERE ID NOT IN
  (SELECT ID FROM V WHERE ID = 1)
 
--The cursor identified in the UPDATE or DELETE statement is not positioned on a row.
--no current record for fetch operation.
********************************************


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Repository Revision Date User Message
Firebird #48712 Sat Feb 27 18:22:04 GMT+00:00 2010 asfernandes Fixed CORE-2886 - Query with "NOT IN <subselect from view>" fails
Files Changed
MODIFY /firebird/branches/B2_5_Release/src/jrd/cmp.cpp

Repository Revision Date User Message
Firebird #48714 Sat Feb 27 18:24:26 GMT+00:00 2010 asfernandes Frontport fix for CORE-2886 - Query with "NOT IN <subselect from view>" fails
Files Changed
MODIFY /firebird/trunk/src/jrd/cmp.cpp

Adriano dos Santos Fernandes made changes - 27/Feb/10 06:24 PM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Fix Version/s  2.5 RC3 [ 10381 ]
Fix Version/s 3.0 Alpha 1 [ 10331 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 24/Feb/11 10:30 AM
Link This issue is related to QA-430 [ QA-430 ]
Philippe Makowski made changes - 15/Jun/11 12:10 PM
Status Resolved [ 5 ] Closed [ 6 ]
Repository Revision Date User Message
Firebird #53171 Wed Jun 15 12:11:01 GMT+00:00 2011 makowski QA-430 for CORE-2886
Files Changed
ADD /qa/trunk/fbtest/tests/bugs/core_2886.fbt