Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(162)

Unified Diff: third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5restart.test

Issue 2846743003: [sql] Remove SQLite 3.10.2 reference directory. (Closed)
Patch Set: Created 3 years, 8 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
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
-

Powered by Google App Engine
This is Rietveld 408576698