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?
Looking at the isc_info_sql_records result of an UPDATE ... RETURNING
affecting two rows (update = 2, insert = 2, delete = 0, select = 4), it
seems Firebird also counts the inserts into the temporary table. How
come ISQL is able to show the correct number?
Also, it seems that producing the rows from the temporary tables is also
counted towards isc_info_req_select_count.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
