27.08.2018 20:10, Adriano dos Santos Fernandes wrote:
the whole thing may execute repeated times
Imagine selectable SP/UDR joined to a table. Depending on the plan, SP/UDR may be executed once or multiple times. You have virtually no control over this. If that SP/UDR has "side effects", you'll need to deal with the consequences. I don't see much difference from the "statement consistency issue" you mention. Of course, repeated execution may be less/not expected in more straightforward execution paths, but it doesn't mean it's absolutely impossible.
Dmitry ------------------------------------------------------------------------------ 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