Lines Matching refs:test
28 proc check_terms {test level index terms} {
30 do_test $test.terms [list fts3_terms t1 $where] $terms
32 proc check_terms_all {test terms} {
33 do_test $test.terms [list fts3_terms t1 1] $terms
38 proc check_doclist {test level index term doclist} {
40 do_test $test.doclist [list fts3_doclist t1 $term $where] $doclist
42 proc check_doclist_all {test term doclist} {
43 do_test $test.doclist [list fts3_doclist t1 $term 1] $doclist
54 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
55 INSERT INTO t1 (docid, c) VALUES (2, 'That was a test');
56 INSERT INTO t1 (docid, c) VALUES (3, 'This is a test');
58 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
70 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid;
74 check_terms_all fts3d-1.1 {a is test this}
77 check_doclist_all fts3d-1.1.3 test {[1 0[3]]}
80 check_terms fts3d-1.2 0 0 {a is test this}
83 check_doclist fts3d-1.2.3 0 0 test {[1 0[3]]}
93 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
94 INSERT INTO t1 (docid, c) VALUES (2, 'That was a test');
95 INSERT INTO t1 (docid, c) VALUES (3, 'This is a test');
113 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid;
117 check_terms_all fts3d-2.1 {a test that was}
119 check_doclist_all fts3d-2.1.2 test {[2 0[3]]}
123 check_terms fts3d-2.2 0 0 {a test that was}
125 check_doclist fts3d-2.2.2 0 0 test {[2 0[3]]}
134 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
135 INSERT INTO t1 (docid, c) VALUES (2, 'That was a test');
136 INSERT INTO t1 (docid, c) VALUES (3, 'This is a test');
150 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid;
154 check_terms_all fts3d-3.1 {a test that was}
156 check_doclist_all fts3d-3.1.2 test {[2 0[3]]}
160 check_terms fts3d-3.2 0 0 {a test that was}
162 check_doclist fts3d-3.2.2 0 0 test {[2 0[3]]}
174 INSERT INTO t1 (rowid, c) VALUES (1, 'This is a test');
175 INSERT INTO t1 (rowid, c) VALUES (2, 'That was a test');
176 INSERT INTO t1 (rowid, c) VALUES (3, 'This is a test');
178 UPDATE t1 SET c = 'This is a test one' WHERE rowid = 1;
179 UPDATE t1 SET c = 'That was a test one' WHERE rowid = 2;
180 UPDATE t1 SET c = 'This is a test one' WHERE rowid = 3;
182 UPDATE t1 SET c = 'This is a test two' WHERE rowid = 1;
183 UPDATE t1 SET c = 'That was a test two' WHERE rowid = 2;
184 UPDATE t1 SET c = 'This is a test two' WHERE rowid = 3;
186 UPDATE t1 SET c = 'This is a test three' WHERE rowid = 1;
187 UPDATE t1 SET c = 'That was a test three' WHERE rowid = 2;
188 UPDATE t1 SET c = 'This is a test three' WHERE rowid = 3;
190 UPDATE t1 SET c = 'This is a test four' WHERE rowid = 1;
191 UPDATE t1 SET c = 'That was a test four' WHERE rowid = 2;
192 UPDATE t1 SET c = 'This is a test four' WHERE rowid = 3;
194 UPDATE t1 SET c = 'This is a test' WHERE rowid = 1;
195 UPDATE t1 SET c = 'That was a test' WHERE rowid = 2;
196 UPDATE t1 SET c = 'This is a test' WHERE rowid = 3;
210 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid;
217 check_terms_all fts3d-4.1 {a four is test that this was}
222 check_doclist_all fts3d-4.1.5 test {[1 0[3]] [2 0[3]] [3 0[3]]}
229 check_terms fts3d-4.2 0 0 {a four test that was}
232 check_doclist fts3d-4.2.3 0 0 test {[2 0[3]]}
236 check_terms fts3d-4.3 0 1 {a four is test this}
240 check_doclist fts3d-4.3.4 0 1 test {[3 0[3]]}
243 check_terms fts3d-4.4 1 0 {a four is test that this was}
248 check_doclist fts3d-4.4.5 1 0 test {[1 0[3]] [2 0[3]] [3 0[3]]}
268 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid;
274 check_terms_all fts3d-4.5.1 {a is test that this was}
277 check_doclist_all fts3d-4.5.1.3 test {[1 0[3]] [2 0[3]] [3 0[3]]}
282 check_terms fts3d-4.5.2 1 0 {a is test that this was}
285 check_doclist fts3d-4.5.2.3 1 0 test {[1 0[3]] [2 0[3]] [3 0[3]]}
313 forcedelete test.db
314 sqlite3 db test.db
329 forcedelete test.db
330 sqlite3 db test.db
345 forcedelete test.db
346 sqlite3 db test.db
364 sqlite3 db test.db