Subject Re: [firebird-support] Re: Procedures and inner/left joins - Strange behavior
Author Ann W. Harrison
fabiano_bonin wrote:
> I expected the procedure would be evaluated just one time using the
> first parameter it received, giving me the following result:

I don't think that makes sense, but I'm not entirely sure that I
understand the whole logic of joins and stored procedures. However,
I can tell you that both Firebird 2 alpha 3 and Vulcan produce the
results you saw - in a left join with the stored procedure last,
the procedure is invoked once for each row produced by the right
hand side of the query.