On 20 Apr 2005 at 4:16, Allen wrote:

>Can anyone please tell me when the firebird will keep the record
>version?

When there is a transaction that want (may) see this version or any
previous version of the record.

>if in one program(only one user), one query have select from a table
>A, and other query update the table A and commit, then firebird will
>keep the record version?

It depends on transaction isolation levels. Any RR transaction
block garbage collection for later record versions.

> Or in what occasion it will keep the record
>version? Will it ever release the record version?

Yes. When all interested transaction are finished, record version
become a garbage.
--
SY, Dimitry Sibiryakov.