*** DRAFT ***

SQLite Requirement Matrix Details
wal_autocheckpoint.html

Index Summary Markup Original


R-38128-34102-03228-01716-42650-19152-18652-04810 tcl slt th3 src

The sqlite3_wal_autocheckpoint(D,N) is a wrapper around sqlite3_wal_hook() that causes any database on database connection D to automatically checkpoint after committing a transaction if there are N or more frames in the write-ahead log file.

tcl/e_walauto.test:95

/* IMP: R-38128-34102 */
# EVIDENCE-OF: R-38128-34102 The sqlite3_wal_autocheckpoint(D,N) is a
# wrapper around sqlite3_wal_hook() that causes any database on database
# connection D to automatically checkpoint after committing a
# transaction if there are N or more frames in the write-ahead log file.

R-26993-43540-10992-37102-45404-55683-60247-30594 tcl slt th3 src

Passing zero or a negative value as the nFrame parameter disables automatic checkpoints entirely.

tcl/e_walauto.test:112

/* IMP: R-26993-43540 */
# EVIDENCE-OF: R-26993-43540 Passing zero or a negative value as the
# nFrame parameter disables automatic checkpoints entirely.

R-10203-42688-05745-20246-57567-01031-33670-42087 tcl slt th3 src

The callback registered by this function replaces any existing callback registered using sqlite3_wal_hook().

tcl/e_walauto.test:134

/* IMP: R-10203-42688 */
# EVIDENCE-OF: R-10203-42688 The callback registered by this function
# replaces any existing callback registered using sqlite3_wal_hook().

R-17497-43474-02755-40707-55508-06941-43855-44277 tcl slt th3 src

Likewise, registering a callback using sqlite3_wal_hook() disables the automatic checkpoint mechanism configured by this function.

tcl/e_walauto.test:152

/* IMP: R-17497-43474 */
# EVIDENCE-OF: R-17497-43474 Likewise, registering a callback using
# sqlite3_wal_hook() disables the automatic checkpoint mechanism
# configured by this function.

R-30135-06439-12622-19657-03902-02051-33050-20191 tcl slt th3 src

The wal_autocheckpoint pragma can be used to invoke this interface from SQL.

tcl/e_walauto.test:57

/* IMP: R-30135-06439 */
# EVIDENCE-OF: R-30135-06439 The wal_autocheckpoint pragma can be used
# to invoke this interface from SQL.

R-33080-59193-42664-27310-42541-31106-33090-39782 tcl slt th3 src

Checkpoints initiated by this mechanism are PASSIVE.

tcl/e_walauto.test:174

/* IMP: R-33080-59193 */
# EVIDENCE-OF: R-33080-59193 Checkpoints initiated by this mechanism are
# PASSIVE.

R-41531-51083-45051-37425-19674-01432-09098-10672 tcl slt th3 src

Every new database connection defaults to having the auto-checkpoint enabled with a threshold of 1000 or SQLITE_DEFAULT_WAL_AUTOCHECKPOINT pages.

tcl/e_walauto.test:87

/* IMP: R-41531-51083 */
# EVIDENCE-OF: R-41531-51083 Every new database connection defaults to
# having the auto-checkpoint enabled with a threshold of 1000 or
# SQLITE_DEFAULT_WAL_AUTOCHECKPOINT pages.