03.05.2018 12:58, Alex Peshkoff via Firebird-devel 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.
Look at MS SQL. Users have all kind of troubles with its "SET ANSI/COUNT/ETC" variations. SET ROLE may be ok, but changing of SQL/API behavior on the fly is a bad practice, IMHO.
On the other hand Oracle users don't mind ALTER SESSION. -- WBR, SD. ------------------------------------------------------------------------------ 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
