Home
last modified time | relevance | path

Searched refs:docid (Results 1 – 25 of 53) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dfts4docid.test45 execsql { INSERT INTO t1(docid, content) VALUES($docid, $content) }
50 do_execsql_test 2.1.1 { SELECT docid FROM t1 WHERE docid = 5 } {5}
51 do_execsql_test 2.1.2 { SELECT docid FROM t1 WHERE docid = '5' } {5}
52 do_execsql_test 2.1.3 { SELECT docid FROM t1 WHERE docid = +5 } {5}
53 do_execsql_test 2.1.4 { SELECT docid FROM t1 WHERE docid = +'5' } {5}
54 do_execsql_test 2.1.5 { SELECT docid FROM t1 WHERE docid < 5 } {0 1 2 3 4}
73 # Queries are run with both "ORDER BY docid DESC" and "ORDER BY docid ASC"
93 1 docid "ORDER BY docid ASC"
94 2 +docid "ORDER BY docid ASC"
98 5 docid "ORDER BY docid DESC"
[all …]
H A Dfts3sort.test62 1 "SELECT docid, * FROM t1"
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)
96 set C($X(docid)) [array get X]
97 lappend C_list $X(docid)
101 set D($X(docid)) [array get X]
102 lappend D_list $X(docid)
113 set DATA($X(docid)) [array get X]
[all …]
H A Dfts3e.test32 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;
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
114 SELECT docid FROM t1 WHERE t1 MATCH 'this' ORDER BY docid;
[all …]
H A Dfts4onepass.test40 1.2 { DELETE FROM ft WHERE docid=? } 0
43 1.5 { DELETE FROM ft WHERE ft MATCH '1' AND docid=? } 1
47 2.2 { UPDATE ft SET content='a b c' WHERE docid=? } 0
111 1 { UPDATE ft2 SET docid=2 WHERE docid=1 }
116 UPDATE ft2 SET docid=5 WHERE docid=4;
117 UPDATE ft2 SET docid=3 WHERE docid=5;
121 UPDATE ft2 SET docid=3 WHERE docid=4; -- matches 0 rows
122 UPDATE ft2 SET docid=2 WHERE docid=3;
127 UPDATE ft2 SET docid=-1 WHERE docid=4;
128 UPDATE ft2 SET docid=3 WHERE docid=-1;
[all …]
H A Dfts4aa.test56 set r [db eval {SELECT docid FROM t1 WHERE words MATCH $q ORDER BY docid}]
65 SELECT docid FROM t1 EXCEPT SELECT docid FROM t1_docsize
70 SELECT docid FROM t1_docsize EXCEPT SELECT docid FROM t1
91 ORDER BY docid;
98 ORDER BY docid;
112 SELECT docid FROM t1 EXCEPT SELECT docid FROM t1_docsize
117 SELECT docid FROM t1_docsize EXCEPT SELECT docid FROM t1
126 ORDER BY docid;
145 db eval {SELECT docid FROM t1 WHERE words MATCH $::q ORDER BY docid}
166 db eval {SELECT docid FROM t1 WHERE words MATCH $::q ORDER BY docid}
[all …]
H A Dfts3first.test41 INSERT INTO x1(docid,a,b,c) VALUES(0, 'K H D S T', 'V M N Y K', 'S Z N Q S');
42 INSERT INTO x1(docid,a,b,c) VALUES(1, 'K N J L W', 'S Z W J Q', 'D U W S E');
43 INSERT INTO x1(docid,a,b,c) VALUES(2, 'B P M O I', 'R P H W S', 'R J L L E');
44 INSERT INTO x1(docid,a,b,c) VALUES(3, 'U R Q M L', 'M J K A V', 'Q W J T J');
45 INSERT INTO x1(docid,a,b,c) VALUES(4, 'N J C Y N', 'R U D X V', 'B O U A Q');
46 INSERT INTO x1(docid,a,b,c) VALUES(5, 'Q L X L U', 'I F N X S', 'U Q A N Y');
47 INSERT INTO x1(docid,a,b,c) VALUES(6, 'M R G U T', 'U V I Q P', 'X Y D L S');
48 INSERT INTO x1(docid,a,b,c) VALUES(7, 'D Y P O I', 'X J P K R', 'V O T H V');
49 INSERT INTO x1(docid,a,b,c) VALUES(8, 'R Y D L R', 'U U E S J', 'N W L M R');
50 INSERT INTO x1(docid,a,b,c) VALUES(9, 'Z P F N P', 'W A X D U', 'V A E Q A');
[all …]
H A Dfts3conf.test38 set cols [join [concat docid $cols] ,]
73 set T3 "t1 SET docid = 2 WHERE docid = 1"
74 set T4 "t1 SET docid = CASE WHEN docid = 1 THEN 4 ELSE 3 END WHERE docid <=2"
131 INSERT INTO t1(docid, x) VALUES(0, 'a b c');
132 INSERT INTO t1(docid, x) VALUES(1, 'a b c');
133 REPLACE INTO t1(docid, x) VALUES('zero', 'd e f');
142 REPLACE INTO t3(docid, content) VALUES (1, 'one two');
157 UPDATE OR REPLACE t3 SET docid = 2 WHERE docid=1;
162 UPDATE OR REPLACE t3 SET docid = 3 WHERE docid=2;
174 SELECT docid FROM t3;
[all …]
H A Dfts3b.test153 SELECT rowid FROM t4 WHERE rowid <> docid;
157 # Test that docid is hidden.
164 # Test that docid can be selected.
167 SELECT docid, * FROM t4 WHERE rowid = 1;
171 # Test that docid can be used in WHERE.
174 SELECT docid, * FROM t4 WHERE docid = 1;
187 # Test that the docid can be forced on insert.
191 SELECT * FROM t4 WHERE docid = 10;
199 SELECT * FROM t4 WHERE docid = 12;
207 SELECT * FROM t4 WHERE docid = 14;
[all …]
H A Dfts3c.test52 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
53 INSERT INTO t1 (docid, c) VALUES (2, 'That was a test');
54 INSERT INTO t1 (docid, c) VALUES (3, 'This is a test');
108 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
110 INSERT INTO t1 (docid, c) VALUES (3, 'This is a test');
111 DELETE FROM t1 WHERE docid = 1;
163 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
165 INSERT INTO t1 (docid, c) VALUES (3, 'This is a test');
166 DELETE FROM t1 WHERE docid IN (1,3);
222 DELETE FROM t1 WHERE docid IN (1,3);
[all …]
H A Dfts3auto.test83 lappend matchinfo_asc $docid $aMatchinfo($docid)
87 lappend matchinfo_desc $docid $aMatchinfo($docid)
93 SELECT docid FROM $tbl WHERE $tbl MATCH '$match' ORDER BY docid ASC
97 SELECT docid FROM $tbl WHERE $tbl MATCH '$match' ORDER BY docid DESC
218 set docid $d(docid)
221 if {$hit} { set hits($docid) 1 }
223 set counts($docid,$iCol) $miss
282 foreach docid [array names hits] {
283 set aMatchinfo($docid) $aRewrite($docid)
292 foreach docid [array names hits] {
[all …]
H A Dfts4opt.test29 do_execsql_test 1.0 { CREATE TABLE t1(docid, words) }
66 foreach {docid words} [db eval { SELECT * FROM t1 }] {
67 execsql { INSERT INTO t2(docid, words) VALUES($docid, $words) }
115 foreach {docid words} [db eval { SELECT * FROM t1 }] {
116 execsql { INSERT INTO t2(docid, words) VALUES($docid, $words) }
120 foreach {docid words} [db eval { SELECT * FROM t1 }] {
121 if {[incr i] % 2} { execsql { DELETE FROM t2 WHERE docid = $docid } }
125 foreach {docid words} [db eval { SELECT * FROM t1 }] {
127 execsql { INSERT OR REPLACE INTO t2(docid, words) VALUES($docid, $words) }
H A Dfts4noti.test76 do_execsql_test 2.$tn.2 { SELECT docid FROM t1 WHERE t1 MATCH 'one' } {1 2}
77 do_execsql_test 2.$tn.3 { SELECT docid FROM t1 WHERE t1 MATCH 'three' } {2}
78 do_execsql_test 2.$tn.4 { SELECT docid FROM t1 WHERE t1 MATCH 'five' } {1}
82 do_execsql_test 2.$tn.6 { SELECT docid FROM t1 WHERE t1 MATCH 'one' } {1 2}
83 do_execsql_test 2.$tn.7 { SELECT docid FROM t1 WHERE t1 MATCH 'three' } {2}
84 do_execsql_test 2.$tn.8 { SELECT docid FROM t1 WHERE t1 MATCH 'five' } {1}
94 SELECT a,b,c FROM t1 WHERE docid=1
97 SELECT a,b,c FROM t1 WHERE docid=2
162 do_execsql_test 5.2 { SELECT docid FROM t2 WHERE t2 MATCH 'a' } {2}
163 do_execsql_test 5.3 { SELECT docid FROM t2 WHERE t2 MATCH 'b' } {1}
[all …]
H A Dfts4langid.test58 do_execsql_test 1.3 {SELECT docid FROM t1} {}
155 INSERT INTO data(rowid, x, y, l) SELECT docid, x, y, l FROM t2;
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
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(
442 execsql { SELECT docid FROM t6 WHERE t6 MATCH 'belong' }
452 SELECT docid FROM t6 WHERE t6 MATCH 'belong' AND lid=$lid
[all …]
H A Dfts4growth.test106 CREATE TABLE t1(docid, words);
111 foreach id [db eval {SELECT docid FROM t1}] {
113 INSERT INTO x2(docid, content) SELECT $id, words FROM t1 WHERE docid=$id
116 foreach id [db eval {SELECT docid FROM t1}] {
118 INSERT INTO x2(docid, content) SELECT NULL, words FROM t1 WHERE docid=$id
251 CREATE TABLE t1(docid, words);
288 CREATE TABLE t1(docid, words);
299 INSERT INTO x2(docid, content) SELECT docid, words FROM t1 WHERE rowid=$r
303 execsql { DELETE FROM x2 WHERE docid = $d }
331 DELETE FROM x2 WHERE docid=$id;
[all …]
H A Dfts3rnd.test190 if { [lindex [lsort -integer $a($docid)] end] } {
192 foreach i {0 1 2} hit $a($docid) {
195 lappend ret $docid $matchinfo
341 ORDER BY docid ASC
345 ORDER BY docid DESC
357 SELECT docid FROM t1 WHERE t1 MATCH $match
367 SELECT docid FROM t1 WHERE t1 MATCH $match
377 SELECT docid FROM t1 WHERE t1 MATCH $match
390 SELECT docid FROM t1 WHERE t1 MATCH $match
402 SELECT docid FROM t1 WHERE t1 MATCH $match
[all …]
H A Dtkt-bdc6bbbb38.test32 SELECT offsets(t2) FROM t2 WHERE t2 MATCH 'a AND d OR b' ORDER BY docid ASC
38 ORDER BY docid ASC
44 SELECT offsets(t2) FROM t2 WHERE t2 MATCH 'a AND d OR b' ORDER BY docid ASC
51 ORDER BY docid ASC
61 SELECT offsets(t3) FROM t3 WHERE t3 MATCH 'a AND d OR b' ORDER BY docid DESC
67 ORDER BY docid DESC
75 SELECT offsets(t3) FROM t3 WHERE t3 MATCH 'a AND d OR b' ORDER BY docid DESC
82 ORDER BY docid DESC
H A Dfts3_common.tcl178 set docid 0
188 incr docid [gobble_varint doclist]
218 set iDoc $E(docid)
287 set docid 0
294 incr docid [gobble_varint doclist]
314 set ret($docid) $lCol
316 unset -nocomplain ret($docid)
322 foreach docid [lsort -integer [array names ret]] {
325 foreach col $ret($docid) {
329 lappend lDoc "\[${docid}${cols}\]"
H A Dfts3d.test54 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
55 INSERT INTO t1 (docid, c) VALUES (2, 'That was 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');
93 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
95 INSERT INTO t1 (docid, c) VALUES (3, 'This is a test');
96 DELETE FROM t1 WHERE docid IN (1,3);
100 INSERT INTO t1 (docid, c) SELECT docid, c FROM t1old;
134 INSERT INTO t1 (docid, c) VALUES (1, 'This is a test');
136 INSERT INTO t1 (docid, c) VALUES (3, 'This is a test');
[all …]
H A Dfts4merge3.test44 do_test 1.2 { sql1 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'" } {1485}
45 do_test 1.3 { sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'" } {1485}
59 sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
70 sql2 "INSERT INTO t2 SELECT content FROM t2 WHERE docid = $i"
81 sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
86 sql2 "INSERT INTO t2 SELECT content FROM t2 WHERE docid = $i"
90 sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
95 sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
H A De_fts3.test153 INSERT INTO pages(docid, title, body)
157 SELECT docid, * FROM pages
165 SELECT docid, * FROM pages
172 SELECT docid, * FROM pages
217 INSERT INTO mail(docid, subject, body)
221 INSERT INTO mail(docid, subject, body)
316 foreach {tn docid content} {
321 set R($docid) $content
323 INSERT INTO docs(docid, content) VALUES($docid, $content)
362 SELECT docid FROM docs
[all …]
H A Dfts4incr.test35 SELECT min(docid), max(docid) FROM t1;
39 1 { SELECT count(*) FROM t1 WHERE t1 MATCH 'and' AND docid < 1010000} 224
40 2 { SELECT count(*) FROM t1 WHERE t1 MATCH '"in the"' AND docid < 1010000} 47
41 3 { SELECT count(*) FROM t1 WHERE t1 MATCH '"And God"' AND docid < 1010000} 33
43 MATCH '"land of canaan"' AND docid < 1030000 } 7
63 execsql { INSERT INTO t2(docid, content) VALUES($i, $x) }
H A Dfts3near.test33 execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR/0 three'}
36 execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR/1 two'}
39 execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR/1 three'}
42 execsql {SELECT docid FROM t1 WHERE content MATCH 'three NEAR/1 one'}
51 execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR four'}
54 execsql {SELECT docid FROM t1 WHERE content MATCH 'four NEAR three'}
69 execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR five'}
73 execsql {SELECT docid FROM t1 WHERE content MATCH 'four NEAR four'}
188 SELECT docid FROM t1 WHERE content MATCH 'specification attach'
558 SELECT docid FROM t1 WHERE content MATCH 'abbrev zygosis'
[all …]
H A Dfts4merge.test51 SELECT docid FROM t1 WHERE t1 MATCH 'zero one two three'
65 SELECT docid FROM t1 WHERE t1 MATCH 'zero one two three'
205 foreach docid [execsql {SELECT docid FROM t1}] {
206 execsql {INSERT INTO t1 SELECT * FROM t1 WHERE docid=$docid}
236 foreach docid [execsql {
237 SELECT docid FROM t1 UNION ALL SELECT docid FROM t1 LIMIT $L
239 execsql {INSERT INTO t1 SELECT * FROM t1 WHERE docid=$docid}
H A Dfts3join.test38 SELECT docid FROM ft1, t1 WHERE ft1 MATCH y AND id=1;
42 SELECT docid FROM ft1, t1 WHERE ft1 MATCH y AND id=1 ORDER BY docid;
95 SELECT docid, * FROM ft4 WHERE ft4 MATCH ?
96 ) AS rr ON t4.rowid=rr.docid
103 `--SEARCH rr USING AUTOMATIC COVERING INDEX (docid=?) LEFT-JOIN
/sqlite-3.40.0/ext/fts3/
H A DREADME.content32 integer docid value. For example:
49 SELECT docid FROM t1 WHERE t1 MATCH 'xxx';
50 SELECT docid FROM t1 WHERE a MATCH 'xxx';
54 -- other than docid are required to evaluate them.
57 SELECT docid FROM t1 WHERE a LIKE 'xxx%';
64 other than docid.
100 INSERT INTO t3(docid, b, c) SELECT id, b, c FROM t2;
145 DELETE FROM t3 WHERE docid=old.rowid;
148 DELETE FROM t3 WHERE docid=old.rowid;
152 INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c);
[all …]

123