Lines Matching refs:is

4 # a legal notice, here is a blessing:
12 # of this script is testing the FTS3 module's optimize() function.
19 # If SQLITE_ENABLE_FTS3 is not defined, omit this file.
47 # Test results when all rows are deleted and one is added back.
49 # should be dropped when the table is empty.  The results should look
54   INSERT INTO t1 (docid, c) VALUES (1, 'This is 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}
76 check_doclist_all fts3d-1.1.2 is {[1 0[1]]}
80 check_terms   fts3d-1.2   0 0 {a is test this}
82 check_doclist fts3d-1.2.2 0 0 is {[1 0[1]]}
87 # Test results when everything is optimized manually.
88 # NOTE(shess): This is a copy of fts3c-1.3.  I've pulled a copy here
93   INSERT INTO t1 (docid, c) VALUES (1, 'This is 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;
130 # Test results when everything is optimized via optimize().
134   INSERT INTO t1 (docid, c) VALUES (1, 'This is 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;
174   INSERT INTO t1 (rowid, c) VALUES (1, 'This is 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;
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;
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;
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;
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;
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}
220 check_doclist_all fts3d-4.1.3  is {[1 0[1]] [3 0[1]]}
236 check_terms fts3d-4.3     0 1 {a four is test this}
239 check_doclist fts3d-4.3.3 0 1 is {[3 0[1]]}
243 check_terms fts3d-4.4      1 0 {a four is test that this was}
246 check_doclist fts3d-4.4.3  1 0 is {[1 0[1]] [3 0[1]]}
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}
276 check_doclist_all fts3d-4.5.1.2 is {[1 0[1]] [3 0[1]]}
282 check_terms fts3d-4.5.2     1 0 {a is test that this was}
284 check_doclist fts3d-4.5.2.2 1 0 is {[1 0[1]] [3 0[1]]}