Index: third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5restart.test |
diff --git a/third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5restart.test b/third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5restart.test |
deleted file mode 100644 |
index 0dd7d694540bdbea311a8aa493afbb193b4c2dbc..0000000000000000000000000000000000000000 |
--- a/third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5restart.test |
+++ /dev/null |
@@ -1,152 +0,0 @@ |
-# 2015 April 28 |
-# |
-# 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 focuses on testing the planner (xBestIndex function). |
-# |
- |
-source [file join [file dirname [info script]] fts5_common.tcl] |
-set testprefix fts5restart |
- |
-# If SQLITE_ENABLE_FTS5 is defined, omit this file. |
-ifcapable !fts5 { |
- finish_test |
- return |
-} |
- |
-do_execsql_test 1.0 { |
- CREATE VIRTUAL TABLE f1 USING fts5(ff); |
-} |
- |
-#------------------------------------------------------------------------- |
-# Run the 'optimize' command. Check that it does not disturb ongoing |
-# full-text queries. |
-# |
-do_test 1.1 { |
- for {set i 1} {$i < 1000} {incr i} { |
- execsql { INSERT INTO f1 VALUES('a b c d e') } |
- lappend lRowid $i |
- } |
-} {} |
- |
-do_execsql_test 1.2 { |
- SELECT rowid FROM f1 WHERE f1 MATCH 'c'; |
-} $lRowid |
- |
-do_test 1.3 { |
- set res [list] |
- db eval { SELECT rowid FROM f1 WHERE f1 MATCH 'c' } { |
- if {$rowid == 100} { |
- execsql { INSERT INTO f1(f1) VALUES('optimize') } |
- } |
- lappend res $rowid |
- } |
- set res |
-} $lRowid |
- |
-do_test 1.4.1 { |
- sqlite3 db2 test.db |
- set res [list] |
- db2 eval { SELECT rowid FROM f1 WHERE f1 MATCH 'c' } { |
- if {$rowid == 100} { |
- set cres [catchsql { INSERT INTO f1(f1) VALUES('optimize') }] |
- } |
- lappend res $rowid |
- } |
- set res |
-} $lRowid |
- |
-do_test 1.4.2 { |
- db2 close |
- set cres |
-} {1 {database is locked}} |
- |
-#------------------------------------------------------------------------- |
-# Open a couple of cursors. Then close them in the same order. |
-# |
-do_test 2.1 { |
- set ::s1 [sqlite3_prepare db "SELECT rowid FROM f1 WHERE f1 MATCH 'b'" -1 X] |
- set ::s2 [sqlite3_prepare db "SELECT rowid FROM f1 WHERE f1 MATCH 'c'" -1 X] |
- |
- sqlite3_step $::s1 |
-} {SQLITE_ROW} |
-do_test 2.2 { |
- sqlite3_step $::s2 |
-} {SQLITE_ROW} |
- |
-do_test 2.1 { |
- sqlite3_finalize $::s1 |
- sqlite3_finalize $::s2 |
-} {SQLITE_OK} |
- |
-#------------------------------------------------------------------------- |
-# Copy data between two FTS5 tables. |
-# |
-do_execsql_test 3.1 { |
- CREATE VIRTUAL TABLE f2 USING fts5(gg); |
- INSERT INTO f2 SELECT ff FROM f1 WHERE f1 MATCH 'b+c+d'; |
-} |
-do_execsql_test 3.2 { |
- SELECT rowid FROM f2 WHERE f2 MATCH 'a+b+c+d+e' |
-} $lRowid |
- |
-#------------------------------------------------------------------------- |
-# Remove the row that an FTS5 cursor is currently pointing to. And |
-# various other similar things. Check that this does not disturb |
-# ongoing scans. |
-# |
-do_execsql_test 4.0 { |
- CREATE VIRTUAL TABLE n4 USING fts5(n); |
- INSERT INTO n4(rowid, n) VALUES(100, '1 2 3 4 5'); |
- INSERT INTO n4(rowid, n) VALUES(200, '1 2 3 4'); |
- INSERT INTO n4(rowid, n) VALUES(300, '2 3 4'); |
- INSERT INTO n4(rowid, n) VALUES(400, '2 3'); |
- INSERT INTO n4(rowid, n) VALUES(500, '3'); |
-} |
- |
-do_test 4.1 { |
- set res [list] |
- db eval { SELECT rowid FROM n4 WHERE n4 MATCH '3' } { |
- if {$rowid==300} { |
- execsql { DELETE FROM n4 WHERE rowid=300 } |
- } |
- lappend res $rowid |
- } |
- set res |
-} {100 200 300 400 500} |
- |
-do_test 4.2 { |
- execsql { INSERT INTO n4(rowid, n) VALUES(300, '2 3 4') } |
- set res [list] |
- db eval { SELECT rowid FROM n4 WHERE n4 MATCH '3' ORDER BY rowid DESC} { |
- if {$rowid==300} { |
- execsql { DELETE FROM n4 WHERE rowid=300 } |
- } |
- lappend res $rowid |
- } |
- set res |
-} {500 400 300 200 100} |
- |
-do_test 4.3 { |
- execsql { INSERT INTO n4(rowid, n) VALUES(300, '2 3 4') } |
- set res [list] |
- db eval { SELECT rowid FROM n4 WHERE n4 MATCH '3' ORDER BY rowid DESC} { |
- if {$rowid==300} { |
- execsql { DELETE FROM n4 } |
- } |
- lappend res $rowid |
- } |
- set res |
-} {500 400 300} |
- |
- |
- |
-finish_test |
- |