| 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
|
| -
|
|
|