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

Unified Diff: third_party/sqlite/sqlite-src-3100200/test/fts3offsets.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/test/fts3offsets.test
diff --git a/third_party/sqlite/sqlite-src-3100200/test/fts3offsets.test b/third_party/sqlite/sqlite-src-3100200/test/fts3offsets.test
deleted file mode 100644
index 184321ac016f7eec6bd6801ca8d039522fdb6b5a..0000000000000000000000000000000000000000
--- a/third_party/sqlite/sqlite-src-3100200/test/fts3offsets.test
+++ /dev/null
@@ -1,124 +0,0 @@
-# 2010 November 02
-#
-# 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
-
-# If SQLITE_ENABLE_FTS3 is not defined, omit this file.
-ifcapable !fts3 { finish_test ; return }
-
-set testprefix fts3offsets
-set sqlite_fts3_enable_parentheses 1
-
-proc extract {offsets text} {
- set res ""
-
- set off [list]
- foreach {t i s n} $offsets {
- lappend off [list $s $n]
- }
- set off [lsort -integer -index 0 $off]
-
- set iOff 0
- foreach e $off {
- foreach {s n} $e {}
- append res [string range $text $iOff $s-1]
- append res "("
- append res [string range $text $s [expr $s+$n-1]]
- append res ")"
- set iOff [expr $s+$n]
- }
- append res [string range $text $iOff end]
-
- set res
-}
-db func extract extract
-
-
-do_execsql_test 1.1.0 {
- CREATE VIRTUAL TABLE xx USING fts3(x);
- INSERT INTO xx VALUES('A x x x B C x x');
- INSERT INTO xx VALUES('A B C x B x x C');
- INSERT INTO xx VALUES('A x x B C x x x');
-}
-do_execsql_test 1.1.1 {
- SELECT oid,extract(offsets(xx), x) FROM xx WHERE xx MATCH 'a OR (b NEAR/1 c)';
-} {
- 1 {(A) x x x (B) (C) x x}
- 2 {(A) (B) (C) x (B) x x C}
- 3 {(A) x x (B) (C) x x x}
-}
-
-do_execsql_test 1.2 {
- DELETE FROM xx;
- INSERT INTO xx VALUES('A x x x B C x x');
- INSERT INTO xx VALUES('A x x C x x x C');
- INSERT INTO xx VALUES('A x x B C x x x');
-}
-do_execsql_test 1.2.1 {
- SELECT oid,extract(offsets(xx), x) FROM xx WHERE xx MATCH 'a OR (b NEAR/1 c)';
-} {
- 1 {(A) x x x (B) (C) x x}
- 2 {(A) x x C x x x C}
- 3 {(A) x x (B) (C) x x x}
-}
-
-do_execsql_test 1.3 {
- DELETE FROM xx;
- INSERT INTO xx(rowid, x) VALUES(1, 'A B C');
- INSERT INTO xx(rowid, x) VALUES(2, 'A x');
- INSERT INTO xx(rowid, x) VALUES(3, 'A B C');
- INSERT INTO xx(rowid, x) VALUES(4, 'A B C x x x x x x x B');
- INSERT INTO xx(rowid, x) VALUES(5, 'A x x x x x x x x x C');
- INSERT INTO xx(rowid, x) VALUES(6, 'A x x x x x x x x x x x B');
- INSERT INTO xx(rowid, x) VALUES(7, 'A B C');
-}
-do_execsql_test 1.3.1 {
- SELECT oid,extract(offsets(xx), x) FROM xx WHERE xx MATCH 'a OR (b NEAR/1 c)';
-} {
- 1 {(A) (B) (C)}
- 2 {(A) x}
- 3 {(A) (B) (C)}
- 4 {(A) (B) (C) x x x x x x x B}
- 5 {(A) x x x x x x x x x C}
- 6 {(A) x x x x x x x x x x x B}
- 7 {(A) (B) (C)}
-}
-
-
-do_execsql_test 1.4 {
- DELETE FROM xx;
- INSERT INTO xx(rowid, x) VALUES(7, 'A B C');
- INSERT INTO xx(rowid, x) VALUES(6, 'A x');
- INSERT INTO xx(rowid, x) VALUES(5, 'A B C');
- INSERT INTO xx(rowid, x) VALUES(4, 'A B C x x x x x x x B');
- INSERT INTO xx(rowid, x) VALUES(3, 'A x x x x x x x x x C');
- INSERT INTO xx(rowid, x) VALUES(2, 'A x x x x x x x x x x x B');
- INSERT INTO xx(rowid, x) VALUES(1, 'A B C');
-}
-do_execsql_test 1.4.1 {
- SELECT oid,extract(offsets(xx), x) FROM xx WHERE xx MATCH 'a OR (b NEAR/1 c)'
- ORDER BY docid DESC;
-} {
- 7 {(A) (B) (C)}
- 6 {(A) x}
- 5 {(A) (B) (C)}
- 4 {(A) (B) (C) x x x x x x x B}
- 3 {(A) x x x x x x x x x C}
- 2 {(A) x x x x x x x x x x x B}
- 1 {(A) (B) (C)}
-}
-
-
-set sqlite_fts3_enable_parentheses 0
-finish_test
-
« no previous file with comments | « third_party/sqlite/sqlite-src-3100200/test/fts3near.test ('k') | third_party/sqlite/sqlite-src-3100200/test/fts3prefix.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698