diff options
Diffstat (limited to 'test/altermalloc3.test')
-rw-r--r-- | test/altermalloc3.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/test/altermalloc3.test b/test/altermalloc3.test index d84f6bbc9..c9011e802 100644 --- a/test/altermalloc3.test +++ b/test/altermalloc3.test @@ -22,6 +22,14 @@ ifcapable !altertable { } do_execsql_test 1.0 { + CREATE TABLE x1( + one, two, three, PRIMARY KEY(one), + CHECK (three!="xyz"), CHECK (two!="one") + ) WITHOUT ROWID; + CREATE INDEX x1i ON x1(one+"two"+"four") WHERE "five"; + CREATE TEMP TRIGGER AFTER INSERT ON x1 BEGIN + UPDATE x1 SET two=new.three || "new" WHERE one=new.one||""; + END; CREATE TABLE t1(a, b, c, d, PRIMARY KEY(d, b)) WITHOUT ROWID; INSERT INTO t1 VALUES(1, 2, 3, 4); } |