Subject | "no current record for fetch operation" with inner join and SP |
---|---|
Author | Nando Dessena |
Post date | 2004-05-24T17:34:25Z |
Hello,
I'm not sure whether I have a bug or not here.
Here is the reduced test case:
CREATE PROCEDURE TEST1(INPUT1 INTEGER)
RETURNS (VALUE INTEGER) AS
begin
value = input1;
suspend;
end
Try this statement:
select *
from rdb$database
join test1(rdb$relation_id) on (1=1)
and get the error reported in the subject line (Fb 1.5).
Is this a known issue?
Ciao
--
Nando Dessena
mailto:nandod@...
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
I'm not sure whether I have a bug or not here.
Here is the reduced test case:
CREATE PROCEDURE TEST1(INPUT1 INTEGER)
RETURNS (VALUE INTEGER) AS
begin
value = input1;
suspend;
end
Try this statement:
select *
from rdb$database
join test1(rdb$relation_id) on (1=1)
and get the error reported in the subject line (Fb 1.5).
Is this a known issue?
Ciao
--
Nando Dessena
mailto:nandod@...
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================