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

Unified Diff: third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5rowid.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/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
-

Powered by Google App Engine
This is Rietveld 408576698