On 03/05/2018 09:28, Mark Rotteveel wrote: > >> The decision should be taken. Prior fb4 session control statement SET >> ROLE was treated as DDL. Now we have rather lot of such statements, >> separate type of node for them, and adding them to >> procedures/triggers bodies is not big technical problem. But I'm not >> sure what long-term issues may arise. > > I don't really like the idea of stored procedures or triggers being > able to change session configuration, because they don't **own** the > session and therefor shouldn't mess with it. On the other hand, having > that flexibility may will be nice to have in some situations (although > it should still be used sparingly IMHO). >
Worse than being a session configuration, it's a configuration for the client only. BTW, such type of client configuration must be independent for client and external engines contexts, like the connection charset is. There is no sense in one changing it and affecting the other too. 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