"no current record for fetch operation" when joining with stored procedure
inside derived table
-----------------------------------------------------------------------------------------------
Key: CORE-6124
URL: http://tracker.firebirdsql.org/browse/CORE-6124
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5
Reporter: Karol Bieniaszewski
SET TERM ^ ;
CREATE PROCEDURE PSTRID
( IN_ID1 VARCHAR(100), IN_ID2 VARCHAR(100))
RETURNS
( ID1 VARCHAR(100), ID2 VARCHAR(100))
AS
BEGIN
ID1 = IN_ID1;
ID2 = IN_ID2;
SUSPEND;
END^
SET TERM ; ^
SELECT
*
FROM
RDB$RELATIONS R
INNER JOIN
(SELECT
*
FROM
RDB$RELATION_FIELDS F
INNER JOIN PSTRID(F.RDB$RELATION_NAME, F.RDB$FIELD_NAME) P ON
P.ID1 = F.RDB$RELATION_NAME AND P.ID2 = F.RDB$FIELD_NAME ROWS 2) F2 ON
R.RDB$RELATION_NAME = F2.RDB$RELATION_NAME
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
