Index: test/check.test ================================================================== --- test/check.test +++ test/check.test @@ -237,47 +237,47 @@ execsql { UPDATE t4 SET x=4, y=3; SELECT * FROM t4 } } {4 3} -do_test check-4.3 { +do_test check-4.4 { execsql { UPDATE t4 SET x=12, y=2; SELECT * FROM t4 } } {12 2} -do_test check-4.4 { +do_test check-4.5 { execsql { UPDATE t4 SET x=12, y=-22; SELECT * FROM t4 } } {12 -22} -do_test check-4.5 { +do_test check-4.6 { catchsql { UPDATE t4 SET x=0, y=1; } } {1 {constraint failed}} -do_test check-4.6 { +do_test check-4.7 { execsql { SELECT * FROM t4; } } {12 -22} -do_test check-4.7 { +do_test check-4.8 { execsql { PRAGMA ignore_check_constraints=ON; UPDATE t4 SET x=0, y=1; SELECT * FROM t4; } } {0 1} -do_test check-4.8 { +do_test check-4.9 { catchsql { PRAGMA ignore_check_constraints=OFF; UPDATE t4 SET x=0, y=2; } } {1 {constraint failed}} ifcapable vacuum { - do_test check_4.9 { + do_test check_4.10 { catchsql { VACUUM } } {0 {}} } Index: test/fuzz2.test ================================================================== --- test/fuzz2.test +++ test/fuzz2.test @@ -63,19 +63,25 @@ fuzzcatch {UPDATE OR IGNORE "AAAAAA" . "AAAAAA" SET "AAAAAA" = NOT #96} } {1} do_test fuzz2-2.12 { fuzzcatch {SELECT - #196} } {1} + +ifcapable {trigger} { # Only do the following tests if triggers are enabled + do_test fuzz2-3.0 { fuzzcatch {CREATE TRIGGER "AAAAAA" . "AAAAAA" AFTER UPDATE OF "AAAAAA" , "AAAAAA" ON "AAAAAA" . "AAAAAA" FOR EACH ROW BEGIN UPDATE AAAAAA SET "AAAAAA" = #162; END} } {1} do_test fuzz2-3.1 { fuzzcatch {CREATE TRIGGER IF NOT EXISTS "AAAAAA" UPDATE ON "AAAAAA" . AAAAAA FOR EACH ROW BEGIN DELETE FROM "AAAAAA" ; INSERT INTO AAAAAA ( "AAAAAA" ) SELECT DISTINCT "AAAAAA" "AAAAAA" , #167 AAAAAA , "AAAAAA" . * ORDER BY "AAAAAA" ASC , x'414141414141' BETWEEN RAISE ( FAIL , "AAAAAA" ) AND AAAAAA ( * ) NOT NULL DESC LIMIT AAAAAA ; REPLACE INTO AAAAAA ( AAAAAA ) VALUES ( AAAAAA ( * ) ) ; END} } {1} do_test fuzz2-3.2 { fuzzcatch {CREATE TEMP TRIGGER IF NOT EXISTS AAAAAA . "AAAAAA" BEFORE UPDATE OF "AAAAAA" ON AAAAAA . "AAAAAA" BEGIN SELECT ALL * , #175 "AAAAAA" FROM "AAAAAA" . AAAAAA; END} } {1} + +} ;# End of ifcapable {trigger} + do_test fuzz2-4.0 { fuzzcatch {ATTACH DATABASE #168 AS whatever} } {1} do_test fuzz2-4.1 { fuzzcatch {DETACH #133} Index: test/schema.test ================================================================== --- test/schema.test +++ test/schema.test @@ -361,10 +361,12 @@ # $::STMT was prepared. So unless it has been expired, it would be # possible to run the "CREATE TABLE t4" statement and create a # duplicate table. list [sqlite3_step $::STMT] [sqlite3_finalize $::STMT] } {SQLITE_ERROR SQLITE_SCHEMA} + +ifcapable {auth} { do_test schema-13.1 { set S [sqlite3_prepare_v2 db "SELECT * FROM sqlite_master" -1 dummy] db function hello hello db function hello {} @@ -381,7 +383,9 @@ } {SQLITE_SCHEMA} do_test schema-13.3 { sqlite3_finalize $S } {SQLITE_SCHEMA} + +} finish_test Index: test/tkt-3fe897352e.test ================================================================== --- test/tkt-3fe897352e.test +++ test/tkt-3fe897352e.test @@ -14,10 +14,17 @@ # fixed. # set testdir [file dirname $argv0] source $testdir/tester.tcl + +# The following tests use hex_to_utf16be() and hex_to_utf16le() which +# which are only available if SQLite is built with UTF16 support. +ifcapable {!utf16} { + finish_test + return +} do_test tkt-3fe89-1.1 { db close sqlite3 db :memory: db eval {