Lines Matching refs:test
14 # $Id: fts2q.test,v 1.2 2008/07/22 23:49:44 shess Exp $
28 # TODO(shess): Change main.mk to do the right thing and remove this test.
45 proc check_terms {test level index terms} {
50 do_test $test.terms {
56 proc check_terms_all {test terms} {
57 do_test $test.terms {
66 proc check_doclist {test level index term doclist} {
71 do_test $test {
77 proc check_doclist_all {test term doclist} {
79 do_test $test {
94 INSERT INTO t1 (rowid, c) VALUES (1, 'This is a test');
95 INSERT INTO t1 (rowid, c) VALUES (2, 'That was a test');
96 INSERT INTO t1 (rowid, c) VALUES (3, 'This is a test');
98 INSERT INTO t1 (rowid, c) VALUES (1, 'This is a test');
110 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY rowid;
114 check_terms_all fts2q-1.1 {a is test this}
117 check_doclist_all fts2q-1.1.3 test {[1 0[3]]}
120 check_terms fts2q-1.2 0 0 {a is test this}
123 check_doclist fts2q-1.2.3 0 0 test {[1 0[3]]}
133 INSERT INTO t1 (rowid, c) VALUES (1, 'This is a test');
134 INSERT INTO t1 (rowid, c) VALUES (2, 'That was a test');
135 INSERT INTO t1 (rowid, c) VALUES (3, 'This is a test');
153 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY rowid;
157 check_terms_all fts2q-2.1 {a test that was}
159 check_doclist_all fts2q-2.1.2 test {[2 0[3]]}
163 check_terms fts2q-2.2 0 0 {a test that was}
165 check_doclist fts2q-2.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');
190 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY rowid;
194 check_terms_all fts2q-3.1 {a test that was}
196 check_doclist_all fts2q-3.1.2 test {[2 0[3]]}
200 check_terms fts2q-3.2 0 0 {a test that was}
202 check_doclist fts2q-3.2.2 0 0 test {[2 0[3]]}
214 INSERT INTO t1 (rowid, c) VALUES (1, 'This is a test');
215 INSERT INTO t1 (rowid, c) VALUES (2, 'That was a test');
216 INSERT INTO t1 (rowid, c) VALUES (3, 'This is a test');
218 UPDATE t1 SET c = 'This is a test one' WHERE rowid = 1;
219 UPDATE t1 SET c = 'That was a test one' WHERE rowid = 2;
220 UPDATE t1 SET c = 'This is a test one' WHERE rowid = 3;
222 UPDATE t1 SET c = 'This is a test two' WHERE rowid = 1;
223 UPDATE t1 SET c = 'That was a test two' WHERE rowid = 2;
224 UPDATE t1 SET c = 'This is a test two' WHERE rowid = 3;
226 UPDATE t1 SET c = 'This is a test three' WHERE rowid = 1;
227 UPDATE t1 SET c = 'That was a test three' WHERE rowid = 2;
228 UPDATE t1 SET c = 'This is a test three' WHERE rowid = 3;
230 UPDATE t1 SET c = 'This is a test four' WHERE rowid = 1;
231 UPDATE t1 SET c = 'That was a test four' WHERE rowid = 2;
232 UPDATE t1 SET c = 'This is a test four' WHERE rowid = 3;
234 UPDATE t1 SET c = 'This is a test' WHERE rowid = 1;
235 UPDATE t1 SET c = 'That was a test' WHERE rowid = 2;
236 UPDATE t1 SET c = 'This is a test' WHERE rowid = 3;
250 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY rowid;
256 check_terms_all fts2q-4.1 {a four is one test that this three two was}
261 check_doclist_all fts2q-4.1.5 test {[1 0[3]] [2 0[3]] [3 0[3]]}
268 check_terms fts2q-4.2 0 0 {a four test that was}
271 check_doclist fts2q-4.2.3 0 0 test {[2 0[3]]}
275 check_terms fts2q-4.3 0 1 {a four is test this}
279 check_doclist fts2q-4.3.4 0 1 test {[3 0[3]]}
282 check_terms fts2q-4.4 1 0 {a four is one test that this three two was}
287 check_doclist fts2q-4.4.5 1 0 test {[1 0[3]] [2 0[3]] [3 0[3]]}
307 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY rowid;
313 check_terms_all fts2q-4.5.1 {a is test that this was}
316 check_doclist_all fts2q-4.5.1.3 test {[1 0[3]] [2 0[3]] [3 0[3]]}
321 check_terms fts2q-4.5.2 1 0 {a is test that this was}
324 check_doclist fts2q-4.5.2.3 1 0 test {[1 0[3]] [2 0[3]] [3 0[3]]}