Lines Matching refs:docid

62   1   "SELECT docid, * FROM t1"
63   2   "SELECT docid, * FROM t1 WHERE t1 MATCH 'aa'"
64   3   "SELECT docid, * FROM t1 WHERE t1 MATCH 'a*'"
65   4   "SELECT docid, quote(matchinfo(t1)) FROM t1 WHERE t1 MATCH 'a*'"
66   5   "SELECT docid, quote(matchinfo(t1,'pcnxals')) FROM t1 WHERE t1 MATCH 'b*'"
67   6   "SELECT docid, * FROM t1 WHERE t1 MATCH 'a* b* c*'"
68   7   "SELECT docid, * FROM t1 WHERE t1 MATCH 'aa OR da'"
69   8   "SELECT docid, * FROM t1 WHERE t1 MATCH 'nosuchtoken'"
70   9   "SELECT docid, snippet(t1) FROM t1 WHERE t1 MATCH 'aa OR da'"
71   10  "SELECT docid, snippet(t1) FROM t1 WHERE t1 MATCH 'aa OR nosuchtoken'"
72   11  "SELECT docid, snippet(t1) FROM t1 WHERE t1 MATCH 'aa NEAR bb'"
73   12  "SELECT docid, snippet(t1) FROM t1 WHERE t1 MATCH '\"aa bb\"'"
74   13  "SELECT docid, content FROM t1 WHERE t1 MATCH 'aa NEAR/2 bb NEAR/3 cc'"
75   14  "SELECT docid, content FROM t1 WHERE t1 MATCH '\"aa bb cc\"'"
86       set A($X(docid)) [array get X] 
87       lappend A_list $X(docid)
91       set B($X(docid)) [array get X] 
92       lappend B_list $X(docid)
95     db eval "$query ORDER BY docid ASC"  X  { 
96       set C($X(docid)) [array get X] 
97       lappend C_list $X(docid)
100     db eval "$query ORDER BY docid DESC" X  { 
101       set D($X(docid)) [array get X] 
102       lappend D_list $X(docid)
113       set DATA($X(docid)) [array get X] 
156     SELECT docid FROM t2 WHERE t2 MATCH 'aa';
160   SELECT docid FROM t2 WHERE t2 MATCH 'aa';
163   SELECT docid FROM t2 WHERE t2 MATCH 'aa' ORDER BY content;
171   INSERT INTO t3(docid, x) VALUES(113382409004785664, 'aa');
172   INSERT INTO t3(docid, x) VALUES(1, 'ab');
173   SELECT rowid FROM t3 WHERE x MATCH 'a*' ORDER BY docid DESC;
177   INSERT INTO t4(docid, x) VALUES(-113382409004785664, 'aa');
178   INSERT INTO t4(docid, x) VALUES(1, 'ab');