sqllogictest

Check-in [cd9a67b547]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Adjustment to evidence mark. No code changes.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: cd9a67b54724f458d8619089e0d67037bb815f8a
User & Date: drh 2020-05-15 16:06:24.718
Context
2020-05-18
20:32
Update the built-in SQLite to the latest 3.32.0 beta. check-in: c25acac6f8 user: drh tags: trunk
2020-05-15
16:06
Adjustment to evidence mark. No code changes. check-in: cd9a67b547 user: drh tags: trunk
2020-01-18
16:31
Update the built-in SQLite to 3.31.0 beta. check-in: 3d90c32e55 user: drh tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/evidence/slt_lang_createtrigger.test.
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
# already exists
statement error
CREATE TRIGGER t1r1 UPDATE ON t1 BEGIN SELECT 1; END;

# TBD-EVIDENCE-OF: R-49475-10767 Triggers are database operations that are
# automatically performed when a specified database event occurs.

# EVIDENCE-OF: R-51478-11146 A trigger may be specified to fire whenever
# a DELETE, INSERT, or UPDATE of a particular database table occurs, or
# whenever an UPDATE occurs on on one or more specified columns of a
# table.

statement ok
CREATE TRIGGER t1r2 DELETE ON t1 BEGIN SELECT 1; END;








|







27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
# already exists
statement error
CREATE TRIGGER t1r1 UPDATE ON t1 BEGIN SELECT 1; END;

# TBD-EVIDENCE-OF: R-49475-10767 Triggers are database operations that are
# automatically performed when a specified database event occurs.

# X-EVIDENCE-OF: R-51478-11146 A trigger may be specified to fire whenever
# a DELETE, INSERT, or UPDATE of a particular database table occurs, or
# whenever an UPDATE occurs on on one or more specified columns of a
# table.

statement ok
CREATE TRIGGER t1r2 DELETE ON t1 BEGIN SELECT 1; END;