[Firebird-devel] ODP: CORE-6199 - few question about Firebird 4

2019-12-04 Thread Karol Bieniaszewski
>> IMO, it will be much better if you describe the task you need to solve

Task is in CORE-6199 but i need only part of it.

My current solution is with OAT + RDB$RECORD_VERSION and now i am looking into 
FB4 changes if it can help more.
It is better now because of existence of RDB$GET_TRANSACTION_CN.
But it still do not use and index to query. And my question was about optimize 
this part to use an expression index somehow.

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

2019-12-02 Thread Karol Bieniaszewski
>> 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