Isolation and actual transaction modes

v4.2.5 supports RC (Read Committed) and SI (Snapshot Isolation). Pessimistic mode defaults to RC, optimistic to SI, subject to runtime configuration. The compatible REPEATABLE-READ string in transaction_isolation/tx_isolation does not independently change actual isolation.

Read versions

RC uses the required statement snapshot; SI retains a transaction snapshot. Transaction ID identifies work, SnapshotTS bounds visibility, and PrepareTS/CommitTS order preparation/commit. They are different values. Reads combine visible objects, Logtail state, deletions and workspace.

Commit and errors

WAL establishes small-write durability; object flush may follow later. Distinguish statement errors, transaction aborts and unknown commit outcomes instead of inferring rollback from every error.

See two-session and cross-CN labs, and visibility/errors.

Source and regression entry points