Home
last modified time | relevance | path

Searched refs:snippet (Results 1 – 25 of 39) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dfts3snippet.test13 # snippet() and matchinfo() work. At time of writing, running this file
194 # Test the snippet function.
451 SELECT length(snippet(ft)), typeof(snippet(ft)) FROM ft;
454 SELECT length(snippet(ft)), typeof(snippet(ft)) FROM ft WHERE rowid = $r;
487 SELECT snippet(t2, '[', ']') FROM t2
513 SELECT snippet(t2, '[', ']') FROM t2
530 SELECT snippet(t3) FROM t3 WHERE t3 MATCH 'one';
533 SELECT snippet(t3) FROM t3 WHERE t3 MATCH 'two';
536 SELECT snippet(t3) FROM t3 WHERE t3 MATCH 'three';
566 # Request a snippet from a query with more than 64 phrases.
[all …]
H A Dfts3query.test159 3 "SELECT snippet(t2, 1, 2, 3, 4, 5, 6) FROM t2 WHERE t2 MATCH 'history'"
160 snippet
167 3 "SELECT snippet(content) FROM t2 WHERE t2 MATCH 'history'" snippet
177 3 "SELECT snippet(content) FROM t2 WHERE t2 MATCH 'history'" snippet
187 # Test the snippet() function with 1 to 6 arguments.
194 1 "SELECT snippet(t3) FROM t3 WHERE t3 MATCH 'gestures'"
197 2 "SELECT snippet(t3, 'XXX') FROM t3 WHERE t3 MATCH 'gestures'"
200 3 "SELECT snippet(t3, 'XXX', 'YYY') FROM t3 WHERE t3 MATCH 'gestures'"
203 4 "SELECT snippet(t3, 'XXX', 'YYY', 'ZZZ') FROM t3 WHERE t3 MATCH 'gestures'"
206 5 "SELECT snippet(t3, 'XXX', 'YYY', 'ZZZ', 1) FROM t3 WHERE t3 MATCH 'gestures'"
[all …]
H A Dfts1d.test36 SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'run jump';
43 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijqrstuvwyxz'
48 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijXXXXqrstuvwyxz'
55 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123789'
60 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123000000789'
H A Dfts2d.test36 SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'run jump';
43 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijqrstuvwyxz'
48 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijXXXXqrstuvwyxz'
55 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123789'
60 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123000000789'
H A Dfts3snippet2.test13 # snippet() and matchinfo() work. At time of writing, running this file
27 # Request a snippet from a query with more than 64 phrases.
36 …SELECT length(snippet(f))>0 FROM f WHERE b MATCH x'1065616e656d655a616c702a2f65732e0f42014001380…
43 …SELECT snippet(t0) FROM t0 WHERE t0 MATCH x'0a4d4d4d4d320a4f52d70a310a310a4e4541520a0a31f6ce0a4f5…
54 SELECT snippet(t0) FROM t0 WHERE t0 MATCH
H A Dfts1m.test12 # of this script is testing the FTS1 module, specifically snippet
36 SELECT rowid, snippet(t1) FROM t1 WHERE c MATCH 'four';
41 SELECT rowid, snippet(t1) FROM t1 WHERE b MATCH 'four';
46 SELECT rowid, snippet(t1) FROM t1 WHERE a MATCH 'four';
H A Dfts3ad.test36 SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'run jump';
43 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijqrstuvwyxz'
48 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijXXXXqrstuvwyxz'
55 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123789'
60 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123000000789'
H A Dfts4record.test63 SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'term*'
77 SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'term*'
97 SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'term*'
113 SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'term*'
H A Dfts2o.test35 SELECT rowid, snippet(t1) FROM t1 WHERE c MATCH 'four';
40 SELECT rowid, snippet(t1) FROM t1 WHERE b MATCH 'four';
45 SELECT rowid, snippet(t1) FROM t1 WHERE a MATCH 'four';
59 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
74 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
94 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
H A Dfts3ao.test37 SELECT rowid, snippet(t1) FROM t1 WHERE c MATCH 'four';
42 SELECT rowid, snippet(t1) FROM t1 WHERE b MATCH 'four';
47 SELECT rowid, snippet(t1) FROM t1 WHERE a MATCH 'four';
61 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
76 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
96 execsql { SELECT rowid, snippet( fts_t1 ) FROM fts_t1 WHERE a MATCH 'four'; }
204 SELECT snippet(t5, '[', ']') FROM t5 WHERE t5 MATCH 'the'
H A Dtkt-bdc6bbbb38.test37 SELECT snippet(t2,'[',']') FROM t2 WHERE t2 MATCH 'a AND d OR b'
50 SELECT snippet(t2,'[',']') FROM t2 WHERE t2 MATCH 'a AND d OR b'
66 SELECT snippet(t3,'[',']') FROM t3 WHERE t3 MATCH 'a AND d OR b'
81 SELECT snippet(t3,'[',']') FROM t3 WHERE t3 MATCH 'a AND d OR b'
H A De_fts3.test430 SELECT snippet(text) FROM text WHERE text MATCH 'cold'
477 # Test that errors in the arguments passed to the snippet and offsets
496 SELECT snippet(a) FROM t1 WHERE a MATCH 'one'
497 } {illegal first argument to snippet}
499 SELECT snippet() FROM t1 WHERE a MATCH 'one'
500 } {unable to use function snippet in the requested context}
503 } {wrong number of arguments to function snippet()}
538 # Test that the snippet function appears to work correctly with 1, 2, 3
547 SELECT snippet(t5) FROM t5 WHERE t5 MATCH 'miles'
550 SELECT snippet(t5, '<i>') FROM t5 WHERE t5 MATCH 'miles'
[all …]
H A Dfts3sort.test70 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\"'"
H A Dfts3defer.test55 4 {SELECT snippet(t1) FROM t1 WHERE t1 MATCH '"a longer phrase"'}
327 SELECT snippet(t1, '[', ']') FROM t1 WHERE t1 MATCH '"zm agmckuiu"'
336 SELECT snippet(t1, '[', ']') FROM t1 WHERE t1 MATCH 'xnxhf jk'
385 # snippet() function with phrase.
387 SELECT snippet(t1, '[', ']') FROM t1 WHERE t1 MATCH '"zm aayxpmve"'
394 # snippet() function with multiple tokens.
396 SELECT snippet(t1, '[', ']') FROM t1 WHERE t1 MATCH 'zm zhbrzadb'
401 # snippet() function with phrase.
408 # snippet() function with multiple tokens.
H A Dfts3defer2.test33 # expressions and the snippet, offsets and matchinfo functions.
65 SELECT snippet(t1, '[', ']'), offsets(t1), mit(matchinfo(t1, 'pcxnal'))
74 SELECT snippet(t1, '[', ']'), offsets(t1), mit(matchinfo(t1, 'pcxnal'))
H A Dfts1o.test42 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
57 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
81 execsql { SELECT rowid AS rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
H A Dfts1k.test44 # The snippet-generation code has calls to isspace() which are sort of
66 execsql {SELECT rowid, length(snippet(t4)) FROM t4 WHERE t4 MATCH 'target'}
H A Dfts2l.test44 # The snippet-generation code has calls to isspace() which are sort of
66 execsql {SELECT rowid, length(snippet(t4)) FROM t4 WHERE t4 MATCH 'target'}
H A Dfts3al.test44 # The snippet-generation code has calls to isspace() which are sort of
70 execsql {SELECT rowid, length(snippet(t4)) FROM t4 WHERE t4 MATCH 'target'}
H A Dfts3first.test97 # Test the snippet() function.
107 SELECT snippet(x1, '[', ']', '...') FROM x1 WHERE x1 MATCH $match
111 SELECT snippet(x2, '[', ']', '...') FROM x2 WHERE x2 MATCH $match
H A Dfts4unicode.test146 foreach {tn query snippet} {
169 execsql { SELECT snippet(t2, '[', ']', '...') FROM t2 WHERE t2 MATCH $q }
170 } [list [mapdoc $snippet]]
183 SELECT snippet(t1, '[', ']') FROM t1 WHERE t1 MATCH 'b'
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5af.test15 # snippet() function.
41 SELECT snippet(t1, -1, '[', ']', '...', 7) FROM t1 WHERE t1 MATCH $v2;
47 SELECT snippet(t1, -1, '[', ']', '...', 7) FROM t1 WHERE t1 MATCH $v2;
53 SELECT snippet(t1, -1, '[', ']', '...', 7) FROM t1 WHERE t1 MATCH $v2
162 SELECT snippet(x1, 1, '[', ']', '...', 5) FROM x1('xyz');
175 SELECT snippet(p1, 0, '[', ']', '...', 6) FROM p1('x');
179 SELECT snippet(p1, 0, '[', ']', NULL, 6) FROM p1('x');
182 SELECT snippet(p1, 0, NULL, ']', '...', 6) FROM p1('x');
185 SELECT snippet(p1, 0, '[', NULL, '...', 6) FROM p1('x');
188 SELECT snippet(p1, 0, '[', NULL, '...', 6) FROM p1('x OR ""');
[all …]
H A Dfts5corrupt4.test51 {SELECT snippet(ttt, -1, '.', '..', '[', ']'), * FROM ttt('e*')}
52 {SELECT snippet(ttt, -1, '.', '..', '[', ']'), * FROM ttt('e* NOT ee*')}
H A Dfts5unicode2.test153 foreach {tn query snippet} {
177 SELECT snippet(t2, -1, '[', ']', '...', 15) FROM t2 WHERE t2 MATCH $q
179 } [list [mapdoc $snippet]]
192 SELECT snippet(t1, -1, '[', ']', '...', 15) FROM t1 WHERE t1 MATCH 'b'
/sqlite-3.40.0/ext/fts1/
H A Dfts1.c2290 if( p->snippet.nMatch ) return; in snippetAllOffsets()
2430 free(pCursor->snippet.zSnippet); in snippetText()
2431 pCursor->snippet.zSnippet = 0; in snippetText()
2432 aMatch = pCursor->snippet.aMatch; in snippetText()
2433 nMatch = pCursor->snippet.nMatch; in snippetText()
2515 pCursor->snippet.zSnippet = sb.s; in snippetText()
2516 pCursor->snippet.nSnippet = sb.len; in snippetText()
2529 snippetClear(&c->snippet); in fulltextClose()
2543 snippetClear(&c->snippet); in fulltextNext()
3258 snippetOffsetText(&pCursor->snippet); in snippetOffsetsFunc()
[all …]

12