xref: /sqlite-3.40.0/test/fts4incr.test (revision eb26672d) 
1# 2012 March 26
2#
3# The author disclaims copyright to this source code.  In place of
4# a legal notice, here is a blessing:
5#
6#    May you do good and not evil.
7#    May you find forgiveness for yourself and forgive others.
8#    May you share freely, never taking more than you give.
9#
10#*************************************************************************
11#
12
13set testdir [file dirname $argv0]
14source $testdir/tester.tcl
15source $testdir/fts3_common.tcl
16set ::testprefix fts4docid
17
18# If SQLITE_ENABLE_FTS3 is defined, omit this file.
19ifcapable !fts3 {
20  finish_test
21  return
22}
23
24# Create the fts_kjv_genesis procedure which fills and FTS3/4 table
25# with the complete text of the Book of Genesis.
26#
27source $testdir/genesis.tcl
28
29do_test 1.0 {
30  execsql { CREATE VIRTUAL TABLE t1 USING fts3(words) }
31  fts_kjv_genesis
32} {}
33
34do_execsql_test 1.1 {
35  SELECT min(docid), max(docid) FROM t1;
36} {1001001 1050026}
37
38foreach {tn q res} {
39  1 { SELECT count(*) FROM t1 WHERE t1 MATCH 'and' AND docid < 1010000} 224
40  2 { SELECT count(*) FROM t1 WHERE t1 MATCH '"in the"' AND docid < 1010000} 47
41  3 { SELECT count(*) FROM t1 WHERE t1 MATCH '"And God"' AND docid < 1010000} 33
42  4 { SELECT count(*) FROM t1 WHERE t1
43      MATCH '"land of canaan"' AND docid < 1030000 } 7
44} {
45  foreach s {0 1} {
46    execsql "INSERT INTO t1(t1) VALUES('test-no-incr-doclist=$s')"
47    do_execsql_test 2.$tn.$s $q $res
48    set t($s) [lindex [time [list execsql $q] 100] 0]
49  }
50  puts "with optimization: $t(0)    without: $t(1)"
51}
52
53finish_test
54