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?

  Let GLobal CN = 100 at this point.

 1. Start transaction 1 snapshot

  Here transaction level snapshot is created and it get an own snapshot number 
(100, current value of Global CN)

 2. Commit transaction 1

  Transactin's snapshot is released.

Transaction's Commit Number is assigned (101, Global CN was incremented)

 3. Start transaction 2 snapshot

  Transaction level snapshot is created and it get an own snapshot number (101, 
current value of Global CN)

 4. Start transaction 3 snapshot

  Transaction level snapshot is created and it get an own snapshot number (101)

 5. Start transaction 4 read commited

  No snapshot is created

6. read committed read consistency transaction start to execute some statement

  Statement level snapshot is created and it get an own snapshot number (101)


Regards,
Vlad


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to