Add new context variables to the SYSTEM namespace [CORE3704]

[firebird-automations]

Submitted by: @pavel-zotov

Is related to QA519

Votes: 6

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.

Commits: 60efbc6 0c708df FirebirdSQL/fbt-repository@58535d1 FirebirdSQL/fbt-repository@635e069

[firebird-automations]

Commented by: @dyemanov

Just for the record, getting isolation level is already supported.

[firebird-automations]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-automations]

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

[firebird-automations]

Modified by: @dyemanov

summary: add new context variables in USER_TRANSACTION namespace => Add new context variables to the SYSTEM namespace

[firebird-automations]

Modified by: @dyemanov

status: In Progress [ 3 ] => Open [ 1 ]

[firebird-automations]

Commented by: @dyemanov

Added variables: SYSTEM::CLIENT_PID and SYSTEM::CLIENT_PROCESS for the current connection, SYSTEM::LOCK_TIMEOUT and SYSTEM::READ_ONLY for the current transaction.

[firebird-automations]

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.3 [ 10461 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

[firebird-automations]

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 3.0 Alpha 2 [ 10560 ] =>

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA519 [ QA519 ]

[firebird-automations]

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test