sqllogictest
Check-in [2f02c1ea3e]
Not logged in

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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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;