*** DRAFT ***

SQLite Requirement Matrix Details
changes.html

Index Summary Markup Original


R-15996-49369-09216-34166-12668-33958-11442-01163 tcl slt th3 src

This function returns the number of rows modified, inserted or deleted by the most recently completed INSERT, UPDATE or DELETE statement on the database connection specified by the only parameter.

tcl/e_changes.test:28

/* IMP: R-15996-49369 */
# EVIDENCE-OF: R-15996-49369 This function returns the number of rows
# modified, inserted or deleted by the most recently completed INSERT,
# UPDATE or DELETE statement on the database connection specified by the
# only parameter.

R-44877-05564-55761-20700-41033-29591-21228-47309 tcl slt th3 src

Executing any other type of SQL statement does not modify the value returned by this function.

tcl/e_changes.test:111

/* IMP: R-44877-05564 */
# EVIDENCE-OF: R-44877-05564 Executing any other type of SQL statement
# does not modify the value returned by this function.

R-53938-27527-43335-12056-46528-12200-49434-41509 tcl slt th3 src

Only changes made directly by the INSERT, UPDATE or DELETE statement are considered - auxiliary changes caused by triggers, foreign key actions or REPLACE constraint resolution are not counted.

tcl/e_changes.test:130

/* IMP: R-53938-27527 */
# EVIDENCE-OF: R-53938-27527 Only changes made directly by the INSERT,
# UPDATE or DELETE statement are considered - auxiliary changes caused
# by triggers, foreign key actions or REPLACE constraint resolution are
# not counted.

R-09813-48563-02406-35251-52837-06025-02382-52921 tcl slt th3 src

The value returned by sqlite3_changes() immediately after an INSERT, UPDATE or DELETE statement run on a view is always zero.

tcl/e_changes.test:231

/* IMP: R-09813-48563 */
# EVIDENCE-OF: R-09813-48563 The value returned by sqlite3_changes()
# immediately after an INSERT, UPDATE or DELETE statement run on a view
# is always zero.

R-32918-61474-62391-07743-12159-44767-00770-02393 tcl slt th3 src

Before entering a trigger program the value returned by sqlite3_changes() function is saved. After the trigger program has finished, the original value is restored.

tcl/e_changes.test:266

/* IMP: R-32918-61474 */
# EVIDENCE-OF: R-32918-61474 Before entering a trigger program the value
# returned by sqlite3_changes() function is saved. After the trigger
# program has finished, the original value is restored.

R-17146-37073-08858-03066-53488-24451-10311-22699 tcl slt th3 src

Within a trigger program each INSERT, UPDATE and DELETE statement sets the value returned by sqlite3_changes() upon completion as normal. Of course, this value will not include any changes performed by sub-triggers, as the sqlite3_changes() value will be saved and restored after each sub-trigger has run.

tcl/e_changes.test:326

/* IMP: R-17146-37073 */
# EVIDENCE-OF: R-17146-37073 Within a trigger program each INSERT,
# UPDATE and DELETE statement sets the value returned by
# sqlite3_changes() upon completion as normal. Of course, this value
# will not include any changes performed by sub-triggers, as the
# sqlite3_changes() value will be saved and restored after each
# sub-trigger has run.

R-43399-09409-02985-19756-28234-54022-20282-22241 tcl slt th3 src

This means that if the changes() SQL function (or similar) is used by the first INSERT, UPDATE or DELETE statement within a trigger, it returns the value as set when the calling statement began executing.

tcl/e_changes.test:390

/* IMP: R-43399-09409 */
# EVIDENCE-OF: R-43399-09409 This means that if the changes() SQL
# function (or similar) is used by the first INSERT, UPDATE or DELETE
# statement within a trigger, it returns the value as set when the
# calling statement began executing.

R-53215-27584-18525-51882-25660-37940-21919-06094 tcl slt th3 src

If it is used by the second or subsequent such statement within a trigger program, the value returned reflects the number of rows modified by the previous INSERT, UPDATE or DELETE statement within the same trigger.

tcl/e_changes.test:395

/* IMP: R-53215-27584 */
# EVIDENCE-OF: R-53215-27584 If it is used by the second or subsequent
# such statement within a trigger program, the value returned reflects
# the number of rows modified by the previous INSERT, UPDATE or DELETE
# statement within the same trigger.