Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Adjust two requirement marks due to clarification of wording.|
|Timelines:||family | ancestors | descendants | both | trunk|
|Files:||files | file ages | folders|
|User & Date:||drh 2017-02-08 18:31:55|
|15:15||Update the built-in SQLite to the 3rd 3.18.0 beta. check-in: db74fbad74 user: drh tags: trunk|
|18:31||Adjust two requirement marks due to clarification of wording. check-in: 2f02c1ea3e user: drh tags: trunk|
|18:06||Update the built-in SQLite to the second 3.17.0 beta. check-in: 3a2664ec08 user: drh tags: trunk|
Changes to test/evidence/slt_lang_createtrigger.test.
63 63 # table that the trigger is associated with. 64 64 65 65 # EVIDENCE-OF: R-63660-13730 OLD and NEW references may only be used in 66 66 # triggers on events for which they are relevant, as follows: INSERT NEW 67 67 # references are valid UPDATE NEW and OLD references are valid DELETE 68 68 # OLD references are valid 69 69 70 -# EVIDENCE-OF: R-17846-38304 If a WHEN clause is supplied, the SQL 71 -# statements specified are only executed for rows for which the WHEN 72 -# clause is true. 70 +# EVIDENCE-OF: R-45175-37688 If a WHEN clause is supplied, the SQL 71 +# statements specified are only executed if the WHEN clause is true. 73 72 74 -# EVIDENCE-OF: R-20446-37715 If no WHEN clause is supplied, the SQL 75 -# statements are executed for all rows. 73 +# EVIDENCE-OF: R-12597-09253 If no WHEN clause is supplied, the SQL 74 +# statements are executed every time the trigger fires. 76 75 77 76 # EVIDENCE-OF: R-35362-38850 The BEFORE or AFTER keyword determines when 78 77 # the trigger actions will be executed relative to the insertion, 79 78 # modification or removal of the associated row. 80 79 81 80 statement ok 82 81 CREATE TRIGGER t1r5 AFTER DELETE ON t1 BEGIN SELECT 1; END;