summaryrefslogtreecommitdiff
path: root/test/multiplex4.test
diff options
context:
space:
mode:
authorCy Schubert <cy@FreeBSD.org>2021-05-06 20:08:52 +0000
committerCy Schubert <cy@FreeBSD.org>2021-05-06 20:08:52 +0000
commit8b10604cd15958e62b9d4eb62bcb925272583db1 (patch)
treef18f8ed9fdfeeca2b9c856949a4cae7057ed84a6 /test/multiplex4.test
parenteccd5a4d3926c0716dd11bdf3242da56116f68c6 (diff)
Diffstat (limited to 'test/multiplex4.test')
-rw-r--r--test/multiplex4.test132
1 files changed, 0 insertions, 132 deletions
diff --git a/test/multiplex4.test b/test/multiplex4.test
deleted file mode 100644
index 2caebeadb70f..000000000000
--- a/test/multiplex4.test
+++ /dev/null
@@ -1,132 +0,0 @@
-# 2014-09-25
-#
-# 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.
-#
-#***********************************************************************
-#
-# This file contains tests for the "truncate" option in the multiplexor.
-#
-
-set testdir [file dirname $argv0]
-source $testdir/tester.tcl
-set ::testprefix multiplex4
-
-db close
-sqlite3_shutdown
-sqlite3_multiplex_initialize {} 0
-
-# delete all filesl with the base name of $basename
-#
-proc multiplex_delete_db {basename} {
- foreach file [glob -nocomplain $basename.*] {
- forcedelete $file
- }
-}
-
-# Return a sorted list of all files with the base name of $basename.
-# Except, delete all text from the end of $basename through the NNN
-# suffix on the end of the filename.
-#
-proc multiplex_file_list {basename} {
- set x {}
- foreach file [glob -nocomplain $basename.*] {
- regsub "^$basename\\..*(\\d\\d\\d)\$" $file $basename.\\1 file
- lappend x $file
- }
- return [lsort $x]
-}
-
-do_test multiplex4-1.0 {
- multiplex_delete_db mx4test
- sqlite3 db {file:mx4test.db?chunksize=10&truncate=1} -uri 1 -vfs multiplex
- db eval {
- CREATE TABLE t1(x);
- INSERT INTO t1(x) VALUES(randomblob(250000));
- }
- multiplex_file_list mx4test
-} {mx4test.001 mx4test.db}
-
-do_test multiplex4-1.1 {
- db eval {
- DELETE FROM t1;
- VACUUM;
- }
- multiplex_file_list mx4test
-} {mx4test.db}
-
-# NB: The PRAGMA multiplex_truncate command is implemented using the
-# SQLITE_FCNTL_PRAGMA file-control...
-#
-# EVIDENCE-OF: R-12238-55120 Whenever a PRAGMA statement is parsed, an
-# SQLITE_FCNTL_PRAGMA file control is sent to the open sqlite3_file
-# object corresponding to the database file to which the pragma
-# statement refers.
-#
-do_test multiplex4-1.2 {
- db eval {PRAGMA multiplex_truncate}
-} {on}
-do_test multiplex4-1.3 {
- db eval {PRAGMA multiplex_truncate=off}
-} {off}
-do_test multiplex4-1.4 {
- db eval {PRAGMA multiplex_truncate}
-} {off}
-do_test multiplex4-1.5 {
- db eval {PRAGMA multiplex_truncate=on}
-} {on}
-do_test multiplex4-1.6 {
- db eval {PRAGMA multiplex_truncate}
-} {on}
-do_test multiplex4-1.7 {
- db eval {PRAGMA multiplex_truncate=0}
-} {off}
-do_test multiplex4-1.8 {
- db eval {PRAGMA multiplex_truncate=1}
-} {on}
-do_test multiplex4-1.9 {
- db eval {PRAGMA multiplex_truncate=0}
-} {off}
-
-# EVIDENCE-OF: R-26188-08449 If the SQLITE_FCNTL_PRAGMA file control
-# returns SQLITE_OK, then the parser assumes that the VFS has handled
-# the PRAGMA itself and the parser generates a no-op prepared statement
-# if result string is NULL, or that returns a copy of the result string
-# if the string is non-NULL.
-#
-do_test multiplex4-1.9-explain {
- db eval {EXPLAIN PRAGMA multiplex_truncate=0;}
-} {/String8 \d \d \d off/}
-
-do_test multiplex4-1.10 {
- db eval {
- INSERT INTO t1(x) VALUES(randomblob(250000));
- }
- multiplex_file_list mx4test
-} {mx4test.001 mx4test.db}
-
-do_test multiplex4-1.11 {
- db eval {
- DELETE FROM t1;
- VACUUM;
- }
- multiplex_file_list mx4test
-} {mx4test.001 mx4test.db}
-
-do_test multiplex4-1.12 {
- db eval {
- PRAGMA multiplex_truncate=ON;
- DROP TABLE t1;
- VACUUM;
- }
- multiplex_file_list mx4test
-} {mx4test.db}
-
-catch { db close }
-forcedelete mx4test.db
-sqlite3_multiplex_shutdown
-finish_test