Implement way to reset user session environment to its initial (default) state ------------------------------------------------------------------------------
Key: CORE-5832 URL: http://tracker.firebirdsql.org/browse/CORE-5832 Project: Firebird Core Issue Type: New Feature Components: Engine Reporter: Vlad Khorsun Resetting user session (connection) to its initial state should be useful when session is reused by application. I.e. instead of detach\attach application could just reuse already established connection. To reuse connection all its user context variables, contents of temporary tables etc should be cleared and all session-level settings should be reset to its default values. The proposed solution is to implement new session management SQL statement ALTER SESSION RESET It will - reset DECFLOAT parameters (BIND, TRAP and ROUND) to its default values - reset session and statement timeouts to zero - remove all context variables in 'USER_SESSION' namespace - clear contents of all used GLOBAL TEMPORARY TABLE ... ON COMMIT PRESERVE ROWS - restore ROLE which was passed with DPB and clear all cached security classes (if role was changed) Note, CURRENT_USER will not be changed. See also discussion at fb-devel, thread "RFC: External Connections Pool" started at 18.05.2018 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ 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