On 18-04-2020 16:20, Vlad Khorsun wrote:
Firebird now internally prefetched first row when statement is executed.
It allows to unify and simplify request restart logic in read consistency
transactions.
Was this change intentional?
Yes
Ok, good to know. I'll modify the test so it no longer fails on this.
> Jaybird itself uses this test to verify if it is really using
isc_tpb_autocommit or not (with the 'standard' autocommit of Jaybird,
> the commit would only happen after the stored procedure execution is
complete).
Seems Firebird's autocommit should follow same rule - commit after
all rows fetched
Changing this behaviour of isc_tpb_autocommit looks like a rather big
breaking change compared to its current behaviour. I'm not sure changing
that is a good idea. If I use this effect for a test, I wouldn't be
surprised if someone is relying on this behaviour in production code.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
