Index: third_party/sqlite/src/test/tkt3992.test |
diff --git a/third_party/sqlite/src/test/tkt3992.test b/third_party/sqlite/src/test/tkt3992.test |
index a3fac63ddc0e7da79d144f2f6c2f824ca6f5ff7b..0d8a30f94d7386617765b374e184ae4c586dac22 100644 |
--- a/third_party/sqlite/src/test/tkt3992.test |
+++ b/third_party/sqlite/src/test/tkt3992.test |
@@ -44,34 +44,38 @@ do_test tkt3992-1.3 { |
} |
} {2 1.0} |
-do_test tkt3992-2.1 { |
- execsql { |
- CREATE TABLE t1(a, b); |
- INSERT INTO t1 VALUES(1, 2); |
- ALTER TABLE t1 ADD COLUMN c DEFAULT 3; |
- SELECT * FROM t1; |
- } |
-} {1 2 3} |
-do_test tkt3992-2.2 { |
- execsql { |
- UPDATE t1 SET a = 'one'; |
- SELECT * FROM t1; |
- } |
-} {one 2 3} |
+ifcapable altertable { |
+ do_test tkt3992-2.1 { |
+ execsql { |
+ CREATE TABLE t1(a, b); |
+ INSERT INTO t1 VALUES(1, 2); |
+ ALTER TABLE t1 ADD COLUMN c DEFAULT 3; |
+ SELECT * FROM t1; |
+ } |
+ } {1 2 3} |
+ do_test tkt3992-2.2 { |
+ execsql { |
+ UPDATE t1 SET a = 'one'; |
+ SELECT * FROM t1; |
+ } |
+ } {one 2 3} |
+} |
-db function tcl eval |
-do_test tkt3992-2.3 { |
- execsql { |
- CREATE TABLE t2(a REAL, b REAL, c REAL); |
- INSERT INTO t2 VALUES(1, 2, 3); |
- CREATE TRIGGER tr2 BEFORE UPDATE ON t2 BEGIN |
- SELECT tcl('set res', typeof(new.c)); |
- END; |
- |
- UPDATE t2 SET a = 'I'; |
- } |
- set res |
-} {real} |
+ifcapable trigger { |
+ db function tcl eval |
+ do_test tkt3992-2.3 { |
+ execsql { |
+ CREATE TABLE t2(a REAL, b REAL, c REAL); |
+ INSERT INTO t2 VALUES(1, 2, 3); |
+ CREATE TRIGGER tr2 BEFORE UPDATE ON t2 BEGIN |
+ SELECT tcl('set res', typeof(new.c)); |
+ END; |
+ |
+ UPDATE t2 SET a = 'I'; |
+ } |
+ set res |
+ } {real} |
+} |
finish_test |