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
There are no comments yet on this issue.