I wanted to report the same issue but my use case is the following:
insert into TABLE_A(id) values (:id)
returning RDB$DB_KEY into :t_dbkey;
and "t_dbkey" is always null.
Tested with Firebird 2.1 RC2 and RC1
Description
Comment from Veselin Pavlov in CORE-1797:
I wanted to report the same issue but my use case is the following:
insert into TABLE_A(id) values (:id)
returning RDB$DB_KEY into :t_dbkey;
and "t_dbkey" is always null.
Tested with Firebird 2.1 RC2 and RC1
Adriano dos Santos Fernandes added a comment - 21/Mar/08 01:12 PM Since this is a V2.1 regression, I'm fixing it.
I don't think this fix alone requires another RC.
Bug
Closed
Major
RDB$DB_KEY evaluates to NULL in INSERT ... RETURNING
I don't think this fix alone requires another RC.