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: |
cd9a67b54724f458d8619089e0d67037 |
| User & Date: | drh 2020-05-15 16:06:24 |
Context
|
2020-05-18
| ||
| 20:32 | Update the built-in SQLite to the latest 3.32.0 beta. Leaf 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
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;
|