Lines Matching refs:one
29 db one {SELECT fts3_exprtest('simple', $expr, 'a', 'b', 'c')}
80 test_fts3expr {"one two three"}
81 } {PHRASE 3 0 one two three}
83 test_fts3expr {zero "one two three" four}
84 } {AND {AND {PHRASE 3 0 zero} {PHRASE 3 0 one two three}} {PHRASE 3 0 four}}
86 test_fts3expr {zero AND "one two three" four}
87 } {AND {AND {PHRASE 3 0 zero} {PHRASE 3 0 one two three}} {PHRASE 3 0 four}}
89 test_fts3expr {zero "one two three" AND four}
90 } {AND {AND {PHRASE 3 0 zero} {PHRASE 3 0 one two three}} {PHRASE 3 0 four}}
92 test_fts3expr {zero AND "one two three" AND four}
93 } {AND {AND {PHRASE 3 0 zero} {PHRASE 3 0 one two three}} {PHRASE 3 0 four}}
95 test_fts3expr {"one* two three"}
96 } {PHRASE 3 0 one+ two three}
98 test_fts3expr {"one two* three"}
99 } {PHRASE 3 0 one two+ three}
101 test_fts3expr {"one* two* three"}
102 } {PHRASE 3 0 one+ two+ three}
104 test_fts3expr {"one two three*"}
105 } {PHRASE 3 0 one two three+}
107 test_fts3expr {"one* two three*"}
108 } {PHRASE 3 0 one+ two three+}
110 test_fts3expr {"one two* three*"}
111 } {PHRASE 3 0 one two+ three+}
113 test_fts3expr {"one* two* three*"}
114 } {PHRASE 3 0 one+ two+ three+}
117 test_fts3expr {one* two}
118 } {AND {PHRASE 3 0 one+} {PHRASE 3 0 two}}
120 test_fts3expr {one two*}
121 } {AND {PHRASE 3 0 one} {PHRASE 3 0 two+}}
124 test_fts3expr {a:one two}
125 } {AND {PHRASE 0 0 one} {PHRASE 3 0 two}}
127 test_fts3expr {one b:two}
128 } {AND {PHRASE 3 0 one} {PHRASE 1 0 two}}
130 test_fts3expr {one B:two}
131 } {AND {PHRASE 3 0 one} {PHRASE 1 0 two}}
134 test_fts3expr {one AND two AND three AND four AND five}
138 [list AND {PHRASE 3 0 one} {PHRASE 3 0 two}] \
146 test_fts3expr {(one AND two) AND ((three AND four) AND five)}
148 [list AND {PHRASE 3 0 one} {PHRASE 3 0 two}] \
155 test_fts3expr {(one AND two) OR ((three AND four) AND five)}
157 [list AND {PHRASE 3 0 one} {PHRASE 3 0 two}] \
164 test_fts3expr {(one AND two) AND ((three AND four) OR five)}
166 [list AND {PHRASE 3 0 one} {PHRASE 3 0 two}] \
173 test_fts3expr {(one OR two) AND ((three OR four) AND five)}
175 [list OR {PHRASE 3 0 one} {PHRASE 3 0 two}] \
182 test_fts3expr {(one OR two) AND ((three NOT four) AND five)}
184 [list OR {PHRASE 3 0 one} {PHRASE 3 0 two}] \
191 test_fts3expr {(one OR two) NOT ((three OR four) AND five)}
193 [list OR {PHRASE 3 0 one} {PHRASE 3 0 two}] \
200 test_fts3expr {(((((one OR two))))) NOT (((((three OR four))) AND five))}
202 [list OR {PHRASE 3 0 one} {PHRASE 3 0 two}] \
209 test_fts3expr {one NEAR two}
210 } [list NEAR/10 {PHRASE 3 0 one} {PHRASE 3 0 two}]
212 test_fts3expr {(one NEAR two)}
213 } [list NEAR/10 {PHRASE 3 0 one} {PHRASE 3 0 two}]
215 test_fts3expr {((((((one NEAR two))))))}
216 } [list NEAR/10 {PHRASE 3 0 one} {PHRASE 3 0 two}]
218 test_fts3expr {(one NEAR two) OR ((three OR four) AND five)}
220 [list NEAR/10 {PHRASE 3 0 one} {PHRASE 3 0 two}] \
227 test_fts3expr {(one NEAR/321 two) OR ((three OR four) AND five)}
229 [list NEAR/321 {PHRASE 3 0 one} {PHRASE 3 0 two}] \
248 db one {SELECT fts3_exprtest('simple', $expr, 'a', 'b', 'c')}
281 test_fts3expr2 "one AND (two NEAR three)"
282 } {AND one {NEAR/10 two three}}
284 test_fts3expr2 "one (two NEAR three)"
285 } {AND one {NEAR/10 two three}}
287 test_fts3expr2 "(two NEAR three) one"
288 } {AND {NEAR/10 two three} one}
290 test_fts3expr2 "(two NEAR three) AND one"
291 } {AND {NEAR/10 two three} one}
323 test_fts3expr2 "one \u0080wo"
324 } "AND one \u0080wo"
374 catchsql { SELECT * FROM t1 WHERE t1 MATCH 'one (hello world OR) two' }
375 } {1 {malformed MATCH expression: [one (hello world OR) two]}}
377 catchsql { SELECT * FROM t1 WHERE t1 MATCH 'one (OR hello world) two' }
378 } {1 {malformed MATCH expression: [one (OR hello world) two]}}
382 catchsql { SELECT * FROM t1 WHERE t1 MATCH '(hello OR world) NEAR one' }
383 } {1 {malformed MATCH expression: [(hello OR world) NEAR one]}}
385 catchsql { SELECT * FROM t1 WHERE t1 MATCH 'one NEAR (hello OR world)' }
386 } {1 {malformed MATCH expression: [one NEAR (hello OR world)]}}
427 if {$ii & 1} { lappend v one }
435 execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'five four one' ORDER BY rowid}
440 2 "five four NOT one" {24 26 28 30}
442 3 "five AND four OR one"
445 4 "five AND (four OR one)" {17 19 21 23 24 25 26 27 28 29 30 31}
447 5 "five NOT (four OR one)" {16 18 20 22}
449 6 "(five NOT (four OR one)) OR (five AND (four OR one))"
452 7 "(five OR one) AND two AND three" {7 15 22 23 30 31}
454 8 "five OR one AND two AND three"
457 9 "five OR one two three"
460 10 "five OR \"one two three\""
463 11 "one two OR four five NOT three" {3 7 11 15 19 23 24 25 26 27 31}
465 12 "(one two OR four five) NOT three" {3 11 19 24 25 26 27}
467 13 "((((((one two OR four five)))))) NOT three" {3 11 19 24 25 26 27}
477 1 "one -two three" {5 13 21 29}
478 2 "-two one three" {5 13 21 29}
479 3 "one three -two" {5 13 21 29}
480 4 "-one -two three" {4 12 20 28}
481 5 "three -one -two" {4 12 20 28}
482 6 "-one three -two" {4 12 20 28}