aboutsummaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
authorshaneh <shaneh@noemail.net>2009-12-31 19:48:29 +0000
committershaneh <shaneh@noemail.net>2009-12-31 19:48:29 +0000
commitf33a7a8cefd5aed0c052cbef3b70c8eb85a37e8e (patch)
tree57668cb509ea0dd61554e3bf401b6043d647d7bb /test
parent46aae3c0dab1dfbaaf8ce25f3a57efd69175cd85 (diff)
downloadsqlite-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.test14
-rw-r--r--test/fuzz2.test6
-rw-r--r--test/schema.test4
-rw-r--r--test/tkt-3fe897352e.test7
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