🚀 go-pugleaf

On the topic of joining procs do you think that this might be a case of the 
same _definite_ bug in IB 2007 which I have mentioned in the post "Joining 
stored procs in a query gives different results in IB 2007 and IB 7.5" in 
this news group on February 8, 2008?
This same bug is entered in QC with number 57839 but it hasn't received any 
comments there.

Regards,
Kjell

"Wayne Niddery (TeamB)" <wniddery@chaffaci.on.ca> wrote in message 
news:480f8e10$1@newsgroups.borland.com...
>
> "Adalberto Baldini" <finman@swissonline.ch> wrote in message 
> news:480e09f4$1@newsgroups.borland.com...
>> If I  try :
>> left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc, 'ABIT', 
>> 'DETO') b
>> on (b.abinp = 'ABIT' and b.fil = 'DETO' )
>> where a.conto = '0601' and a.sezio = '5' and a.abinp = 'ABIT' and a.fil =
>> 'DETO'
>>
>> OR
>>
>> left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc,  'ABIT', 
>> 'DETO')
>> b
>> on (b.abinp = a.abinp and b.fil = a.fil )
>> where a.conto = '0601' and a.sezio = '5' and a.abinp = 'ABIT' and a.fil =
>> 'DETO'
>>
>> I get  right data:
>>
>> select [..]
>> left join  ABFL_USRSOCINP_UNO (:UTENTE, a.csoc, a.nreserc, a.abinp, 
>> a.fil) b
>> on (b.abinp = a.abinp and b.fil = a.fil )
>> where a.conto = '0601' and a.sezio = '5' and a.abinp = 'ABIT' and a.fil =
>> 'DETO'
>>
>> I get
>> ABIT   DETO    null null null null
>
> That definitely is a puzzle, it looks like the data must be right, so 
> possibly there's a bug somewhere.
>
> What happens if you, using IBConsole or ISQL, simply select directly from 
> the stored procedure passing various parameters? Do you always get correct 
> returns? Is the stored proc properly calling SUSPEND to return a result 
> set rather than a single set of return values? (Even if it is designed to 
> always return just one record, if you are going to use it as part of a 
> select statement it must call SUSPEND as far as I know).
>
> -- 
> Wayne Niddery - TeamB (www.teamb.com)
> Winwright, Inc. (www.winwright.ca)