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

Unified Diff: third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5config.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/fts5config.test
diff --git a/third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5config.test b/third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5config.test
deleted file mode 100644
index dcda2d42a677d315908b83cf06fe28426048875b..0000000000000000000000000000000000000000
--- a/third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5config.test
+++ /dev/null
@@ -1,218 +0,0 @@
-# 2015 Jan 13
-#
-# 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 the code in fts5_config.c, which is largely concerned
-# with parsing the various configuration and CREATE TABLE options.
-#
-
-source [file join [file dirname [info script]] fts5_common.tcl]
-set testprefix fts5config
-
-# If SQLITE_ENABLE_FTS5 is defined, omit this file.
-ifcapable !fts5 {
- finish_test
- return
-}
-
-#-------------------------------------------------------------------------
-# Try different types of quote characters.
-#
-do_execsql_test 1.0 {
- CREATE VIRTUAL TABLE t1 USING fts5('a', "b", [c], `d`);
- PRAGMA table_info = t1;
-} {
- 0 a {} 0 {} 0
- 1 b {} 0 {} 0
- 2 c {} 0 {} 0
- 3 d {} 0 {} 0
-}
-
-#-------------------------------------------------------------------------
-# Syntax errors in the prefix= option.
-#
-foreach {tn opt} {
- 1 {prefix=x}
- 2 {prefix='x'}
- 3 {prefix='$'}
- 4 {prefix='1,2,'}
- 5 {prefix=',1'}
-} {
- set res [list 1 {malformed prefix=... directive}]
- do_catchsql_test 2.$tn "CREATE VIRTUAL TABLE f1 USING fts5(x, $opt)" $res
-}
-
-#-------------------------------------------------------------------------
-# Syntax errors in the 'rank' option.
-#
-foreach {tn val} {
- 1 "f1(xyz)"
- 2 "f1(zyx)"
- 3 "f1(nzz)"
- 4 "f1(x'!!')"
- 5 "f1(x':;')"
- 6 "f1(x'[]')"
- 7 "f1(x'{}')"
- 8 "f1('abc)"
-} {
- do_catchsql_test 3.$tn {
- INSERT INTO t1(t1, rank) VALUES('rank', $val);
- } {1 {SQL logic error or missing database}}
-}
-
-#-------------------------------------------------------------------------
-# The parsing of SQL literals specified as part of 'rank' options.
-#
-do_execsql_test 4.0 {
- CREATE VIRTUAL TABLE zzz USING fts5(one);
- INSERT INTO zzz VALUES('a b c');
-}
-proc first {cmd A} { return $A }
-sqlite3_fts5_create_function db first first
-
-foreach {tn arg} {
- 1 "123"
- 2 "'01234567890ABCDEF'"
- 3 "x'0123'"
- 4 "x'ABCD'"
- 5 "x'0123456789ABCDEF'"
- 6 "x'0123456789abcdef'"
- 7 "22.5"
- 8 "-91.5"
- 9 "-.5"
- 10 "''''"
- 11 "+.5"
-} {
- set func [string map {' ''} "first($arg)"]
- do_execsql_test 4.1.$tn "
- INSERT INTO zzz(zzz, rank) VALUES('rank', '$func');
- SELECT rank IS $arg FROM zzz WHERE zzz MATCH 'a + b + c'
- " 1
-}
-
-do_execsql_test 4.2 {
- INSERT INTO zzz(zzz, rank) VALUES('rank', 'f1()');
-} {}
-
-#-------------------------------------------------------------------------
-# Misquoting in tokenize= and other options.
-#
-do_catchsql_test 5.1 {
- CREATE VIRTUAL TABLE xx USING fts5(x, tokenize="porter 'ascii");
-} {1 {parse error in tokenize directive}}
-
-breakpoint
-do_catchsql_test 5.2 {
- CREATE VIRTUAL TABLE xx USING fts5(x, [y[]);
-} {0 {}}
-
-do_catchsql_test 5.3 {
- CREATE VIRTUAL TABLE yy USING fts5(x, [y]]);
-} {1 {unrecognized token: "]"}}
-
-#-------------------------------------------------------------------------
-# Errors in prefix= directives.
-#
-do_catchsql_test 6.2 {
- CREATE VIRTUAL TABLE abc USING fts5(a, prefix='1, 2, 1001');
-} {1 {prefix length out of range (max 999)}}
-do_catchsql_test 6.3 {
- CREATE VIRTUAL TAbLE abc USING fts5(a, prefix='1, 2, 0000');
-} {1 {prefix length out of range (max 999)}}
-do_catchsql_test 6.4 {
- CREATE VIRTUAL TABLE abc USING fts5(a, prefix='1 , 1000000');
-} {1 {prefix length out of range (max 999)}}
-
-#-------------------------------------------------------------------------
-# Duplicate tokenize= and other options.
-#
-do_catchsql_test 7.1 {
- CREATE VIRTUAL TABLE abc USING fts5(a, tokenize=porter, tokenize=ascii);
-} {1 {multiple tokenize=... directives}}
-do_catchsql_test 7.2 {
- CREATE VIRTUAL TABLE abc USING fts5(a, content=porter, content=ascii);
-} {1 {multiple content=... directives}}
-do_catchsql_test 7.3 {
- CREATE VIRTUAL TABLE abc USING fts5(a, content_rowid=porter, content_rowid=a);
-} {1 {multiple content_rowid=... directives}}
-
-#-------------------------------------------------------------------------
-# Unrecognized option.
-#
-do_catchsql_test 8.0 {
- CREATE VIRTUAL TABLE abc USING fts5(a, nosuchoption=123);
-} {1 {unrecognized option: "nosuchoption"}}
-do_catchsql_test 8.1 {
- CREATE VIRTUAL TABLE abc USING fts5(a, "nosuchoption"=123);
-} {1 {parse error in ""nosuchoption"=123"}}
-
-#-------------------------------------------------------------------------
-# Errors in:
-#
-# 9.1.* 'pgsz' options.
-# 9.2.* 'automerge' options.
-# 9.3.* 'crisismerge' options.
-#
-do_execsql_test 9.0 {
- CREATE VIRTUAL TABLE abc USING fts5(a, b);
-} {}
-do_catchsql_test 9.1.1 {
- INSERT INTO abc(abc, rank) VALUES('pgsz', -5);
-} {1 {SQL logic error or missing database}}
-do_catchsql_test 9.1.2 {
- INSERT INTO abc(abc, rank) VALUES('pgsz', 50000000);
-} {1 {SQL logic error or missing database}}
-do_catchsql_test 9.1.3 {
- INSERT INTO abc(abc, rank) VALUES('pgsz', 66.67);
-} {1 {SQL logic error or missing database}}
-
-do_catchsql_test 9.2.1 {
- INSERT INTO abc(abc, rank) VALUES('automerge', -5);
-} {1 {SQL logic error or missing database}}
-do_catchsql_test 9.2.2 {
- INSERT INTO abc(abc, rank) VALUES('automerge', 50000000);
-} {1 {SQL logic error or missing database}}
-do_catchsql_test 9.2.3 {
- INSERT INTO abc(abc, rank) VALUES('automerge', 66.67);
-} {1 {SQL logic error or missing database}}
-do_execsql_test 9.2.4 {
- INSERT INTO abc(abc, rank) VALUES('automerge', 1);
-} {}
-
-do_catchsql_test 9.3.1 {
- INSERT INTO abc(abc, rank) VALUES('crisismerge', -5);
-} {1 {SQL logic error or missing database}}
-do_catchsql_test 9.3.2 {
- INSERT INTO abc(abc, rank) VALUES('crisismerge', 66.67);
-} {1 {SQL logic error or missing database}}
-do_execsql_test 9.3.3 {
- INSERT INTO abc(abc, rank) VALUES('crisismerge', 1);
-} {}
-do_execsql_test 9.3.4 {
- INSERT INTO abc(abc, rank) VALUES('crisismerge', 50000000);
-} {}
-
-do_catchsql_test 9.4.1 {
- INSERT INTO abc(abc, rank) VALUES('nosuchoption', 1);
-} {1 {SQL logic error or missing database}}
-
-#-------------------------------------------------------------------------
-# Too many prefix indexes. Maximum allowed is 31.
-#
-foreach {tn spec} {
- 1 {prefix="1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32"}
- 2 {prefix="1 2 3 4", prefix="5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32"}
-} {
- set sql "CREATE VIRTUAL TABLE xyz USING fts5(x, $spec)"
- do_catchsql_test 10.$tn $sql {1 {too many prefix indexes (max 31)}}
-}
-
-finish_test
-

Powered by Google App Engine
This is Rietveld 408576698