[sql] Remove SQLite 3.10.2 reference directory.

third_party/sqlite/sqlite-src-3100200/ext/fts5/test/fts5config.test

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