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!
That can't happens. Functions called in PSQL statement could have side effects outside the database. Statement consistency should be about individual SQL (SELECT / UPDATE / INSERT / MERGE / UPDATE OR INSERT) statements, not requests. Adriano ------------------------------------------------------------------------------ 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