On 18/02/2019 05:50, Vlad Khorsun wrote: > 18.02.2019 1:49, Adriano dos Santos Fernandes wrote: >> Open two connections C1 and C2. >> >> C2: select current_transaction from rdb$database; -- let's call the >> result T2 >> C2: commit; >> >> C1: select rdb$get_transaction_cn(T2) from rdb$database; >> >> In Super C1 returns the commit number. In Classic it returns NULL. > > Yes, this is because C1 see no new Next value and consider T2 as not > existing. > We could refresh TIP Cache in C1 but it looks as overkill in this case. > That difference is not documented. Considering that (and not), was is the usefulness of RDB$GET_TRANSACTION_CN?
Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
