Re: [Firebird-test] [FB-Tracker] Resolved: (CORE-2886) Query with "NOT IN <subselect from view>" fails

[Poul D. <pd...@ta...>]

Wow... that was fast!

Thank you :)

Regards
Poul




----- Original Message ----- 
From: "Adriano dos Santos Fernandes (JIRA)" <tr...@fi...>
To: <pd...@ta...>
Sent: Saturday, February 27, 2010 7:29 PM
Subject: [FB-Tracker] Resolved: (CORE-2886) Query with "NOT IN <subselect 
from view>" fails


>
>     [ 
> http://tracker.firebirdsql.org/browse/CORE-2886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
>
> Adriano dos Santos Fernandes resolved CORE-2886.
> ------------------------------------------------
>
>         Assignee: Adriano dos Santos Fernandes
>    Fix Version/s:  2.5 RC3
>                   3.0 Alpha 1
>       Resolution: Fixed
>
>> Query with "NOT IN <subselect from view>" fails
>> -----------------------------------------------
>>
>>                 Key: CORE-2886
>>                 URL: http://tracker.firebirdsql.org/browse/CORE-2886
>>             Project: Firebird Core
>>          Issue Type: Bug
>>          Components: Engine
>>    Affects Versions: 2.5 RC2
>>         Environment: Checked for 32 bit embedded mode, FB2.5 RC2, 
>> 2.5.0.25920 on  Win2003 server
>>            Reporter: Poul Dige
>>            Assignee: Adriano dos Santos Fernandes
>>             Fix For:  2.5 RC3, 3.0 Alpha 1
>>
>>
>> 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.
>> ********************************************
>
> -- 
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators: 
> http://tracker.firebirdsql.org/secure/Administrators.jspa
> -
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>
>
>
>