summaryrefslogtreecommitdiff
path: root/test/misc1.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/misc1.test')
-rw-r--r--test/misc1.test31
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