Home
last modified time | relevance | path

Searched refs:content (Results 1 – 25 of 160) sorted by relevance

1234567

/sqlite-3.40.0/test/
H A Dfts2a.test31 CREATE VIRTUAL TABLE t1 USING fts2(content);
32 INSERT INTO t1(content) VALUES('one');
33 INSERT INTO t1(content) VALUES('two');
34 INSERT INTO t1(content) VALUES('one two');
35 INSERT INTO t1(content) VALUES('three');
36 INSERT INTO t1(content) VALUES('one three');
39 INSERT INTO t1(content) VALUES('four');
40 INSERT INTO t1(content) VALUES('one four');
41 INSERT INTO t1(content) VALUES('two four');
47 INSERT INTO t1(content) VALUES('five');
[all …]
H A Dfts1a.test31 CREATE VIRTUAL TABLE t1 USING fts1(content);
32 INSERT INTO t1(content) VALUES('one');
33 INSERT INTO t1(content) VALUES('two');
34 INSERT INTO t1(content) VALUES('one two');
35 INSERT INTO t1(content) VALUES('three');
36 INSERT INTO t1(content) VALUES('one three');
39 INSERT INTO t1(content) VALUES('four');
40 INSERT INTO t1(content) VALUES('one four');
41 INSERT INTO t1(content) VALUES('two four');
47 INSERT INTO t1(content) VALUES('five');
[all …]
H A Dfts3aa.test32 CREATE VIRTUAL TABLE t1 USING fts3(content);
33 INSERT INTO t1(content) VALUES('one');
34 INSERT INTO t1(content) VALUES('two');
35 INSERT INTO t1(content) VALUES('one two');
36 INSERT INTO t1(content) VALUES('three');
37 INSERT INTO t1(content) VALUES('one three');
40 INSERT INTO t1(content) VALUES('four');
41 INSERT INTO t1(content) VALUES('one four');
42 INSERT INTO t1(content) VALUES('two four');
48 INSERT INTO t1(content) VALUES('five');
[all …]
H A Dfts1f.test28 CREATE VIRTUAL TABLE t1 USING fts1(content);
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
33 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
34 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
37 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
49 INSERT INTO t1 (rowid, content) VALUES(16, 'five');
[all …]
H A Dfts2f.test28 CREATE VIRTUAL TABLE t1 USING fts2(content);
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
33 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
34 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
37 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
49 INSERT INTO t1 (rowid, content) VALUES(16, 'five');
[all …]
H A Dfts3af.test28 CREATE VIRTUAL TABLE t1 USING fts3(content);
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
33 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
34 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
37 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
49 INSERT INTO t1 (rowid, content) VALUES(16, 'five');
[all …]
H A Dfts2e.test28 CREATE VIRTUAL TABLE t1 USING fts2(content);
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
34 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
35 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
38 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
40 INSERT INTO t1 (rowid, content) VALUES(10, 'two four');
[all …]
H A Dfts1e.test28 CREATE VIRTUAL TABLE t1 USING fts1(content);
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
34 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
35 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
38 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
40 INSERT INTO t1 (rowid, content) VALUES(10, 'two four');
[all …]
H A Dfts3ae.test28 CREATE VIRTUAL TABLE t1 USING fts3(content);
29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32 INSERT INTO t1 (rowid, content) VALUES(4, 'three');
34 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
35 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
38 INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
40 INSERT INTO t1 (rowid, content) VALUES(10, 'two four');
[all …]
H A Dfts3ad.test29 CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize porter);
30 INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
31 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
41 INSERT INTO t1(rowid, content)
53 INSERT INTO t1(rowid, content)
67 CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize porter);
69 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
77 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
85 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
93 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
[all …]
H A Dfts4langid.test79 INSERT INTO t1(content) VALUES('a b c');
101 INSERT INTO t1(content, lang_id) VALUES('A', 13);
102 INSERT INTO t1(content, lang_id) VALUES('B', 13);
103 INSERT INTO t1(content, lang_id) VALUES('C', 13);
104 INSERT INTO t1(content, lang_id) VALUES('D', 13);
105 INSERT INTO t1(content, lang_id) VALUES('E', 13);
106 INSERT INTO t1(content, lang_id) VALUES('F', 13);
107 INSERT INTO t1(content, lang_id) VALUES('G', 13);
108 INSERT INTO t1(content, lang_id) VALUES('H', 13);
109 INSERT INTO t1(content, lang_id) VALUES('I', 13);
[all …]
H A Dfts4onepass.test26 INSERT INTO ft(rowid, content) VALUES(1, '1 2 3');
27 INSERT INTO ft(rowid, content) VALUES(2, '4 5 6');
28 INSERT INTO ft(rowid, content) VALUES(3, '7 8 9');
46 2.1 { UPDATE ft SET content='a b c' } 1
47 2.2 { UPDATE ft SET content='a b c' WHERE docid=? } 0
48 2.3 { UPDATE ft SET content='a b c' WHERE rowid=? } 0
69 UPDATE ft SET content = 'a b c' WHERE rowid=old.x;
104 INSERT INTO ft2(rowid, content) VALUES(1, 'a b c');
105 INSERT INTO ft2(rowid, content) VALUES(2, 'a b d');
110 foreach {tn2 sql content} {
[all …]
H A Dfts3ak.test23 CREATE VIRTUAL TABLE t1 USING fts3(content);
24 INSERT INTO t1 (rowid, content) VALUES(1, 'hello world');
25 INSERT INTO t1 (rowid, content) VALUES(2, 'hello there');
26 INSERT INTO t1 (rowid, content) VALUES(3, 'cruel world');
33 INSERT INTO t1 (rowid, content) VALUES(4, 'false world');
34 INSERT INTO t1 (rowid, content) VALUES(5, 'false door');
45 INSERT INTO t1 (rowid, content) VALUES(6, 'another world');
46 INSERT INTO t1 (rowid, content) VALUES(7, 'another test');
57 INSERT INTO t1 (rowid, content) VALUES(8, 'second world');
58 INSERT INTO t1 (rowid, content) VALUES(9, 'second sight');
[all …]
H A Dfts2k.test23 CREATE VIRTUAL TABLE t1 USING fts2(content);
24 INSERT INTO t1 (rowid, content) VALUES(1, "hello world");
25 INSERT INTO t1 (rowid, content) VALUES(2, "hello there");
26 INSERT INTO t1 (rowid, content) VALUES(3, "cruel world");
33 INSERT INTO t1 (rowid, content) VALUES(4, "false world");
34 INSERT INTO t1 (rowid, content) VALUES(5, "false door");
45 INSERT INTO t1 (rowid, content) VALUES(6, "another world");
46 INSERT INTO t1 (rowid, content) VALUES(7, "another test");
57 INSERT INTO t1 (rowid, content) VALUES(8, "second world");
58 INSERT INTO t1 (rowid, content) VALUES(9, "second sight");
[all …]
H A Dfts3ai.test40 CREATE VIRTUAL TABLE t1 USING fts3(content);
48 execsql {INSERT INTO t1 (rowid, content) VALUES(1, 'one')}
49 execsql {SELECT content FROM t1 WHERE rowid = 1}
53 set sql "INSERT INTO t1 (rowid, content) VALUES(2, 'two')"
57 execsql {SELECT content FROM t1 WHERE rowid = 2}
61 set sql "INSERT INTO t1 (rowid, content) VALUES(3, 'three')"
65 set sql "UPDATE t1 SET content = 'trois' WHERE rowid = 3"
69 execsql {SELECT content FROM t1 WHERE rowid = 3}
77 execsql {SELECT content FROM t1 WHERE rowid = 4}
85 set sql "UPDATE t1 SET content = 'cinq' WHERE rowid = 5"
[all …]
H A Dfts1i.test36 CREATE VIRTUAL TABLE t1 USING fts1(content);
44 execsql {INSERT INTO t1 (rowid, content) VALUES(1, 'one')}
45 execsql {SELECT content FROM t1 WHERE rowid = 1}
49 set sql "INSERT INTO t1 (rowid, content) VALUES(2, 'two')"
53 execsql {SELECT content FROM t1 WHERE rowid = 2}
57 set sql "INSERT INTO t1 (rowid, content) VALUES(3, 'three')"
61 set sql "UPDATE t1 SET content = 'trois' WHERE rowid = 3"
65 execsql {SELECT content FROM t1 WHERE rowid = 3}
73 execsql {SELECT content FROM t1 WHERE rowid = 4}
81 set sql "UPDATE t1 SET content = 'cinq' WHERE rowid = 5"
[all …]
H A Dfts2i.test35 CREATE VIRTUAL TABLE t1 USING fts2(content);
43 execsql {INSERT INTO t1 (rowid, content) VALUES(1, 'one')}
44 execsql {SELECT content FROM t1 WHERE rowid = 1}
48 set sql "INSERT INTO t1 (rowid, content) VALUES(2, 'two')"
52 execsql {SELECT content FROM t1 WHERE rowid = 2}
56 set sql "INSERT INTO t1 (rowid, content) VALUES(3, 'three')"
60 set sql "UPDATE t1 SET content = 'trois' WHERE rowid = 3"
64 execsql {SELECT content FROM t1 WHERE rowid = 3}
72 execsql {SELECT content FROM t1 WHERE rowid = 4}
80 set sql "UPDATE t1 SET content = 'cinq' WHERE rowid = 5"
[all …]
H A Dfts3near.test26 CREATE VIRTUAL TABLE t1 USING fts3(content);
27 INSERT INTO t1(content) VALUES('one three four five');
28 INSERT INTO t1(content) VALUES('two three four five');
29 INSERT INTO t1(content) VALUES('one two three four five');
96 INSERT INTO t1(content) VALUES('A X B C D A B');
100 SELECT offsets(t1) FROM t1 WHERE content MATCH 'A NEAR/0 B'
105 SELECT offsets(t1) FROM t1 WHERE content MATCH 'B NEAR/0 A'
120 SELECT offsets(t1) FROM t1 WHERE content MATCH 'A NEAR A'
126 SELECT offsets(t1) FROM t1 WHERE content MATCH 'A NEAR/2 A';
143 INSERT INTO t1(content) VALUES(
[all …]
H A Dfts1j.test27 CREATE VIRTUAL TABLE t3 USING fts1(content);
28 INSERT INTO t3 (rowid, content) VALUES(1, "hello world");
32 CREATE VIRTUAL TABLE t1 USING fts1(content);
33 INSERT INTO t1 (rowid, content) VALUES(1, "hello world");
34 INSERT INTO t1 (rowid, content) VALUES(2, "hello there");
35 INSERT INTO t1 (rowid, content) VALUES(3, "cruel world");
58 CREATE VIRTUAL TABLE two.t2 USING fts1(content);
59 INSERT INTO t2 (rowid, content) VALUES(1, "hello world");
60 INSERT INTO t2 (rowid, content) VALUES(2, "hello there");
61 INSERT INTO t2 (rowid, content) VALUES(3, "cruel world");
[all …]
H A Dfts3aj.test25 CREATE VIRTUAL TABLE t3 USING fts3(content);
26 INSERT INTO t3 (rowid, content) VALUES(1, 'hello world');
30 CREATE VIRTUAL TABLE t1 USING fts3(content);
31 INSERT INTO t1 (rowid, content) VALUES(1, 'hello world');
32 INSERT INTO t1 (rowid, content) VALUES(2, 'hello there');
33 INSERT INTO t1 (rowid, content) VALUES(3, 'cruel world');
56 CREATE VIRTUAL TABLE two.t2 USING fts3(content);
57 INSERT INTO t2 (rowid, content) VALUES(1, 'hello world');
58 INSERT INTO t2 (rowid, content) VALUES(2, 'hello there');
59 INSERT INTO t2 (rowid, content) VALUES(3, 'cruel world');
[all …]
H A Dfts2j.test27 CREATE VIRTUAL TABLE t3 USING fts2(content);
28 INSERT INTO t3 (rowid, content) VALUES(1, "hello world");
32 CREATE VIRTUAL TABLE t1 USING fts2(content);
33 INSERT INTO t1 (rowid, content) VALUES(1, "hello world");
34 INSERT INTO t1 (rowid, content) VALUES(2, "hello there");
35 INSERT INTO t1 (rowid, content) VALUES(3, "cruel world");
58 CREATE VIRTUAL TABLE two.t2 USING fts2(content);
59 INSERT INTO t2 (rowid, content) VALUES(1, "hello world");
60 INSERT INTO t2 (rowid, content) VALUES(2, "hello there");
61 INSERT INTO t2 (rowid, content) VALUES(3, "cruel world");
[all …]
H A Dorderby7.test27 CREATE VIRTUAL TABLE fts USING fts3(content TEXT);
28 INSERT INTO fts(rowid,content)
44 AND content=x
51 AND content=x
58 AND content=x
65 AND content=x
72 AND content=x;
78 AND content=x;
85 AND content=x
92 AND content=x
[all …]
/sqlite-3.40.0/ext/fts3/
H A DREADME.content8 As of SQLite version 3.7.9, FTS4 supports a new option - "content" -
15 managed by the user (an "external content" FTS4 table).
24 documents at all, the content option should be set to an empty string.
28 CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b, c);
73 to the content table does not affect the full-text index. It is the
77 An external content FTS4 table is created by setting the content option
84 CREATE VIRTUAL TABLE t3 USING fts4(content="t2", a, c);
96 CREATE VIRTUAL TABLE t3 USING fts4(content="t2", b, c);
123 -- a row with rowid=3 within the content table.
164 content table, for the same reasons.
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5onepass.test23 CREATE VIRTUAL TABLE ft USING fts5(content);
24 INSERT INTO ft(rowid, content) VALUES(1, '1 2 3');
25 INSERT INTO ft(rowid, content) VALUES(2, '4 5 6');
26 INSERT INTO ft(rowid, content) VALUES(3, '7 8 9');
44 2.1 { UPDATE ft SET content='a b c' } 1
45 2.2 { UPDATE ft SET content='a b c' WHERE rowid=? } 0
46 2.3 { UPDATE ft SET content='a b c' WHERE rowid=? } 0
67 UPDATE ft SET content = 'a b c' WHERE rowid=old.x;
101 CREATE VIRTUAL TABLE ft2 USING fts5(content);
108 foreach {tn2 sql content} {
[all …]
H A Dfts5content.test28 CREATE VIRTUAL TABLE f1 USING fts5(a, b, content='');
102 # External content tables
158 CREATE VIRTUAL TABLE t3 USING fts5(x, content='');
266 } {1 {recursively defined fts5 content table}}
269 } {1 {recursively defined fts5 content table}}
272 } {1 {recursively defined fts5 content table}}
275 } {1 {recursively defined fts5 content table}}
285 } {1 {recursively defined fts5 content table}}
288 } {1 {recursively defined fts5 content table}}
291 } {1 {recursively defined fts5 content table}}
[all …]

1234567