"no current record for fetch operation"
---------------------------------------
Key: CORE-3693
URL: http://tracker.firebirdsql.org/browse/CORE-3693
Project: Firebird Core
Issue Type: Bug
Reporter: Karol Bieniaszewski
when i work on query (not finall) i got error like in subject
i simplify situation to this 3 tables and one derived table (in my normal
solution there are not derived tables then this is not corelated)
CREATE TABLE KAT_OBJ
(
ID INTEGER NOT NULL,
ID_KAT INTEGER NOT NULL,
ID_OBJ INTEGER NOT NULL,
CONSTRAINT PK_KAT_OBJ__ID PRIMARY KEY (ID),
CONSTRAINT UK_KAT_OBJ__ID_OBJ__ID_KAT UNIQUE (ID_OBJ,ID_KAT)
);
CREATE TABLE ZLEC_SERW
(
ID BIGINT NOT NULL,
ID_OBJ INTEGER,
CONSTRAINT PK_ZLEC_SERW__ID PRIMARY KEY (ID)
);
CREATE TABLE ZS_ZALACZNIK
(
ID BIGINT NOT NULL,
ID_ZLEC_SERW BIGINT,
ID_OBJ INTEGER,
CONSTRAINT PK_ZS_ZALACZNIK__ID PRIMARY KEY (ID)
);
CREATE INDEX IXA_KAT_OBJ__ID_KAT ON KAT_OBJ (ID_KAT);
CREATE INDEX IXA_KAT_OBJ__ID_OBJ ON KAT_OBJ (ID_OBJ);
CREATE INDEX IXA_ZS_ZALACZNIK__ID_OBJ ON ZS_ZALACZNIK (ID_OBJ);
CREATE INDEX IXA_ZS_ZALACZNIK__ID_ZLEC_SERW ON ZS_ZALACZNIK (ID_ZLEC_SERW);
INSERT INTO KAT_OBJ (ID, ID_KAT, ID_OBJ) VALUES ('1', '2', '456');
INSERT INTO ZLEC_SERW (ID, ID_OBJ) VALUES ('1', '2');
INSERT INTO ZLEC_SERW (ID, ID_OBJ) VALUES ('2', '456');
INSERT INTO ZS_ZALACZNIK (ID, ID_ZLEC_SERW, ID_OBJ) VALUES ('1', '1', NULL);
INSERT INTO ZS_ZALACZNIK (ID, ID_ZLEC_SERW, ID_OBJ) VALUES ('2', '2', NULL);
SELECT
*
FROM
(SELECT CAST(1 AS INTEGER) AS KAT FROM RDB$DATABASE
) AS KT
INNER JOIN KAT_OBJ KO ON KO.ID_KAT=KT.KAT
INNER JOIN (ZS_ZALACZNIK ZZ LEFT JOIN ZLEC_SERW ZS ON
ZS.ID=ZZ.ID_ZLEC_SERW AND ZS.ID_OBJ=KO.ID_OBJ) ON ZZ.ID_OBJ=KO.ID_OBJ OR
ZZ.ID_ZLEC_SERW=ZS.ID
SQL Message: -508
The cursor identified in the update or delete statement is not positionet on a
row
Engine Code: 335544348
Engine Message:
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
------------------------------------------------------------------------------
Cloud Services Checklist: Pricing and Packaging Optimization
This white paper is intended to serve as a reference, checklist and point of
discussion for anyone considering optimizing the pricing and packaging model
of a cloud services business. Read Now!
http://www.accelacomm.com/jaw/sfnl/114/51491232/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
