Subject Re: [firebird-support] Re: "no current record for fetch operation" with inner join and SP
Author Nando Dessena
Alexander,

>> 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?

A> Nando, I can't say is it bug or feature, but yes, it is known. Note
A> left join works.

Is it logged somewhere? I couldn't find it on the tracker. Should I
log it there? Should I investigate whether developers think it's
something to be corrected or not?

Yep, I have directed the person who asked me to the left join
workaround.

Thanks
--
Nando Dessena
mailto:nandod@...
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================