[Firebird-devel] Error in Alpha4 with LEFT OUTER JOIN and SP (repost)

[Christian P. <c_p...@ya...>]

Hi!

I'm sending this again because I haven't any responce.


The following query have problems in Alpha 4 but it works fine in Alpha 3:

SELECT P.FARTINT, P.FCANTID, Z.FPRECIO, Z.FDESCUE
FROM PED_PALM P
LEFT OUTER JOIN Z_WAP_PREDES(13,P.FARTINT) Z ON Z.FCODINT=P.FARTINT
WHERE P.FCLIINT=13 AND P.FPROCES='N'


Alpha 3

returns    137    1    6.8    24.8

----------------------------------------------------------------
Alpha 4:

Statement failed, SQLCODE = -508
no current record for fetch operation

if you run separatly it works fine:

SELECT P.FARTINT, P.FCANTID
FROM PED_PALM P
WHERE P.FCLIINT=13 AND P.FPROCES='N'

returns:    137    1

SELECT Z.FCODINT, Z.FPRECIO, Z.FDESCUE
FROM Z_WAP_PREDES(13,137) Z

returns:    137    6.8    24.8


Best regards
Christian