SELECT CONNECTION_PROPERTY('SessionID') INTO ses_id;Provides the current session ID within the current database context.
SELECT CONNECTION_PROPERTY('SessionCreateTime') INTO ses_create;Provides the timestamp of when the session was created.
SELECT CONNECTION_PROPERTY('SessionLastTime') INTO ses_last;Provides timestamp of when the session was released by the last request.
SELECT CONNECTION_PROPERTY('http_session_timeout') INTO ses_timeout;Fetches the current session timeout in units of minutes.
CALL sa_set_http_option( 'SessionID', 'my_app_session_1' )Create or change a session context for the current HTTP request. Returns an error if my_app_session_1 is owned by another HTTP request.
CALL sa_set_http_option('SessionID', NULL )If the request comes from the session creator, the current session is deleted immediately; otherwise, the session is marked for deletion. Deleting a session when the request has no session is not an error and has no effect. Changing a session to a SessionID of the current session (has no pending session) - Not an error, no operation. Changing a session to a SessionID in use by another HTTP request - Error. Changing a session when a change is already pending - delete pending session, create new pending session. Changing a session with a pending session back to its original SessionID - delete pending session.
SET TEMPORARY OPTION PUBLIC.http_session_timeout=100;Sets the current HTTP session timeout (in minutes). The default is 30 and the range is 1 to 525600 minutes (365 days) . See http_session_timeout option [database].