On 17-10-2021 13:57, Mark Rotteveel wrote:
I'm making changes to Jaybird to support the new multi-row RETURNING
results.
When using UPDATE OR INSERT ... RETURNING statements in Firebird 5, the
insert count (isc_info_req_insert_count) is 2 instead of 1. Jaybird
obtains this count after fetching the rows. On the other hand, in ISQL a
count of 1 is reported.
What could be the reason for this difference?
I also observed this with a statement like
INSERT INTO TABLE_WITH_TRIGGER(TEXT) (select cast(? as varchar(200))
from rdb$database union all select cast(? as varchar(200)) from
rdb$database) RETURNING *
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
