Adriano dos Santos Fernandes <adrian...@gmail.com> wrote Tue, 28 Aug 2018
13:39:26 +0300:
Adriano,
Oracle does not implement statement consistency only delimited to an
SQL (instead of PL / SQL) because of its loose integration, but
because it's completely nonsense to do the contrary.
And that's bad. That's why they forbid
IF (EXISTS (SELECT * FROM Table))
Re-execution in autonomous transactions is really bad. Therefore, if
something was done in autonomous transaction before the caller of the
conflict, it would be more correct to throw isc_update_conflict.
You could mark in some way transactionally independent UDRs and for them,
too, change the default behavior.
In the end, you can come up with a new isc_tpb_no_restart for read
committed read consistency
--
Simonov Denis
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
