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