| Index: third_party/sqlite/src/test/tkt3201.test
|
| diff --git a/third_party/sqlite/src/test/tkt3201.test b/third_party/sqlite/src/test/tkt3201.test
|
| index 9bdda1af28b0998b49f9e2dc9fed67c53f607b7a..47c5ebb5fd6fb46ff76bf41b6c6e8a4f1260afed 100644
|
| --- a/third_party/sqlite/src/test/tkt3201.test
|
| +++ b/third_party/sqlite/src/test/tkt3201.test
|
| @@ -72,29 +72,31 @@ do_test tkt3201-7 {
|
|
|
| # Ticket [efc02f977919]
|
| #
|
| -do_test tkt3201-4.0 {
|
| - db eval {
|
| - CREATE TABLE t4(x);
|
| - CREATE TABLE t4_log(x);
|
| - CREATE TRIGGER r4_1 AFTER INSERT ON t4 WHEN new.x=1 BEGIN
|
| - INSERT INTO t4_log(x) VALUES(new.x);
|
| - END;
|
| - CREATE TRIGGER r4_2 AFTER INSERT ON t4 WHEN new.x=2 BEGIN
|
| - INSERT INTO t4_log(x) VALUES(new.x);
|
| - END;
|
| - CREATE TRIGGER r4_3 AFTER INSERT ON t4 WHEN new.x=3 BEGIN
|
| - INSERT INTO t4_log(x) VALUES(new.x);
|
| - END;
|
| - CREATE TRIGGER r4_4 AFTER INSERT ON t4 WHEN new.x=4 BEGIN
|
| - INSERT INTO t4_log(x) VALUES(new.x);
|
| - END;
|
| - INSERT INTO t4 VALUES(1);
|
| - INSERT INTO t4 VALUES(2);
|
| - INSERT INTO t4 VALUES(3);
|
| - INSERT INTO t4 VALUES(4);
|
| - SELECT * FROM t4_log;
|
| - }
|
| -} {1 2 3 4}
|
| +ifcapable trigger {
|
| + do_test tkt3201-4.0 {
|
| + db eval {
|
| + CREATE TABLE t4(x);
|
| + CREATE TABLE t4_log(x);
|
| + CREATE TRIGGER r4_1 AFTER INSERT ON t4 WHEN new.x=1 BEGIN
|
| + INSERT INTO t4_log(x) VALUES(new.x);
|
| + END;
|
| + CREATE TRIGGER r4_2 AFTER INSERT ON t4 WHEN new.x=2 BEGIN
|
| + INSERT INTO t4_log(x) VALUES(new.x);
|
| + END;
|
| + CREATE TRIGGER r4_3 AFTER INSERT ON t4 WHEN new.x=3 BEGIN
|
| + INSERT INTO t4_log(x) VALUES(new.x);
|
| + END;
|
| + CREATE TRIGGER r4_4 AFTER INSERT ON t4 WHEN new.x=4 BEGIN
|
| + INSERT INTO t4_log(x) VALUES(new.x);
|
| + END;
|
| + INSERT INTO t4 VALUES(1);
|
| + INSERT INTO t4 VALUES(2);
|
| + INSERT INTO t4 VALUES(3);
|
| + INSERT INTO t4 VALUES(4);
|
| + SELECT * FROM t4_log;
|
| + }
|
| + } {1 2 3 4}
|
| +}
|
|
|
|
|
|
|
|
|