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
