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

Unified Diff: third_party/sqlite/sqlite-src-3080704/test/amatch1.test

Issue 2363173002: [sqlite] Remove obsolete reference version 3.8.7.4. (Closed)
Patch Set: Created 4 years, 3 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-3080704/test/amatch1.test
diff --git a/third_party/sqlite/sqlite-src-3080704/test/amatch1.test b/third_party/sqlite/sqlite-src-3080704/test/amatch1.test
deleted file mode 100644
index cc0f77af107688e3fa1e6ae906b58f71e8dd11c1..0000000000000000000000000000000000000000
--- a/third_party/sqlite/sqlite-src-3080704/test/amatch1.test
+++ /dev/null
@@ -1,117 +0,0 @@
-# 2013-09-30
-#
-# 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 implements regression tests for "approximate_match" virtual
-# table that is in the "amatch.c" extension.
-#
-#
-
-set testdir [file dirname $argv0]
-source $testdir/tester.tcl
-
-# If SQLITE_ENABLE_FTS4 is defined, omit this file.
-ifcapable !fts3 {
- finish_test
- return
-}
-
-# Create the fts_kjv_genesis procedure which fills and FTS3/4 table with
-# the complete text of the Book of Genesis.
-#
-source $testdir/genesis.tcl
-
-
-
-do_test amatch1-1.0 {
- db eval {
- CREATE VIRTUAL TABLE t1 USING fts4(words); --, tokenize porter);
- }
- fts_kjv_genesis
- db eval {
- INSERT INTO t1(t1) VALUES('optimize');
- CREATE VIRTUAL TABLE temp.t1aux USING fts4aux(main, t1);
- SELECT term FROM t1aux WHERE col=0 ORDER BY 1 LIMIT 5
- }
-} {a abated abel abelmizraim abidah}
-do_test amatch1-1.1 {
- db eval {
- SELECT term FROM t1aux WHERE term>'b' AND col=0 ORDER BY 1 LIMIT 5
- }
-} {baalhanan babel back backward bad}
-do_test amatch1-1.2 {
- db eval {
- SELECT term FROM t1aux WHERE term>'b' AND col=0 LIMIT 5
- }
-} {baalhanan babel back backward bad}
-
-# Load the amatch extension
-load_static_extension db amatch
-
-do_execsql_test amatch1-2.0 {
- CREATE TABLE costs(iLang, cFrom, cTo, Cost);
- INSERT INTO costs VALUES(0, '', '?', 100);
- INSERT INTO costs VALUES(0, '?', '', 100);
- INSERT INTO costs VALUES(0, '?', '?', 150);
- CREATE TABLE vocab(w TEXT UNIQUE);
- INSERT OR IGNORE INTO vocab SELECT term FROM t1aux;
- CREATE VIRTUAL TABLE t2 USING approximate_match(
- vocabulary_table=t1aux,
- vocabulary_word=term,
- edit_distances=costs
- );
- CREATE VIRTUAL TABLE t3 USING approximate_match(
- vocabulary_table=vocab,
- vocabulary_word=w,
- edit_distances=costs
- );
- CREATE VIRTUAL TABLE t4 USING approximate_match(
- vocabulary_table=vtemp,
- vocabulary_word=w,
- edit_distances=costs
- );
-} {}
-puts "Query against fts4aux: [time {
- do_execsql_test amatch1-2.1 {
- SELECT word, distance FROM t2
- WHERE word MATCH 'josxph' AND distance<300;
- } {joseph 150}} 1]"
-puts "Query against ordinary table: [time {
- do_execsql_test amatch1-2.2 {
- SELECT word, distance FROM t3
- WHERE word MATCH 'josxph' AND distance<300;
- } {joseph 150}} 1]"
-puts "Temp table initialized from fts4aux: [time {
- do_execsql_test amatch1-2.3a {
- CREATE TEMP TABLE vtemp(w TEXT UNIQUE);
- INSERT OR IGNORE INTO vtemp SELECT term FROM t1aux;
- } {}} 1]"
-puts "Query against temp table: [time {
- do_execsql_test amatch1-2.3b {
- SELECT word, distance FROM t4
- WHERE word MATCH 'josxph' AND distance<300;
- } {joseph 150}} 1]"
-do_execsql_test amatch1-2.11 {
- SELECT word, distance FROM t2
- WHERE word MATCH 'joxxph' AND distance<=300;
-} {joseph 300}
-do_execsql_test amatch1-2.12 {
- SELECT word, distance FROM t3
- WHERE word MATCH 'joxxph' AND distance<=300;
-} {joseph 300}
-do_execsql_test amatch1-2.21 {
- SELECT word, distance FROM t2
- WHERE word MATCH 'joxxph' AND distance<300;
-} {}
-do_execsql_test amatch1-2.22 {
- SELECT word, distance FROM t3
- WHERE word MATCH 'joxxph' AND distance<300;
-} {}
-
-finish_test
« no previous file with comments | « third_party/sqlite/sqlite-src-3080704/test/altermalloc.test ('k') | third_party/sqlite/sqlite-src-3080704/test/analyze.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698