Home
last modified time | relevance | path

Searched refs:term (Results 1 – 25 of 102) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Dfts3aux1.test187 SELECT term, documents, occurrences FROM terms_v WHERE term>'brain'
193 SELECT term, documents, occurrences FROM terms_v WHERE +term>'brain'
214 SELECT term, documents, occurrences FROM terms_v WHERE term>='abc'
223 SELECT term, documents, occurrences FROM terms_v WHERE +term>='abc'
255 SELECT term, documents, occurrences FROM terms_v WHERE term<'brain'
285 WHERE rec('cnt', term) AND term BETWEEN 'brags' AND 'brain'
293 WHERE rec('cnt', term) AND +term BETWEEN 'brags' AND 'brain'
299 WHERE rec('cnt', term) AND term BETWEEN 'brags' AND 'brain'
305 WHERE rec('cnt', term) AND +term BETWEEN 'brags' AND 'brain'
311 WHERE rec('cnt', term) AND term > 'brags' AND term < 'brain'
[all …]
H A Dmake-where7.tcl31 set term($expr) $a
36 set term($expr) $x
38 set term($expr) $a
40 set term($expr) {}
71 set term(b<0) {}
73 set term(c<=10) {}
75 set term(d<0.0) {}
76 set term(d>1e10) {}
78 set term($expr) {}
80 set term($expr) {}
[all …]
H A Dfts3aux2.test59 SELECT term, documents, occurrences, languageid
77 FROM terms WHERE languageid=1 AND term='zero'
83 FROM terms WHERE languageid='1' AND term='two'
90 FROM terms WHERE languageid='+1' AND term>'four'
116 FROM terms WHERE languageid=2 AND term='five';
123 FROM terms WHERE term='five' AND languageid=2
130 FROM terms WHERE term>='seven' AND languageid=2
138 FROM terms WHERE term>='e' AND term<'seven' AND languageid=2
154 SELECT term FROM t2 WHERE term=X'625f323334353637383930313233343536373839';
158 SELECT term FROM t2 WHERE term<X'625f003334353637383930313233343536373839';
[all …]
H A Dfts3rnd.test47 # 3. query = "<term> <term>"
48 # 4. query = "<term> <term> <term>"
50 # 6. query = <term> NEAR <term>
51 # 7. query = <term> NEAR/11 <term> NEAR/11 <term>
52 # 8. query = <term> OR <term>
53 # 9. query = <term> NOT <term>
54 # 10. query = <term> AND <term>
55 # 11. query = <term> NEAR <term> OR <term> NEAR <term>
56 # 12. query = <term> NEAR <term> NOT <term> NEAR <term>
57 # 13. query = <term> NEAR <term> AND <term> NEAR <term>
[all …]
H A Dtkt2822.test29 # (1) If the ORDER BY term is an integer constant i, then
32 # (2) If the ORDER BY term is an identifier (not x.y or x.y.z
36 # (3) Evaluate the term as an expression and sort by the
209 # In "ORDER BY +b" the term is now an expression rather than
275 } {1 {1st ORDER BY term out of range - should be between 1 and 25}}
280 } {1 {2nd ORDER BY term out of range - should be between 1 and 25}}
285 } {1 {2nd ORDER BY term out of range - should be between 1 and 25}}
290 } {1 {2nd ORDER BY term out of range - should be between 1 and 25}}
295 } {1 {3rd ORDER BY term out of range - should be between 1 and 25}}
300 } {1 {4th ORDER BY term out of range - should be between 1 and 25}}
[all …]
H A Damatch1.test40 SELECT term FROM t1aux WHERE col=0 ORDER BY 1 LIMIT 5
45 SELECT term FROM t1aux WHERE term>'b' AND col=0 ORDER BY 1 LIMIT 5
50 SELECT term FROM t1aux WHERE term>'b' AND col=0 LIMIT 5
63 INSERT OR IGNORE INTO vocab SELECT term FROM t1aux;
66 vocabulary_word=term,
93 INSERT OR IGNORE INTO vtemp SELECT term FROM t1aux;
H A Dfts2p.test127 # Utility function to check for the expected doclist for the term in
129 proc check_doclist {test level index term doclist} {
131 set ::term $term
136 SELECT dump_doclist(t1, $::term, $::level, $::index) FROM t1 LIMIT 1;
140 proc check_doclist_all {test term doclist} {
141 set ::term $term
144 SELECT dump_doclist(t1, $::term) FROM t1 LIMIT 1;
H A Dfts2h.test21 # Generate a term of len copies of char.
23 for {set term ""} {$len>0} {incr len -1} {
24 append term $char
26 return $term
H A Dfts3prefix.test44 CREATE INDEX temp.idx ON prefixes(term);
50 $db eval { SELECT term, docid, col, pos FROM temp.terms } a {
51 if {[string length $a(term)]<$len} continue
53 set prefix [string range $a(term) 0 [expr $len-1]]
56 term = $prefix AND docid = $a(docid) AND col = $a(col) AND pos = $a(pos)
105 do_execsql_test 1.3.1 { SELECT term FROM p1 } {f m s}
106 do_execsql_test 1.3.2 { SELECT term FROM p2 } {fir mys sql}
107 do_execsql_test 1.3.3 { SELECT term FROM p3 } {firebi sqlite}
109 SELECT term FROM terms;
125 INSERT INTO t1 VALUES('input a term, or series of terms, perhaps');
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 Dfts3_common.tcl223 foreach {pos term dummy} [db one $sql] {
228 if {[string compare $C($iDoc,$iCol,$pos) $term]} {
230 append es "has \"$C($iDoc,$iCol,$pos)\", document has \"$term\""
282 proc fts3_doclist {tbl term where} {
286 foreach doclist $a($term) {
H A Dfts2q.test64 # Utility function to check for the expected doclist for the term in
66 proc check_doclist {test level index term doclist} {
68 set ::term $term
73 SELECT dump_doclist(t1, $::term, $::level, $::index) FROM t1 LIMIT 1;
77 proc check_doclist_all {test term doclist} {
78 set ::term $term
81 SELECT dump_doclist(t1, $::term) FROM t1 LIMIT 1;
H A Dwapp.tcl905 set term [lindex $arglist $i]
906 if {[string match --* $term]} {set term [string range $term 1 end]}
907 switch -glob -- $term {
959 if {[regexp {^.D([^=]+)=(.*)$} $term all var val]} {
964 error "unknown option: $term"
H A Dtrace3.test290 substr(word,1,length(?1)-1) AS term,
297 word MATCH (?1) AND abs(?1) = abs(term)
299 GROUP BY term, langid
315 substr(word,1,length('A')-1) AS term,
322 word MATCH ('A') AND abs('A') = abs(term)
324 GROUP BY term, langid
H A Dhaving.test107 # 1: Test that the optimization is only applied if the GROUP BY term
111 # term.
125 # Test that non-deterministic functions disqualify a term from being
149 # If the term where moved, the query above would return the same
166 # If the HAVING term (0) is moved into the WHERE clause in this case,
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5vocab.test67 0 term {} 0 {} 0
308 SELECT $term, 'one', sum(cont(one, $term)>0), sum(cont(one, $term)) FROM tx
313 SELECT $term, 'two', sum(cont(two, $term)>0), sum(cont(two, $term)) FROM tx
322 do_execsql_test 7.$term.1 {SELECT * FROM txc WHERE term=$term} $resc
323 do_execsql_test 7.$term.2 {SELECT * FROM txr WHERE term=$term} $resr
348 SELECT * FROM txr WHERE term>=$a AND term<=$b
358 SELECT * FROM txc WHERE term>=$a AND term<=$b
368 SELECT * FROM txr WHERE term>$a AND term<$b
378 SELECT * FROM txc WHERE term>$a AND term<$b
389 WHERE txc.term = txc_c.term AND txc.col=txc_c.col;
[all …]
H A Dfts5vocab2.test48 SELECT * FROM v1 WHERE term='three';
112 SELECT * FROM v1 WHERE term='three';
172 SELECT * FROM v1 WHERE term='three';
213 SELECT * FROM v1 WHERE term=='nosuchterm';
220 SELECT * FROM v1 WHERE term=='nosuchterm';
229 SELECT * FROM v1 WHERE term=='nosuchterm';
233 SELECT * FROM v1 WHERE term=='nosuchterm';
H A Dfts5hash.test97 db eval { SELECT term, doc FROM vocab } {
98 set nRow [db one {SELECT count(*) FROM eee WHERE eee MATCH $term}]
100 error "term=$term fts5vocab=$doc cnt=$nRow"
H A Dfts5fault3.test62 # An OOM while flushing an unusually large term to disk.
71 set doc "a long term abcdefghijklmnopqrstuvwxyz "
84 # An OOM while flushing an unusually large term to disk.
/sqlite-3.40.0/ext/fts3/
H A DREADME.syntax80 instance of the term "consultancy". Phrases enclosed in quotes may
89 matches rows that contain either the term "hello", or the term "world",
106 matches all rows that contain the term "SQLite", as well as those that
111 specified term. For example, the following:
116 the term "sqlite". If the '-' character occurs inside a quoted phrase,
118 on a single term. At this time, all Fts3 queries must contain at least
119 one term or phrase that is not preceded by the '-' prefix.
126 of the table contains the term "hello", and that column "col2" of the
127 table contains the term "world". If the table does not contain columns
134 phrase or a term preceded by a '-' operator. A '*' character may be
[all …]
H A Dfts3speed.tcl46 set term ""
48 append term [lindex $chars [expr {int(rand()*[llength $chars])}]]
50 lappend ret $term
/sqlite-3.40.0/ext/fts5/
H A Dfts5_index.c1715 assert( pIter->term.n<=pIter->term.nSpace ); in fts5SegIterLoadTerm()
2601 int nMin = MIN(p1->term.n, p2->term.n); in fts5AssertComparisonResult()
2602 int res = fts5Memcmp(p1->term.p, p2->term.p, nMin); in fts5AssertComparisonResult()
2603 if( res==0 ) res = p1->term.n - p2->term.n; in fts5AssertComparisonResult()
2640 || fts5BufferCompare(&pFirst->term, &p1->term) in fts5AssertMultiIterSetup()
2700 int res = fts5BufferCompare(&p1->term, &p2->term); in fts5MultiIterDoCompare()
3634 *pn = p->term.n; in fts5MultiIterTerm()
4301 Fts5Buffer term; in fts5IndexMergeLevel() local
4360 if( nTerm!=term.n || fts5Memcmp(pTerm, term.p, nTerm) ){ in fts5IndexMergeLevel()
6620 &rc, &s, " term=%.*s", term.n, (const char*)term.p in fts5DecodeFunction()
[all …]
H A Dfts5_vocab.c75 Fts5Buffer term; /* Current value of 'term' column */ member
413 sqlite3Fts5BufferFree(&pCsr->term); in fts5VocabCloseMethod()
436 sqlite3Fts5BufferSet(&rc, &pCsr->term, nTerm, (const u8*)zTerm); in fts5VocabInstanceNewTerm()
511 sqlite3Fts5BufferSet(&rc, &pCsr->term, nTerm, (const u8*)zTerm); in fts5VocabNextMethod()
578 if( nTerm!=pCsr->term.n in fts5VocabNextMethod()
579 || (nTerm>0 && memcmp(zTerm, pCsr->term.p, nTerm)) in fts5VocabNextMethod()
692 pCtx, (const char*)pCsr->term.p, pCsr->term.n, SQLITE_TRANSIENT in fts5VocabColumnMethod()
/sqlite-3.40.0/ext/rtree/
H A Drtree7.test33 foreach term [execsql $sql] {
34 regsub {\.0$} $term {} term
35 lappend out $term
/sqlite-3.40.0/ext/fts2/
H A Dfts2.c4211 if( pWriter->term.nData==0 ){ in interiorWriterAppend()
4255 dataBufferDestroy(&b->term); in interiorWriterDestroy()
4297 block->term.pData, block->term.nData, in interiorWriterRootInfo()
4310 block->term.pData, block->term.nData, iBlockid); in interiorWriterRootInfo()
4372 return pReader->term.nData==0; in interiorReaderAtEnd()
4381 return pReader->term.nData; in interiorReaderTermBytes()
4385 return pReader->term.pData; in interiorReaderTerm()
4404 pReader->term.nData = nPrefix; in interiorReaderStep()
4921 return pReader->term.nData; in leafReaderTermBytes()
4925 return pReader->term.pData; in leafReaderTerm()
[all …]

12345