27.08.2018 18:49, Adriano dos Santos Fernandes wrote:
On 27/08/2018 12:16, Vlad Khorsun wrote:
Whole execution tree, starting from top-level request, will be
executed again
within new snapshot. So, yes, that UDF\UDR will be also executed
again, unless
control flow changed its path because of new data visible within new
snapshot.
Then we do not have a feature. We do have a very big bug!
Think twice. And than think again.
That can't happens. Functions called in PSQL statement could have side
effects outside the database.
How it is related with consistency ? Also, we already have such behaviour
even within single statement.
Statement consistency should be about individual SQL (SELECT / UPDATE /
INSERT / MERGE / UPDATE OR INSERT) statements, not requests.
This is not consistency. This is spaghetty.
Regards,
Vlad
------------------------------------------------------------------------------
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
