Changing the catch block:
WHEN /*GDSCODE unique_key_violation*/ ANY DO
Allows us to work around the problem.

> "no current record for fetch" is well-known optimizer bug and in some

form exists even in latest Firebird versions. Usually it happens when
one mixed two kind of JOIN syntax (implicit and explicit JOIN's) in the
same query

In our case, we're selecting from a stored procedure.

> existing debuggers is emulators and can't work exactly same way as

engine

Thank goodness for that otherwise we wouldn't have gotten this far :)

> v1.5 is not developed for a long time, consider upgrade

FB 2.5.2 is on the to-do list, which is now about twenty pages long :(

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of hvlad
Sent: Wednesday, March 13, 2013 9:02 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Catching exception fails under isql

--- In firebird-support@yahoogroups.com, "Rick Debay" wrote:
>
> I think it's a 1.5 bug, as executing the procedure from DBW also fails

"no current record for fetch" is well-known optimizer bug and in some
form exists even in latest Firebird versions. Usually it happens when
one mixed two kind of JOIN syntax (implicit and explicit JOIN's) in the
same query, iirc.

> but works if the stored procedure is stepped through under the DBW
> debugger.

There is no native debuggers for Firebird. All existing debuggers is
emulators and can't work exactly same way as engine itself. Also, they
have own mistakes in implementation. So, don't trust debuggers blindly
:)

Regards,
Vlad

PS v1.5 is not developed for a long time, consider upgrade to the more
recent version...




------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links