Index: third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5rowid.test |
diff --git a/third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5rowid.test b/third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5rowid.test |
deleted file mode 100644 |
index 621934c0f2cf08aac38e5ce852ca1d0a0556c415..0000000000000000000000000000000000000000 |
--- a/third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5rowid.test |
+++ /dev/null |
@@ -1,188 +0,0 @@ |
-# 2014 Dec 20 |
-# |
-# 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. |
-# |
-#*********************************************************************** |
-# |
-# Tests of the scalar fts5_rowid() and fts5_decode() functions. |
-# |
- |
-source [file join [file dirname [info script]] fts5_common.tcl] |
-set testprefix fts5rowid |
- |
-# If SQLITE_ENABLE_FTS5 is defined, omit this file. |
-ifcapable !fts5 { |
- finish_test |
- return |
-} |
- |
-do_catchsql_test 1.1 { |
- SELECT fts5_rowid() |
-} {1 {should be: fts5_rowid(subject, ....)}} |
- |
-do_catchsql_test 1.2 { |
- SELECT fts5_rowid('segment') |
-} {1 {should be: fts5_rowid('segment', segid, pgno))}} |
- |
-do_execsql_test 1.3 { |
- SELECT fts5_rowid('segment', 1, 1) |
-} {137438953473} |
- |
-do_catchsql_test 1.4 { |
- SELECT fts5_rowid('nosucharg'); |
-} {1 {first arg to fts5_rowid() must be 'segment'}} |
- |
- |
-#------------------------------------------------------------------------- |
-# Tests of the fts5_decode() function. |
-# |
-reset_db |
-do_execsql_test 2.1 { |
- CREATE VIRTUAL TABLE x1 USING fts5(a, b); |
- INSERT INTO x1(x1, rank) VALUES('pgsz', 32); |
-} {} |
- |
-proc rnddoc {n} { |
- set map [list 0 a 1 b 2 c 3 d 4 e 5 f 6 g 7 h 8 i 9 j] |
- set doc [list] |
- for {set i 0} {$i < $n} {incr i} { |
- lappend doc [string map $map [format %.3d [expr int(rand()*100)]]] |
- } |
- set doc |
-} |
-db func rnddoc rnddoc |
- |
-do_execsql_test 2.2 { |
- WITH r(a, b) AS ( |
- SELECT rnddoc(6), rnddoc(6) UNION ALL |
- SELECT rnddoc(6), rnddoc(6) FROM r |
- ) |
- INSERT INTO x1 SELECT * FROM r LIMIT 10000; |
-} |
- |
-set res [db one {SELECT count(*) FROM x1_data}] |
-do_execsql_test 2.3 { |
- SELECT count(fts5_decode(rowid, block)) FROM x1_data; |
-} $res |
-do_execsql_test 2.4 { |
- UPDATE x1_data SET block = X''; |
- -- SELECT count(fts5_decode(rowid, block)) FROM x1_data; |
- SELECT count(*) FROM x1_data; |
-} $res |
- |
-do_execsql_test 2.5 { |
- INSERT INTO x1(x1, rank) VALUES('pgsz', 1024); |
- INSERT INTO x1(x1) VALUES('rebuild'); |
-} |
- |
-set res [db one {SELECT count(*) FROM x1_data}] |
-do_execsql_test 2.6 { |
- SELECT count(fts5_decode(rowid, block)) FROM x1_data; |
-} $res |
- |
-# This is really a corruption test... |
-#do_execsql_test 2.7 { |
-# UPDATE x1_data SET block = X''; |
-# SELECT count(fts5_decode(rowid, block)) FROM x1_data; |
-#} $res |
- |
-do_execsql_test 2.8 { |
- SELECT fts5_decode(fts5_rowid('segment', 1000, 1), X'AB') |
-} {corrupt} |
- |
-#------------------------------------------------------------------------- |
-# Tests with very large tokens. |
-# |
-set strlist [list \ |
- "[string repeat x 400]" \ |
- "[string repeat x 300][string repeat w 100]" \ |
- "[string repeat x 300][string repeat y 100]" \ |
- "[string repeat x 300][string repeat z 600]" \ |
-] |
-do_test 3.0 { |
- execsql { |
- BEGIN; |
- CREATE VIRTUAL TABLE x2 USING fts5(a); |
- } |
- foreach str $strlist { execsql { INSERT INTO x2 VALUES($str) } } |
- execsql COMMIT |
-} {} |
- |
-for {set tn 0} {$tn<[llength $strlist]} {incr tn} { |
- set str [lindex $strlist $tn] |
- do_execsql_test 3.1.$tn { |
- SELECT rowid FROM x2 WHERE x2 MATCH $str |
- } [expr $tn+1] |
-} |
- |
-set res [db one {SELECT count(*) FROM x2_data}] |
-do_execsql_test 3.2 { |
- SELECT count(fts5_decode(rowid, block)) FROM x2_data; |
-} $res |
- |
-#------------------------------------------------------------------------- |
-# Leaf pages with no terms or rowids at all. |
-# |
-set strlist [list \ |
- "[string repeat {w } 400]" \ |
- "[string repeat {x } 400]" \ |
- "[string repeat {y } 400]" \ |
- "[string repeat {z } 400]" \ |
-] |
-do_test 4.0 { |
- execsql { |
- BEGIN; |
- CREATE VIRTUAL TABLE x3 USING fts5(a); |
- INSERT INTO x3(x3, rank) VALUES('pgsz', 32); |
- } |
- foreach str $strlist { execsql { INSERT INTO x3 VALUES($str) } } |
- execsql COMMIT |
-} {} |
- |
-for {set tn 0} {$tn<[llength $strlist]} {incr tn} { |
- set str [lindex $strlist $tn] |
- do_execsql_test 4.1.$tn { |
- SELECT rowid FROM x3 WHERE x3 MATCH $str |
- } [expr $tn+1] |
-} |
- |
-set res [db one {SELECT count(*) FROM x3_data}] |
-do_execsql_test 4.2 { |
- SELECT count(fts5_decode(rowid, block)) FROM x3_data; |
-} $res |
- |
-#------------------------------------------------------------------------- |
-# Position lists with large values. |
-# |
-set strlist [list \ |
- "[string repeat {w } 400]a" \ |
- "[string repeat {x } 400]a" \ |
- "[string repeat {y } 400]a" \ |
- "[string repeat {z } 400]a" \ |
-] |
-do_test 5.0 { |
- execsql { |
- BEGIN; |
- CREATE VIRTUAL TABLE x4 USING fts5(a); |
- INSERT INTO x4(x4, rank) VALUES('pgsz', 32); |
- } |
- foreach str $strlist { execsql { INSERT INTO x4 VALUES($str) } } |
- execsql COMMIT |
-} {} |
- |
-do_execsql_test 5.1 { |
- SELECT rowid FROM x4 WHERE x4 MATCH 'a' |
-} {1 2 3 4} |
- |
-set res [db one {SELECT count(*) FROM x4_data}] |
-do_execsql_test 5.2 { |
- SELECT count(fts5_decode(rowid, block)) FROM x4_data; |
-} $res |
- |
-finish_test |
- |