Lines Matching refs:docid

56 } {{CREATE TABLE 't1_content'(docid INTEGER PRIMARY KEY, 'c0a', 'c1b', langid)}}
58 do_execsql_test 1.3 {SELECT docid FROM t1} {}
150     $db eval { INSERT INTO t2(docid, x, y, l) VALUES($i, $x, $y, $iLangid) }
155     INSERT INTO data(rowid, x, y, l) SELECT docid, x, y, l FROM t2;
247       execsql {SELECT docid FROM t2 WHERE t2 MATCH $query AND l = $langid}
303     INSERT INTO t3_data(rowid, l, x, y) SELECT docid, l, x, y FROM t2;
327   INSERT INTO t2(docid, x, y, l) SELECT rowid, x, y, l FROM t3_data;
346   INSERT INTO t8(docid, a, b) VALUES(-1, 'one two three', 'x y z');
347   SELECT docid FROM t8 WHERE t8 MATCH 'one x' AND langid=0
362       INSERT INTO t4(docid, content, lid) VALUES($i, 'The Quick Brown Fox', $i) 
375   SELECT docid FROM t4 WHERE t4 MATCH 'quick';
378   SELECT docid FROM t4 WHERE t4 MATCH 'quick' AND lid=1;
381   SELECT docid FROM t4 WHERE t4 MATCH 'Quick' AND lid=1;
406       INSERT INTO t5(docid, content, lid) VALUES(
422 do_execsql_test 5.1.2 {SELECT docid FROM t5 WHERE t5 MATCH 'language'} 0
425     SELECT docid FROM t5 WHERE t5 MATCH 'language' AND lid = $langid
442   execsql { SELECT docid FROM t6 WHERE t6 MATCH 'belong' }
446   execsql { SELECT docid FROM t6 WHERE t6 MATCH 'belong' AND lid=$lid}
450 do_execsql_test 5.3.5 { SELECT docid FROM t6 WHERE t6 MATCH 'belong' } {1}
452   SELECT docid FROM t6 WHERE t6 MATCH 'belong' AND lid=$lid
473     SELECT docid FROM t6 WHERE t6 MATCH '"zero zero"' AND lid=$lid;
484     SELECT docid FROM t6 WHERE t6 MATCH '"zero zero"' AND lid=$lid;