diff options
Diffstat (limited to 'test/misc1.test')
-rw-r--r-- | test/misc1.test | 31 |
1 files changed, 30 insertions, 1 deletions
diff --git a/test/misc1.test b/test/misc1.test index 188a283..173b77d 100644 --- a/test/misc1.test +++ b/test/misc1.test @@ -235,7 +235,7 @@ do_test misc1-7.4 { catchsql { INSERT INTO t5 VALUES(1,2,4); } -} {1 {columns a, b are not unique}} +} {1 {UNIQUE constraint failed: t5.a, t5.b}} do_test misc1-7.5 { catchsql { INSERT INTO t5 VALUES(0,2,4); @@ -592,4 +592,33 @@ do_test misc1-18.1 { expr {$n>=100} } {1} +# 2014-01-10: In a CREATE TABLE AS, if one or more of the column names +# are an empty string, that is still OK. +# +do_execsql_test misc1-19.1 { + CREATE TABLE t19 AS SELECT 1, 2 AS '', 3; + SELECT * FROM t19; +} {1 2 3} +do_execsql_test misc1-19.2 { + CREATE TABLE t19b AS SELECT 4 AS '', 5 AS '', 6 AS ''; + SELECT * FROM t19b; +} {4 5 6} + +# 2014-05-16: Tests for the SQLITE_TESTCTRL_FAULT_INSTALL feature. +# +unset -nocomplain fault_callbacks +set fault_callbacks {} +proc fault_callback {n} { + lappend ::fault_callbacks $n + return 0 +} +do_test misc1-19.1 { + sqlite3_test_control_fault_install fault_callback + set fault_callbacks +} {0} +do_test misc1-19.2 { + sqlite3_test_control_fault_install + set fault_callbacks +} {0} + finish_test |