Issue Details (XML | Word | Printable)

Key: CORE-3704
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Pavel Zotov
Votes: 6
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Add new context variables to the SYSTEM namespace

Created: 21/Dec/11 10:05 AM   Updated: 18/Jan/16 04:09 PM
Component/s: None
Affects Version/s: None
Fix Version/s: 3.0 Alpha 1, 2.5.3

Issue Links:
Relate
 

QA Status: No test


 Description  « Hide
it will be useful to get information within current transaction about itself, i.e. it's READ_ONLY, ISOLATION_MODE, LOCK_TIMEOUT and was it run as AUTONOMOUS or as 'normal'.
Currently we can get such info only via MON$-tables but this way lead to poor performance in high-loaded systems.

 All   Comments   Change History   Subversion Commits      Sort Order: Descending order - Click to sort in ascending order
Dmitry Yemanov added a comment - 08/Jul/13 08:38 AM
Added variables: SYSTEM::CLIENT_PID and SYSTEM::CLIENT_PROCESS for the current connection, SYSTEM::LOCK_TIMEOUT and SYSTEM::READ_ONLY for the current transaction.

Dmitry Yemanov added a comment - 21/Dec/11 10:21 AM
Just for the record, getting isolation level is already supported.