[Firebird-devel] ODP: ODP: CORE-6199 - few question about Firebird 4
Ach now i understand. It is point view for current transaction, which record versions it see. Very usefull, thank you. Regards, Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] ODP: CORE-6199 - few question about Firebird 4
>> Last already commited transaction CN. OK >> SNAPSHOT_NUMBER What it mean, is it from current transaction point of view first snapshot, last snapshot transaction what it is? Can you explain value based on below points? 1. Start transaction 1 snapshot 2. Commit transaction 1 3. Start transaction 2 snapshot 4. Start transaction 3 snapshot 5. Start transaction 4 read commited >> See RDB$GET_TRANSACTION_CN, described at >> doc/sql.extensions/README.builtin_functions.txt Super Regards, Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] CORE-6199 - few question about Firebird 4
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
[Firebird-devel] CORE-6199 - few question about Firebird 4
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? SNAPSHOT_CN - what it is? As i do not understand description from README.context_variables2 2. Is there a way to read transaction CN by transaction number? 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, Karol BieniaszewskiFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-6200) Combine embeddedd files into one dll
Combine embeddedd files into one dll Key: CORE-6200 URL: http://tracker.firebirdsql.org/browse/CORE-6200 Project: Firebird Core Issue Type: New Feature Reporter: Clyde Eisenbeis It would be good if the necessary files for embedded were combined into one dll. This would simplify everything and increase the odds of widespread usage. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel