--- In firebird-support@yahoogroups.com, Nando Dessena <nandod@d...>
wrote:

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

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

Best regards,
Alexander.