Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add an extra test case for the change in commit [c4295725]. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
a48ac4c347813bd2b416b1cb06c3cbf1 |
| User & Date: | dan 2016-02-22 09:45:27 |
Context
|
2016-02-22
| ||
| 13:23 | Change magic numbers associated with synchronous settings to named constants. check-in: 9230ba6c user: drh tags: trunk | |
| 13:01 | Merge up to trunk. check-in: f9e5fb88 user: drh tags: lsm-vtab | |
| 09:45 | Add an extra test case for the change in commit [c4295725]. check-in: a48ac4c3 user: dan tags: trunk | |
|
2016-02-19
| ||
| 19:46 | Further enhancements to the MSVC batch build tool. check-in: 06f1495f user: mistachkin tags: trunk | |
Changes
Changes to test/regexp2.test.
96 97 98 99 100 101 102 103 104 105 |
UPDATE t2 SET b = 'a_abc_1';
} {}
do_execsql_test 2.3 {
SELECT * FROM t2;
SELECT * FROM t3;
SELECT * FROM t4;
} {1 a_abc_1 2 a_abc_1 1 a_abc_1 2 a_abc_1 1 a_abc_1 2 a_abc_1}
finish_test
|
> > > > > > > > > > > > > > > > > > > > |
96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 |
UPDATE t2 SET b = 'a_abc_1';
} {}
do_execsql_test 2.3 {
SELECT * FROM t2;
SELECT * FROM t3;
SELECT * FROM t4;
} {1 a_abc_1 2 a_abc_1 1 a_abc_1 2 a_abc_1 1 a_abc_1 2 a_abc_1}
#-------------------------------------------------------------------------
# Test that trigger parameters (i.e. new.* and old.*) refs are not
# considered to be constant across separate invocations of the trigger.
#
do_execsql_test 3.0 {
CREATE TABLE t5(a);
CREATE TABLE t6(x);
CREATE TRIGGER t5tr AFTER DELETE ON t5 BEGIN
DELETE FROM t6 WHERE t6.x REGEXP old.a;
END;
INSERT INTO t5 VALUES ('^a.*'), ('^b.*'), ('^c.*');
INSERT INTO t6 VALUES ('eab'), ('abc'), ('bcd'), ('cde'), ('dea');
DELETE FROM t5;
SELECT * FROM t6;
} {eab dea}
finish_test
|