summaryrefslogtreecommitdiffstats
path: root/test/fts3fault3.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/fts3fault3.test')
-rw-r--r--test/fts3fault3.test54
1 files changed, 54 insertions, 0 deletions
diff --git a/test/fts3fault3.test b/test/fts3fault3.test
new file mode 100644
index 0000000..6e1c0cd
--- /dev/null
+++ b/test/fts3fault3.test
@@ -0,0 +1,54 @@
+# 2023 October 23
+#
+# The author disclaims copyright to this source code. In place of
+# a legal notice, here is a blessing:
+#
+# May you do good and not evil.
+# May you find forgiveness for yourself and forgive others.
+# May you share freely, never taking more than you give.
+#
+#***********************************************************************
+#
+
+set testdir [file dirname $argv0]
+source $testdir/tester.tcl
+
+set ::testprefix fts3fault
+
+# If SQLITE_ENABLE_FTS3 is not defined, omit this file.
+ifcapable !fts3 { finish_test ; return }
+
+set ::TMPDBERROR [list 1 \
+ {unable to open a temporary database file for storing temporary tables}
+]
+
+
+# Test error handling in an "ALTER TABLE ... RENAME TO" statement on an
+# FTS3 table. Specifically, test renaming the table within a transaction
+# after it has been written to.
+#
+do_execsql_test 1.0 {
+ CREATE VIRTUAL TABLE t1 USING fts3(a);
+ INSERT INTO t1 VALUES('test renaming the table');
+ INSERT INTO t1 VALUES(' after it has been written');
+ INSERT INTO t1 VALUES(' actually other stuff instead');
+}
+faultsim_save_and_close
+do_faultsim_test 1 -faults oom* -prep {
+ faultsim_restore_and_reopen
+ execsql {
+ BEGIN;
+ DELETE FROM t1 WHERE rowid=2;
+ }
+} -body {
+ execsql {
+ DELETE FROM t1;
+ }
+} -test {
+ catchsql { COMMIT }
+ faultsim_integrity_check
+ faultsim_test_result {0 {}}
+}
+
+
+finish_test