sqllogictest

Check-in [2f02c1ea3e]
Login

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.242
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
Unified Diff Ignore Whitespace Patch
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;
︙︙