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: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 21/Dec/11 10:21 AM
Just for the record, getting isolation level is already supported.

Dmitry Yemanov made changes - 05/Jul/13 05:17 PM
Field Original Value New Value
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 05/Jul/13 05:17 PM
Status Open [ 1 ] In Progress [ 3 ]
Dmitry Yemanov made changes - 08/Jul/13 08:14 AM
Summary add new context variables in USER_TRANSACTION namespace Add new context variables to the SYSTEM namespace
Dmitry Yemanov made changes - 08/Jul/13 08:37 AM
Status In Progress [ 3 ] Open [ 1 ]
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 made changes - 08/Jul/13 08:38 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 2.5.3 [ 10461 ]
Fix Version/s 3.0 Alpha 2 [ 10560 ]
Resolution Fixed [ 1 ]
Dmitry Yemanov made changes - 22/Jul/13 03:34 PM
Fix Version/s 3.0 Alpha 1 [ 10331 ]
Fix Version/s 3.0 Alpha 2 [ 10560 ]
Pavel Cisar made changes - 29/Mar/14 02:30 PM
Link This issue is related to QA-519 [ QA-519 ]
Pavel Zotov made changes - 18/Jan/16 04:09 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status No test