Provide information about Global Commit Number, Commit Number of currently used database snapshot (if any) and Commit Numbers assigned to the committed transactions [CORE5921]

[firebird-automations]

Submitted by: @hvlad

Commits: fded677

====== Test Details ======

ISQL-based test does not verify cases when Tx is dead or in limbo.
Perhaps, Python-based implementation is required and will be created later.

[firebird-automations]

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

[firebird-automations]

Commented by: @hvlad

There is two new context variables GLOBAL_CN and SNAPSHOT_CN in SYSTEM namespace and new built-in function RDB$GET_TRANSACTION_CN.
Detailed documentation at doc\sql.extensions\README.context_variables2 and doc\sql.extensions\README.builtin_functions.txt

[firebird-automations]

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

[firebird-automations]

Modified by: @pavel-zotov

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

QA Status: No test => Deferred

Test Details: Question raised about result of rdb$get_transaction_cn() when using ISQL with default setting for SET AUTODDL.
Waiting for reply, letter to dimitr and hvlad, 24.09.2018 08:34.

[firebird-automations]

Modified by: @pavel-zotov

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

QA Status: Deferred => Done with caveats

Test Details: Question raised about result of rdb$get_transaction_cn() when using ISQL with default setting for SET AUTODDL.
Waiting for reply, letter to dimitr and hvlad, 24.09.2018 08:34.

=>

ISQL-based test does not verify cases when Tx is dead or in limbo.
Perhaps, Python-based implementation is required and will be created later.