Home
last modified time | relevance | path

Searched refs:ft (Results 1 – 25 of 41) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dfts3an.test196 execsql { INSERT INTO ft SELECT * FROM ft } ;# 2
197 execsql { INSERT INTO ft SELECT * FROM ft } ;# 4
198 execsql { INSERT INTO ft SELECT * FROM ft } ;# 8
199 execsql { INSERT INTO ft SELECT * FROM ft } ;# 16
200 execsql { INSERT INTO ft SELECT * FROM ft } ;# 32
201 execsql { INSERT INTO ft SELECT * FROM ft } ;# 64
202 execsql { INSERT INTO ft SELECT * FROM ft } ;# 128
203 execsql { INSERT INTO ft SELECT * FROM ft } ;# 256
204 execsql { INSERT INTO ft SELECT * FROM ft } ;# 512
205 execsql { INSERT INTO ft SELECT * FROM ft } ;# 1024
[all …]
H A Dfts4upfrom.test28 0 { CREATE VIRTUAL TABLE ft USING fts5(a, b, c) }
30 2 { CREATE TABLE ft(a, b, c) }
46 catchsql { DROP TABLE IF EXISTS ft }
47 catchsql { DROP VIEW IF EXISTS ft }
58 SELECT a, b, c FROM ft ORDER BY rowid;
67 UPDATE ft SET b=o.c FROM ft AS o WHERE (ft.a == char(unicode(o.a)+1))
71 SELECT a, b, c FROM ft ORDER BY rowid;
80 UPDATE ft SET c=v FROM changes WHERE a=k;
93 UPDATE ft SET c=v FROM changes WHERE a=k;
112 SELECT ft.rowid, a, b, c, o, n FROM ft, x1 WHERE ft.rowid = o;
[all …]
H A Dfts3snippet.test43 SELECT offsets(ft) FROM ft WHERE ft MATCH $expr
190 SELECT offsets(ft) FROM ft WHERE ft MATCH 'onehundred'
200 SELECT snippet(ft,'{','}','...',$iCol,$nTok) FROM ft WHERE ft MATCH $expr
362 SELECT mit(matchinfo(ft)) FROM ft WHERE ft MATCH $expr
426 SELECT mit(matchinfo(ft)), mit(matchinfo(ft))
445 SELECT length(offsets(ft)), typeof(offsets(ft)) FROM ft;
448 SELECT length(offsets(ft)), typeof(offsets(ft)) FROM ft WHERE rowid = $r
451 SELECT length(snippet(ft)), typeof(snippet(ft)) FROM ft;
454 SELECT length(snippet(ft)), typeof(snippet(ft)) FROM ft WHERE rowid = $r;
457 SELECT length(matchinfo(ft)), typeof(matchinfo(ft)) FROM ft;
[all …]
H A Dfts4onepass.test25 CREATE VIRTUAL TABLE ft USING fts3;
39 1.1 { DELETE FROM ft } 1
40 1.2 { DELETE FROM ft WHERE docid=? } 0
42 1.4 { DELETE FROM ft WHERE ft MATCH '1' } 1
43 1.5 { DELETE FROM ft WHERE ft MATCH '1' AND docid=? } 1
44 1.6 { DELETE FROM ft WHERE ft MATCH '1' AND rowid=? } 1
49 2.4 { UPDATE ft SET content='a b c' WHERE ft MATCH '1' } 1
50 2.5 { UPDATE ft SET content='a b c' WHERE ft MATCH '1' AND docid=? } 1
51 2.6 { UPDATE ft SET content='a b c' WHERE ft MATCH '1' AND rowid=? } 1
65 DELETE FROM ft WHERE rowid=new.x;
[all …]
H A Dfts3malloc.test98 execsql { INSERT INTO ft VALUES($a, $b) }
108 5 "SELECT a FROM ft" {
122 6 "SELECT a FROM ft WHERE a MATCH 'one'" {
130 7 "SELECT a FROM ft WHERE a MATCH 'o*'" {
175 13 {SELECT a FROM ft WHERE ft MATCH '"song sahm" hah'} {
224 20 {SELECT a FROM ft WHERE ft MATCH 'sahm NOT song'} {
260 1 "SELECT count(*) FROM ft" {1023}
285 1 "DELETE FROM ft WHERE ft MATCH 'one'"
286 2 "DELETE FROM ft WHERE ft MATCH 'three'"
287 3 "DELETE FROM ft WHERE ft MATCH 'five'"
[all …]
H A Dfts3fault2.test111 CREATE VIRTUAL TABLE ft USING fts4(a, b);
112 INSERT INTO ft VALUES('U U T C O', 'F N D E S');
113 INSERT INTO ft VALUES('P H X G B', 'I D M R U');
114 INSERT INTO ft VALUES('P P X D M', 'Y V N T C');
115 INSERT INTO ft VALUES('Z L Q O W', 'D F U N Q');
116 INSERT INTO ft VALUES('A J D U P', 'C H M Q E');
117 INSERT INTO ft VALUES('P S A O H', 'S Z C W D');
118 INSERT INTO ft VALUES('T B N L W', 'C A K T I');
129 execsql { INSERT INTO ft(ft) VALUES('rebuild') }
148 execsql { INSERT INTO ft VALUES(
[all …]
H A Dwherelimit2.test153 CREATE VIRTUAL TABLE ft USING fts5(x);
154 INSERT INTO ft(rowid, x) VALUES(-45, 'a a');
165 DELETE FROM ft ORDER BY rowid LIMIT 3;
166 SELECT x FROM ft;
172 DELETE FROM ft WHERE ft MATCH 'a' ORDER BY rowid LIMIT 3;
173 SELECT x FROM ft;
179 DELETE FROM ft WHERE ft MATCH 'b' ORDER BY rowid ASC LIMIT 1 OFFSET 1;
180 SELECT rowid FROM ft;
187 SELECT x FROM ft;
193 UPDATE ft SET x='hello' WHERE ft MATCH 'a'
[all …]
H A Dfts4min.test31 CREATE VIRTUAL TABLE ft USING fts3(c);
32 INSERT INTO ft(docid, c) VALUES(22, 'hello world');
33 INSERT INTO ft(docid, c) VALUES(44, 'hello world');
34 INSERT INTO ft(docid, c) VALUES(11, 'hello world');
38 SELECT max(rowid) FROM ft
42 SELECT min(rowid) FROM ft
46 SELECT max(rowid) FROM ft
50 SELECT min(rowid) FROM ft
H A Dfts3f.test28 CREATE VIRTUAL TABLE ft USING fts3(x);
30 INSERT INTO ft VALUES('a one'), ('b one'), ('c one');
35 db eval { SELECT docid FROM ft WHERE ft MATCH 'one' } {
46 INSERT INTO ft VALUES('a one'), ('b one'), ('c one');
50 SELECT docid, optimize(ft) FROM ft WHERE ft MATCH 'one'
H A Dvtabdrop.test65 CREATE VIRTUAL TABLE ft USING fts5(x);
76 catchsql { DROP TABLE ft }
83 } {ft ft_config ft_content ft_data ft_docsize ft_idx t1}
90 } {ft ft_config ft_content ft_data ft_docsize ft_idx t1}
99 CREATE VIRTUAL TABLE ft USING fts3(x);
110 catchsql { DROP TABLE ft }
117 } {ft ft_content ft_segdir ft_segments sqlite_autoindex_ft_segdir_1 t1}
124 } {ft ft_content ft_segdir ft_segments sqlite_autoindex_ft_segdir_1 t1}
H A Dfts3corrupt5.test29 CREATE VIRTUAL TABLE ft USING fts3(a, b, c);
30 INSERT INTO ft VALUES('one', 'one', 'one');
35 SELECT * FROM ft WHERE ft MATCH 'b:one'
55 SELECT * FROM ft WHERE ft MATCH $q
H A Dfts3aux2.test146 CREATE VIRTUAL TABLE ft USING fts3();
147 INSERT INTO ft VALUES('a_234567890123456789');
148 INSERT INTO ft VALUES('b_234567890123456789');
149 INSERT INTO ft VALUES('c_234567890123456789');
150 CREATE VIRTUAL TABLE t2 USING fts4aux(ft);
H A Dfts3query.test114 CREATE VIRTUAL TABLE ft USING fts3(title);
119 SELECT t1.number FROM t1, ft WHERE t1.number=ft.rowid ORDER BY t1.date
123 `--SCAN ft VIRTUAL TABLE INDEX 1:
126 SELECT t1.number FROM ft, t1 WHERE t1.number=ft.rowid ORDER BY t1.date
130 `--SCAN ft VIRTUAL TABLE INDEX 1:
H A Dfts4content.test604 CREATE VIRTUAL TABLE ft USING fts4(content=vt);
605 INSERT INTO ft(ft) VALUES('rebuild');
609 SELECT snippet(ft, '[', ']', '...', -1, 5) FROM ft WHERE ft MATCH 'e'
615 SELECT snippet(ft, '[', ']', '...', -1, 5) FROM ft WHERE ft MATCH 't'
620 do_execsql_test 10.6 { DELETE FROM ft WHERE docid=2 }
623 SELECT snippet(ft, '[', ']', '...', -1, 5) FROM ft WHERE ft MATCH 'e'
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5onepass.test37 1.1 { DELETE FROM ft } 1
38 1.2 { DELETE FROM ft WHERE rowid=? } 0
39 1.3 { DELETE FROM ft WHERE rowid=? } 0
40 1.4 { DELETE FROM ft WHERE ft MATCH '1' } 1
41 1.5 { DELETE FROM ft WHERE ft MATCH '1' AND rowid=? } 1
42 1.6 { DELETE FROM ft WHERE ft MATCH '1' AND rowid=? } 1
47 2.4 { UPDATE ft SET content='a b c' WHERE ft MATCH '1' } 1
48 2.5 { UPDATE ft SET content='a b c' WHERE ft MATCH '1' AND rowid=? } 1
49 2.6 { UPDATE ft SET content='a b c' WHERE ft MATCH '1' AND rowid=? } 1
63 DELETE FROM ft WHERE rowid=new.x;
[all …]
H A Dfts5synonym.test36 SELECT rowid, x FROM ft WHERE ft MATCH 'def';
37 SELECT x, rowid FROM ft WHERE ft MATCH 'pqr';
48 CREATE VIRTUAL TABLE ft USING fts5(
65 SELECT rowid FROM ft WHERE ft MATCH $expr
100 INSERT INTO ft(ft) VALUES('integrity-check');
110 SELECT rowid FROM ft WHERE ft MATCH 'one two three'
130 SELECT rowid FROM ft WHERE ft MATCH 'one';
133 SELECT rowid FROM ft WHERE ft MATCH 'one two three';
136 SELECT rowid FROM ft WHERE ft MATCH 'one + one + two + three';
139 SELECT rowid FROM ft WHERE ft MATCH 'one two two three';
[all …]
H A Dfts5fault4.test313 CREATE VIRTUAL TABLE ft USING fts5(x);
316 db eval { INSERT INTO ft(ft, rank) VALUES('rank', 'bm25(10.0, 5.0)') }
344 INSERT INTO ft VALUES('a b');
363 INSERT INTO ft(ft, rank) VALUES('pgsz', 32);
364 INSERT INTO ft VALUES(
369 INSERT INTO ft SELECT * FROM ft;
370 INSERT INTO ft SELECT * FROM ft;
371 INSERT INTO ft SELECT * FROM ft;
372 INSERT INTO ft SELECT * FROM ft;
377 db eval { SELECT * FROM ft }
[all …]
H A Dfts5ak.test131 CREATE VIRTUAL TABLE ft USING fts5(a, detail=%DETAIL%);
132 INSERT INTO ft VALUES('a b c x c d e');
133 INSERT INTO ft VALUES('a b c c d e');
134 INSERT INTO ft VALUES('a b c d e');
140 SELECT highlight(ft, 0, '[', ']') FROM ft WHERE ft MATCH 'a+b+c AND c+d+e';
148 SELECT highlight(ft, 0, NULL, NULL) FROM ft WHERE ft MATCH 'a+b+c AND c+d+e';
H A Dfts5savepoint.test23 CREATE VIRTUAL TABLE ft USING fts5(c);
26 INSERT INTO ft VALUES('a');
28 INSERT INTO ft VALUES('b');
31 INSERT INTO ft VALUES('c');
34 INSERT INTO ft VALUES('d');
37 SELECT * FROM ft
H A Dfts5misc.test307 CREATE VIRTUAL TABLE ft USING fts5(a);
308 INSERT INTO ft VALUES('b');
309 INSERT INTO ft VALUES('y');
311 CREATE TABLE t2(x, y, ft);
317 SELECT * FROM t1 NATURAL JOIN ft WHERE ft MATCH('b')
320 SELECT * FROM ft NATURAL JOIN t1 WHERE ft MATCH('b')
323 SELECT * FROM t2 JOIN ft USING (ft)
H A Dfts5conflict.test26 CREATE VIRTUAL TABLE ft USING fts5(a, b, content=t1, content_rowid=x);
30 REPLACE INTO ft(rowid, a, b) VALUES(1, 'a b c', 'a b c');
35 INSERT INTO ft(ft) VALUES('integrity-check');
H A Dfts5vocab.test484 CREATE VIRTUAL TABLE ft USING fts5(a, b, c);
485 CREATE VIRTUAL TABLE t2 USING fts5vocab('ft','row');
486 CREATE VIRTUAL TABLE t3 USING fts5vocab('ft','row');
491 INSERT INTO ft(b) VALUES('x y');
508 INSERT INTO ft(a) VALUES('1 2 3');
509 INSERT INTO ft(a) VALUES('4 5 6');
510 INSERT INTO ft(a) VALUES('1 2 3');
511 INSERT INTO ft(a) VALUES('4 5 6');
512 INSERT INTO ft(a) VALUES('1 2 3');
513 INSERT INTO ft(a) VALUES('4 5 6');
[all …]
H A Dfts5corrupt6.test34 CREATE VIRTUAL TABLE ft USING fts5(abc, def);
38 INSERT INTO ft SELECT
48 SELECT rowid FROM ft('def') ORDER BY rowid DESC LIMIT 1 OFFSET 9999;
/sqlite-3.40.0/ext/wasm/common/
H A Dwhwasmutil.js367 const ft = target.functionTable();
368 return fptr < ft.length ? ft.get(fptr) : undefined;
540 const ft = target.functionTable();
541 const oldLen = ft.length;
545 if(ft.get(ptr)){ /* Table was modified via a different API */
554 ft.grow(1);
558 ft.set(ptr, func);
568 ft.set(ptr, target.jsFuncToWasm(func, sig));
587 const ft = target.functionTable();
589 const rc = ft.get(ptr);
[all …]
/sqlite-3.40.0/ext/rbu/
H A Drbu10.test53 create virtual TABLE ft USING fts4(a, b, languageid='langid');
62 db eval { SELECT a, b, rowid, langid FROM ft }
77 db eval { SELECT a, b, rowid, langid FROM ft }
93 db eval { SELECT a, b, rowid, langid FROM ft }

12