Lines Matching refs:docid

32   INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
33   INSERT INTO t1 (docid, c) VALUES (2, 'That was a test');
34   INSERT INTO t1 (docid, c) VALUES (3, 'This is a test');
39     SELECT docid FROM t1 ORDER BY docid;
45     SELECT docid FROM t1 WHERE c LIKE '%test' ORDER BY docid;
51     SELECT docid FROM t1 WHERE c LIKE 'That%' ORDER BY docid;
56 # Test lookup by docid (QUERY_DOCID).  This kind of query happens for
57 # queries which select by the docid/rowid implicit index.
64   INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'This is a test');
66   INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'That was a test');
68   INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'This is a test');
76     SELECT docid FROM t1 WHERE docid in (1, 2, 10);
83     SELECT docid, weight FROM t1, t2 WHERE t2.id = t1.docid ORDER BY weight;
90     SELECT docid, weight FROM t1, t2
91            WHERE t2.weight>5 AND t2.id = t1.docid ORDER BY weight;
105   INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'This is a test');
107   INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'That was a test');
109   INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'This is a test');
114     SELECT docid FROM t1 WHERE t1 MATCH 'this' ORDER BY docid;
120     SELECT docid, weight FROM t1, t2
121      WHERE t1 MATCH 'this' AND t1.docid = t2.id ORDER BY weight;