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

Query with "NOT IN <subselect from view>" fails [CORE2886] #3270

Closed
firebird-automations opened this issue Feb 25, 2010 · 4 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Poul Dige (tabulex)

Is related to QA430

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.
********************************************

Commits: c27e615 1f12183

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC3 [ 10381 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA430 [ QA430 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

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