Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
snapshot_open.html

Index Summary Markup Original


R-17784-08205-07510-46755-33017-49924-02897-50961 tcl slt th3 src

The sqlite3_snapshot_open(D,S,P) interface either starts a new read transaction or upgrades an existing one for schema S of database connection D such that the read transaction refers to historical snapshot P, rather than the most recent change to the database.

/* IMP: R-17784-08205 */
# EVIDENCE-OF: R-17784-08205 The sqlite3_snapshot_open(D,S,P) interface
# either starts a new read transaction or upgrades an existing one for
# schema S of database connection D such that the read transaction
# refers to historical snapshot P, rather than the most recent change to
# the database.

R-06640-03838-35138-60782-53418-54966-60899-05980 tcl slt th3 src

The sqlite3_snapshot_open() interface returns SQLITE_OK on success or an appropriate error code if it fails.

/* IMP: R-06640-03838 */
# EVIDENCE-OF: R-06640-03838 The sqlite3_snapshot_open() interface
# returns SQLITE_OK on success or an appropriate error code if it fails.

R-20111-12873-06694-53393-06638-09093-12890-49161 tcl slt th3 src

In order to succeed, the database connection must not be in autocommit mode when sqlite3_snapshot_open(D,S,P) is called.

/* IMP: R-20111-12873 */
# EVIDENCE-OF: R-20111-12873 In order to succeed, the database
# connection must not be in autocommit mode when
# sqlite3_snapshot_open(D,S,P) is called.

R-45387-42504-16923-07908-20467-28557-08879-46075 tcl slt th3 src

A call to sqlite3_snapshot_open() will fail to open if the specified snapshot has been overwritten by a checkpoint.

/* IMP: R-45387-42504 */
# EVIDENCE-OF: R-45387-42504 A call to sqlite3_snapshot_open() will fail
# to open if the specified snapshot has been overwritten by a
# checkpoint.

R-40460-39888-52540-38305-24333-10191-58577-29064 tcl slt th3 src

A call to sqlite3_snapshot_open(D,S,P) will fail if the database connection D does not know that the database file for schema S is in WAL mode. A database connection might not know that the database file is in WAL mode if there has been no prior I/O on that database connection, or if the database entered WAL mode after the most recent I/O on the database connection.

/* IMP: R-40460-39888 */
# EVIDENCE-OF: R-40460-39888 A call to sqlite3_snapshot_open(D,S,P) will
# fail if the database connection D does not know that the database file
# for schema S is in WAL mode. A database connection might not know that
# the database file is in WAL mode if there has been no prior I/O on
# that database connection, or if the database entered WAL mode after
# the most recent I/O on the database connection.