On 8-11-2013 12:42, Tim Ward wrote:

> I tried using RETRY as the name of a column, and as the name of a stored
> procedure parameter, and as the name of a stored procedure variable.
>
> This produced no error messages of any sort at all anywhere, but the
> wrong value for the column got inserted into the table:
>
> INSERT INTO MYTABLE( ..., RETRY ) VALUES ( ..., :RETRY );
>
> inserted zero when the value of the parameter RETRY appeared to be 1 (in
> the Database Workbench procedure debugger - yes I know that doesn't
> prove what it is when the procedure is run normally in Firebird, but I
> still get zero in the column).
>
> On changing all the RETRY names to something else the right value got
> inserted into the table.
>
> I can't find RETRY documented as any sort of reserved word in Firebird,
> and I can't find anything else called RETRY in our application.
>
> Any guesses as to what's going on?

RETRY is not a reserved word according to
http://www.firebirdsql.org/refdocs/langrefupd25-reskeywords-full-reswords.html

If this is reproducable you can report it as a bug on
http://tracker.firebirdsql.org/browse/CORE

Mark
--
Mark Rotteveel