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
