Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
total_changes.html

Index Summary Markup Original


R-23547-15805-63625-56801-52157-01700-25402-34533 tcl slt th3 src

These functions return the total number of rows inserted, modified or deleted by all INSERT, UPDATE or DELETE statements completed since the database connection was opened, including those executed as part of trigger programs.

/* IMP: R-23547-15805 */
# EVIDENCE-OF: R-23547-15805 These functions return the total number of
# rows inserted, modified or deleted by all INSERT, UPDATE or DELETE
# statements completed since the database connection was opened,
# including those executed as part of trigger programs.

R-61766-15253-61535-09888-08438-64512-26902-02870 tcl slt th3 src

Executing any other type of SQL statement does not affect the value returned by sqlite3_total_changes().

tcl/e_totalchanges.test:95

/* IMP: R-61766-15253 */
# EVIDENCE-OF: R-61766-15253 Executing any other type of SQL statement
# does not affect the value returned by sqlite3_total_changes().

R-36043-10590-35190-29655-36320-51519-10161-16668 tcl slt th3 src

Changes made as part of foreign key actions are included in the count, but those made as part of REPLACE constraint resolution are not.

tcl/e_totalchanges.test:120

/* IMP: R-36043-10590 */
# EVIDENCE-OF: R-36043-10590 Changes made as part of foreign key actions
# are included in the count, but those made as part of REPLACE
# constraint resolution are not.

R-54872-08741-62719-64632-51902-03049-34462-47837 tcl slt th3 src

Changes to a view that are intercepted by INSTEAD OF triggers are not counted.

tcl/e_totalchanges.test:190

/* IMP: R-54872-08741 */
# EVIDENCE-OF: R-54872-08741 Changes to a view that are intercepted by
# INSTEAD OF triggers are not counted.