diff options
author | shaneh <shaneh@noemail.net> | 2009-12-31 19:48:29 +0000 |
---|---|---|
committer | shaneh <shaneh@noemail.net> | 2009-12-31 19:48:29 +0000 |
commit | f33a7a8cefd5aed0c052cbef3b70c8eb85a37e8e (patch) | |
tree | 57668cb509ea0dd61554e3bf401b6043d647d7bb /test | |
parent | 46aae3c0dab1dfbaaf8ce25f3a57efd69175cd85 (diff) | |
download | sqlite-f33a7a8cefd5aed0c052cbef3b70c8eb85a37e8e.tar.gz sqlite-f33a7a8cefd5aed0c052cbef3b70c8eb85a37e8e.zip |
Minor changes to test scripts to support various SQLITE_OMIT options.
FossilOrigin-Name: 97f8a886b6314b044a0522a88f569798fdfb3ef9
Diffstat (limited to 'test')
-rw-r--r-- | test/check.test | 14 | ||||
-rw-r--r-- | test/fuzz2.test | 6 | ||||
-rw-r--r-- | test/schema.test | 4 | ||||
-rw-r--r-- | test/tkt-3fe897352e.test | 7 |
4 files changed, 24 insertions, 7 deletions
diff --git a/test/check.test b/test/check.test index 51ab1f31b..d2867a096 100644 --- a/test/check.test +++ b/test/check.test @@ -239,43 +239,43 @@ do_test check-4.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 } diff --git a/test/fuzz2.test b/test/fuzz2.test index eb5eb83a3..989b00f05 100644 --- a/test/fuzz2.test +++ b/test/fuzz2.test @@ -65,6 +65,9 @@ do_test fuzz2-2.11 { 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} @@ -74,6 +77,9 @@ do_test fuzz2-3.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} diff --git a/test/schema.test b/test/schema.test index eeb210283..5e9f17573 100644 --- a/test/schema.test +++ b/test/schema.test @@ -364,6 +364,8 @@ do_test schema-12.1 { 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 @@ -384,4 +386,6 @@ do_test schema-13.3 { sqlite3_finalize $S } {SQLITE_SCHEMA} +} + finish_test diff --git a/test/tkt-3fe897352e.test b/test/tkt-3fe897352e.test index eb4f17813..deafe48e0 100644 --- a/test/tkt-3fe897352e.test +++ b/test/tkt-3fe897352e.test @@ -16,6 +16,13 @@ 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 |