Updated: 2025/Nov/16

Please read Privacy Policy. It's for your privacy.

SQLITE3_SNAPSHOT_CMP(3)    Library Functions Manual    SQLITE3_SNAPSHOT_CMP(3)

NAME
     sqlite3_snapshot_cmp - compare the ages of two snapshot handles

SYNOPSIS
     #include <sqlite3.h>

     int
     sqlite3_snapshot_cmp(sqlite3_snapshot *p1, sqlite3_snapshot *p2);

DESCRIPTION
     The sqlite3_snapshot_cmp(P1, P2) interface is used to compare the ages of
     two valid snapshot handles.

     If the two snapshot handles are not associated with the same database
     file, the result of the comparison is undefined.

     Additionally, the result of the comparison is only valid if both of the
     snapshot handles were obtained by calling sqlite3_snapshot_get() since
     the last time the wal file was deleted.  The wal file is deleted when the
     database is changed back to rollback mode or when the number of database
     clients drops to zero.  If either snapshot handle was obtained before the
     wal file was last deleted, the value returned by this function is
     undefined.

     Otherwise, this API returns a negative value if P1 refers to an older
     snapshot than P2, zero if the two handles refer to the same database
     snapshot, and a positive value if P1 is a newer snapshot than P2.

     This interface is only available if SQLite is compiled with the
     SQLITE_ENABLE_SNAPSHOT option.

IMPLEMENTATION NOTES
     These declarations were extracted from the interface documentation at
     line 10581.

     SQLITE_API SQLITE_EXPERIMENTAL int sqlite3_snapshot_cmp(
       sqlite3_snapshot *p1,
       sqlite3_snapshot *p2
     );

NetBSD 11.99                   January 24, 2024                   NetBSD 11.99