| 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
|
|
|