02.12.2019 15:26, liviuslivius wrote:
Hi
about http://tracker.firebirdsql.org/browse/CORE-6199
few question about Firebird 4
1. difference between GLOBAL_CN and SNAPSHOT_CN
GLOBAL_CN is it a last already commited transaction CN or next not used already
CN?
Last already commited transaction CN.
SNAPSHOT_CN - what it is? As i do not understand description from
README.context_variables2
It was renamed to SNAPSHOT_NUMBER, btw.
Documentation say:
SNAPSHOT_NUMBER | Value of Snapshot Number of currently
database snapshot: either
| transaction level (for SNAPSHOT or
CONSISTENCY transaction),
| or request level (for READ COMMITTED READ
CONSISTENCY
| transaction). NULL, if snapshot is not exist.
What is not clear here ?
2. Is there a way to read transaction CN by transaction number?
See RDB$GET_TRANSACTION_CN, described at
doc/sql.extensions/README.builtin_functions.txt
i need some function which can be used in sql query e.g.:
select * from MY_TABLE T WHERE transactionCN(T.RDB$RECORD_VERSION)>:XXX
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
