Index: third_party/sqlite/sqlite-src-3080704/test/fts3fault.test |
diff --git a/third_party/sqlite/sqlite-src-3080704/test/fts3fault.test b/third_party/sqlite/sqlite-src-3080704/test/fts3fault.test |
deleted file mode 100644 |
index ab82daa935622f3038416e8accbdda56cb6b8aef..0000000000000000000000000000000000000000 |
--- a/third_party/sqlite/sqlite-src-3080704/test/fts3fault.test |
+++ /dev/null |
@@ -1,231 +0,0 @@ |
-# 2010 June 15 |
-# |
-# 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 } |
- |
-# Test error handling in the sqlite3Fts3Init() function. This is the |
-# function that registers the FTS3 module and various support functions |
-# with SQLite. |
-# |
-do_faultsim_test 1 -body { |
- sqlite3 db test.db |
- expr 0 |
-} -test { |
- catch { db close } |
-} |
- |
-# 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. |
-# |
-faultsim_delete_and_reopen |
-do_execsql_test 2.0 { |
- CREATE VIRTUAL TABLE t1 USING fts3; |
- INSERT INTO t1 VALUES('test renaming the table'); |
- INSERT INTO t1 VALUES(' after it has been written'); |
-} |
-do_faultsim_test 2 -prep { |
- sqlite3 db test.db |
- execsql { |
- BEGIN; |
- INSERT INTO t1 VALUES('registers the FTS3 module'); |
- INSERT INTO t1 VALUES('various support functions'); |
- } |
-} -body { |
- execsql { ALTER TABLE t1 RENAME TO t2 } |
-} -test { |
- faultsim_test_result {0 {}} |
-} |
- |
-# Test error handling in the special case where a single prefix query |
-# matches terms that reside on a large range of leaf nodes. |
-# |
-do_test fts3fault-3.0 { |
- sqlite3 db test.db |
- execsql { CREATE VIRTUAL TABLE t3 USING fts4; } |
- execsql { INSERT INTO t3(t3) VALUES('nodesize=50') } |
- execsql { BEGIN } |
- for {set i 0} {$i < 1000} {incr i} { |
- execsql { INSERT INTO t3 VALUES('aaa' || $i) } |
- } |
- execsql { COMMIT } |
-} {} |
- |
-do_faultsim_test 3 -faults oom-transient -prep { |
- sqlite3 db test.db |
- execsql { SELECT * FROM t3 WHERE t3 MATCH 'x' } |
-} -body { |
- execsql { SELECT count(rowid) FROM t3 WHERE t3 MATCH 'aa*' } |
-} -test { |
- faultsim_test_result {0 1000} |
-} |
- |
-do_test fts3fault-4.0 { |
- faultsim_delete_and_reopen |
- execsql { |
- CREATE VIRTUAL TABLE t4 USING fts4; |
- INSERT INTO t4 VALUES('The British Government called on'); |
- INSERT INTO t4 VALUES('as pesetas then became much'); |
- } |
-} {} |
-faultsim_save_and_close |
-do_faultsim_test 4 -prep { |
- faultsim_restore_and_reopen |
- execsql { SELECT content FROM t4 } |
-} -body { |
- execsql { SELECT optimize(t4) FROM t4 LIMIT 1 } |
-} -test { |
- faultsim_test_result {0 {{Index optimized}}} |
-} |
- |
-do_test fts3fault-5.0 { |
- faultsim_delete_and_reopen |
- execsql { |
- CREATE VIRTUAL TABLE t5 USING fts4; |
- INSERT INTO t5 VALUES('The British Government called on'); |
- INSERT INTO t5 VALUES('as pesetas then became much'); |
- } |
-} {} |
-faultsim_save_and_close |
-do_faultsim_test 5 -prep { |
- faultsim_restore_and_reopen |
- execsql { |
- BEGIN; |
- INSERT INTO t5 VALUES('influential in shaping his future outlook'); |
- INSERT INTO t5 VALUES('might be acceptable to the British electorate'); |
- } |
-} -body { |
- execsql { SELECT rowid FROM t5 WHERE t5 MATCH 'british' } |
-} -test { |
- faultsim_test_result {0 {1 4}} |
-} |
- |
-do_test fts3fault-6.0 { |
- faultsim_delete_and_reopen |
- execsql { CREATE VIRTUAL TABLE t6 USING fts4 } |
-} {} |
-faultsim_save_and_close |
-do_faultsim_test 6 -prep { |
- faultsim_restore_and_reopen |
- execsql { SELECT rowid FROM t6 } |
-} -body { |
- execsql { DROP TABLE t6 } |
-} -test { |
- faultsim_test_result {0 {}} |
-} |
- |
-# Test various malloc failures while processing FTS4 parameters. |
-# |
-do_faultsim_test 7.1 -prep { |
- faultsim_delete_and_reopen |
-} -body { |
- execsql { CREATE VIRTUAL TABLE t1 USING fts4(a, b, matchinfo=fts3) } |
-} -test { |
- faultsim_test_result {0 {}} |
-} |
-do_faultsim_test 7.2 -prep { |
- faultsim_delete_and_reopen |
-} -body { |
- execsql { CREATE VIRTUAL TABLE t1 USING fts4(a, b, matchinfo=fs3) } |
-} -test { |
- faultsim_test_result {1 {unrecognized matchinfo: fs3}} \ |
- {1 {vtable constructor failed: t1}} \ |
- {1 {SQL logic error or missing database}} |
-} |
-do_faultsim_test 7.3 -prep { |
- faultsim_delete_and_reopen |
-} -body { |
- execsql { CREATE VIRTUAL TABLE t1 USING fts4(a, b, matchnfo=fts3) } |
-} -test { |
- faultsim_test_result {1 {unrecognized parameter: matchnfo=fts3}} \ |
- {1 {vtable constructor failed: t1}} \ |
- {1 {SQL logic error or missing database}} |
-} |
- |
-proc mit {blob} { |
- set scan(littleEndian) i* |
- set scan(bigEndian) I* |
- binary scan $blob $scan($::tcl_platform(byteOrder)) r |
- return $r |
-} |
- |
-do_test 8.0 { |
- faultsim_delete_and_reopen |
- execsql { CREATE VIRTUAL TABLE t8 USING fts4 } |
- execsql "INSERT INTO t8 VALUES('a b c')" |
- execsql "INSERT INTO t8 VALUES('b b b')" |
- execsql "INSERT INTO t8 VALUES('[string repeat {c } 50000]')" |
- execsql "INSERT INTO t8 VALUES('d d d')" |
- execsql "INSERT INTO t8 VALUES('e e e')" |
- execsql "INSERT INTO t8(t8) VALUES('optimize')" |
- faultsim_save_and_close |
-} {} |
- |
-do_faultsim_test 8.1 -prep { |
- faultsim_restore_and_reopen |
- db func mit mit |
-} -body { |
- execsql { SELECT mit(matchinfo(t8, 'x')) FROM t8 WHERE t8 MATCH 'a b c' } |
-} -test { |
- faultsim_test_result {0 {{1 1 1 1 4 2 1 5 5}}} |
-} |
-do_faultsim_test 8.2 -faults oom-t* -prep { |
- faultsim_restore_and_reopen |
- db func mit mit |
-} -body { |
- execsql { SELECT mit(matchinfo(t8, 's')) FROM t8 WHERE t8 MATCH 'a b c' } |
-} -test { |
- faultsim_test_result {0 3} |
-} |
-do_faultsim_test 8.3 -prep { |
- faultsim_restore_and_reopen |
- db func mit mit |
-} -body { |
- execsql { SELECT mit(matchinfo(t8, 'a')) FROM t8 WHERE t8 MATCH 'a b c' } |
-} -test { |
- faultsim_test_result {0 10002} |
-} |
-do_faultsim_test 8.4 -prep { |
- faultsim_restore_and_reopen |
- db func mit mit |
-} -body { |
- execsql { SELECT mit(matchinfo(t8, 'l')) FROM t8 WHERE t8 MATCH 'a b c' } |
-} -test { |
- faultsim_test_result {0 3} |
-} |
- |
-do_test 9.0 { |
- faultsim_delete_and_reopen |
- execsql { |
- CREATE VIRTUAL TABLE t9 USING fts4(tokenize=porter); |
- INSERT INTO t9 VALUES( |
- 'this record is used toooooooooooooooooooooooooooooooooooooo try to' |
- ); |
- SELECT offsets(t9) FROM t9 WHERE t9 MATCH 'to*'; |
- } |
- faultsim_save_and_close |
-} {} |
-do_faultsim_test 9.1 -prep { |
- faultsim_restore_and_reopen |
-} -body { |
- execsql { SELECT offsets(t9) FROM t9 WHERE t9 MATCH 'to*' } |
-} -test { |
- faultsim_test_result {0 {{0 0 20 39 0 0 64 2}}} |
-} |
- |
-finish_test |