Home
last modified time | relevance | path

Searched refs:one (Results 1 – 25 of 619) sorted by relevance

12345678910>>...25

/sqlite-3.40.0/test/
H A Dfts3malloc.test123 {one} {one two} {one three} {one two three}
124 {one four} {one two four} {one three four} {one two three four}
125 {one five} {one two five} {one three five} {one two three five}
131 {one} {one two} {one three} {one two three}
132 {one four} {one two four} {one three four} {one two three four}
133 {one five} {one two five} {one three five} {one two three five}
139 {one two} {one three} {one two three}
140 {one two four} {one three four} {one two three four}
141 {one two five} {one three five} {one two three five}
146 {one two} {one three} {one two three}
[all …]
H A Dfts3expr.test81 } {PHRASE 3 0 one two three}
96 } {PHRASE 3 0 one+ two three}
99 } {PHRASE 3 0 one two+ three}
105 } {PHRASE 3 0 one two three+}
117 test_fts3expr {one* two}
120 test_fts3expr {one two*}
124 test_fts3expr {a:one two}
127 test_fts3expr {one b:two}
130 test_fts3expr {one B:two}
324 } "AND one \u0080wo"
[all …]
H A Dfts1a.test32 INSERT INTO t1(content) VALUES('one');
34 INSERT INTO t1(content) VALUES('one two');
36 INSERT INTO t1(content) VALUES('one three');
38 INSERT INTO t1(content) VALUES('one two three');
40 INSERT INTO t1(content) VALUES('one four');
42 INSERT INTO t1(content) VALUES('one two four');
44 INSERT INTO t1(content) VALUES('one three four');
48 INSERT INTO t1(content) VALUES('one five');
50 INSERT INTO t1(content) VALUES('one two five');
52 INSERT INTO t1(content) VALUES('one three five');
[all …]
H A Dfts2a.test32 INSERT INTO t1(content) VALUES('one');
34 INSERT INTO t1(content) VALUES('one two');
36 INSERT INTO t1(content) VALUES('one three');
38 INSERT INTO t1(content) VALUES('one two three');
40 INSERT INTO t1(content) VALUES('one four');
42 INSERT INTO t1(content) VALUES('one two four');
44 INSERT INTO t1(content) VALUES('one three four');
48 INSERT INTO t1(content) VALUES('one five');
50 INSERT INTO t1(content) VALUES('one two five');
52 INSERT INTO t1(content) VALUES('one three five');
[all …]
H A Dfts3aa.test33 INSERT INTO t1(content) VALUES('one');
35 INSERT INTO t1(content) VALUES('one two');
37 INSERT INTO t1(content) VALUES('one three');
39 INSERT INTO t1(content) VALUES('one two three');
41 INSERT INTO t1(content) VALUES('one four');
43 INSERT INTO t1(content) VALUES('one two four');
45 INSERT INTO t1(content) VALUES('one three four');
49 INSERT INTO t1(content) VALUES('one five');
51 INSERT INTO t1(content) VALUES('one two five');
57 INSERT INTO t1(content) VALUES('one four five');
[all …]
H A DorderbyA.test61 } $match {one 6 three 24 two 15}
64 } $match {two 15 three 24 one 6}
68 } $nomatch {one 6 three 24 two 15}
71 } $nomatch {two 15 three 24 one 6}
75 } $nomatch {one 6 three 24 two 15}
122 } $nSort {{} one 45 {} two 48 1 one 9 1 two 12 2 one 27 2 two 30}
125 } $nSort {2 two 30 2 one 27 1 two 12 1 one 9 {} two 48 {} one 45}
130 } $nSort { {} two 48 {} one 45 1 two 12 1 one 9 2 two 30 2 one 27 }
133 } $nSort { 2 one 27 2 two 30 1 one 9 1 two 12 {} one 45 {} two 48 }
140 } $nSort { {} two 48 {} one 45 1 two 12 1 one 9 2 two 30 2 one 27 }
[all …]
H A Dfts2o.test31 INSERT INTO t1(a, b, c) VALUES('one three four', 'one four', 'one four two');
37 } {1 {one <b>four</b> two}}
42 } {1 {one <b>four</b>}}
85 INSERT INTO fts_t1(a, b, c) VALUES('one two three', 'one four', 'one two');
102 } {{one three four} {one two three}}
105 } {{one three four} {one four} {one four two}}
118 INSERT INTO t1(a, b, c) VALUES('one three four', 'one four', 'one two');
121 } {{one three four} {one four} {one two}}
131 } {{one three four} {one four} {one two} {one three four} {one four} {one two}}
155 } {{one three four} {one four} {one two}}
[all …]
H A Dfts1o.test29 INSERT INTO t1(a, b, c) VALUES('one three four', 'one four', 'one four two');
43 } {1 {one three <b>four</b>}}
58 } {1 {one three <b>four</b>}}
68 INSERT INTO fts_t1(a, b, c) VALUES('one two three', 'one four', 'one two');
82 } {1 {one three <b>four</b>}}
89 } {{one three four} {one two three}}
92 } {{one three four} {one four} {one four two}}
106 } {{one three four} {one four} {one four two} {one two three} {one four} {one two}}
124 } {{one three four} {one four} {one four two} {one two three} {one four} {one two}}
136 } {{one three four} {one four} {one four two} {one two three} {one four} {one two}}
H A Dfts3snippet.test210 do_snippet_test $T.3.2 one 0 5 "{one} two three four five..."
479 {[one] two three [four] five}
480 {two three [four] five [one]}
481 {three [four] five [one] two}
482 {[four] five [one] two three}
483 {five [one] two three [four]}
531 } {{[<b>one</b> two three]}}
534 } {{[one <b>two</b> three]}}
537 } {{[one two <b>three</b>]}}
553 llength [db one {
[all …]
H A Dfts3ao.test33 INSERT INTO t1(a, b, c) VALUES('one three four', 'one four', 'one four two');
39 } {1 {one <b>four</b> two}}
44 } {1 {one <b>four</b>}}
87 INSERT INTO fts_t1(a, b, c) VALUES('one two three', 'one four', 'one two');
104 } {{one three four} {one two three}}
107 } {{one three four} {one four} {one four two}}
120 INSERT INTO t1(a, b, c) VALUES('one three four', 'one four', 'one two');
123 } {{one three four} {one four} {one two}}
133 } {{one three four} {one four} {one two} {one three four} {one four} {one two}}
157 } {{one three four} {one four} {one two}}
[all …]
H A Dfts4langid.test259 do_test_query1 2.1.4 {"zero one" OR "one two"} {
260 or_merge_lists [rowid_list "zero one"] [rowid_list "one two"]
275 do_test_query1 2.2.4 {"zero one" OR "one two"} {
276 or_merge_lists [rowid_list "zero one"] [rowid_list "one two"]
291 do_test_query1 2.3.4 {"zero one" OR "one two"} {
292 or_merge_lists [rowid_list "zero one"] [rowid_list "one two"]
317 do_test_query1 3.1.4 {"zero one" OR "one two"} {
318 or_merge_lists [rowid_list "zero one"] [rowid_list "one two"]
339 do_test_query1 3.3.4 {"zero one" OR "one two"} {
467 INSERT INTO t6(content, lid) VALUES('zero one one', $lid);
[all …]
H A Dorderby1.test53 } {one-a one-c two-a two-b three-a three-c}
71 } {one-a one-c two-a two-b three-a three-c}
90 } {one-a one-c two-a two-b three-a three-c}
106 } {three-a three-c two-a two-b one-a one-c}
123 } {one-c one-a two-b two-a three-c three-a}
141 } {three-c three-a two-b two-a one-c one-a}
190 } {one-a one-c two-a two-b three-a three-c}
205 } {one-a one-c two-a two-b three-a three-c}
220 } {one-a one-c two-a two-b three-a three-c}
239 } {one-a one-c two-a two-b three-a three-c}
[all …]
H A Dfts3rank.test28 INSERT INTO t1 VALUES('one two', 'one');
29 INSERT INTO t1 VALUES('one two', 'three');
30 INSERT INTO t1 VALUES('one two', 'two');
34 SELECT * FROM t1 WHERE t1 MATCH 'one'
37 {one two} one
38 {one two} three
39 {one two} two
46 {one two} two
47 {one two} one
48 {one two} three
[all …]
H A Dfts1b.test30 # converted to "one three" in english.
33 set english {one two three four five}
63 execsql {SELECT rowid FROM t1 WHERE english MATCH 'one'}
66 execsql {SELECT rowid FROM t1 WHERE spanish MATCH 'one'}
69 execsql {SELECT rowid FROM t1 WHERE german MATCH 'one'}
72 execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'one'}
79 } {one un eine}
81 execsql {SELECT rowid FROM t1 WHERE t1 MATCH '"one un"'}
90 } {{one two three} {four five six}}
122 execsql {SELECT rowid FROM t4 WHERE norm MATCH 'one'}
[all …]
H A Dfts3ab.test30 # converted to "one three" in english.
33 set english {one two three four five}
63 execsql {SELECT rowid FROM t1 WHERE english MATCH 'one'}
66 execsql {SELECT rowid FROM t1 WHERE spanish MATCH 'one'}
69 execsql {SELECT rowid FROM t1 WHERE german MATCH 'one'}
72 execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'one'}
79 } {one un eine}
81 execsql {SELECT rowid FROM t1 WHERE t1 MATCH '"one un"'}
90 } {{one two three} {four five six}}
122 execsql {SELECT rowid FROM t4 WHERE norm MATCH 'one'}
[all …]
H A Dfts2b.test30 # converted to "one three" in english.
33 set english {one two three four five}
63 execsql {SELECT rowid FROM t1 WHERE english MATCH 'one'}
66 execsql {SELECT rowid FROM t1 WHERE spanish MATCH 'one'}
69 execsql {SELECT rowid FROM t1 WHERE german MATCH 'one'}
72 execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'one'}
79 } {one un eine}
81 execsql {SELECT rowid FROM t1 WHERE t1 MATCH '"one un"'}
90 } {{one two three} {four five six}}
122 execsql {SELECT rowid FROM t4 WHERE norm MATCH 'one'}
[all …]
H A Dfts1n.test30 INSERT INTO t1(a, b, c) VALUES('one three four', 'one four', 'one two');
33 } {{one three four} {one four} {one two}}
35 # This test was crashing at one point.
43 } {{one three four} {one four} {one two} {one three four} {one four} {one two}}
H A Dfts3corrupt5.test30 INSERT INTO ft VALUES('one', 'one', 'one');
35 SELECT * FROM ft WHERE ft MATCH 'b:one'
36 } {one one one}
44 1 X'00036F6E650901' 'b:one' 1
45 2 X'00036F6E6509010201010201FFFFFF' 'c:one' 1
46 3 X'00036F6E6501' 'b:one' 1
47 4 X'00036F6E650101' 'b:one' 1
48 5 X'00036F6E650100' 'b:one' 0
H A Dunionvtab.test49 1 one 2 two 3 three
51 20 twenty 21 twenty-one 22 twenty-two
81 1 one 2 two 3 three
83 20 twenty 21 twenty-one 22 twenty-two
94 1 one 2 two 3 three
106 20 twenty 21 twenty-one
327 INSERT INTO s1 VALUES($S, 'one');
372 -9223372036854775808 one
415 INSERT INTO c1 VALUES('one', 1);
442 SELECT one FROM cc WHERE one>='seven'
[all …]
H A Dcollate9.test52 INSERT INTO xy VALUES('one', 'one');
61 } {two three one}
66 } {one three two}
71 } {two three one sort}
87 } {two 1 three 1 one 0}
92 } {two 0 three 0 one 1}
102 } {one three two}
107 } {two three one}
112 } {two three one}
123 } {one three two sort}
[all …]
H A Dwhere3.test32 INSERT INTO t1 VALUES(111,'one');
375 INSERT INTO t6w VALUES(1, 'w-one');
379 INSERT INTO t6x VALUES(1, 'x-one');
407 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
413 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
419 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
425 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
431 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
437 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
443 } {1 w-one x-one y-one z-one 9 w-nine x-nine y-nine z-nine}
[all …]
H A Dfts1f.test29 INSERT INTO t1 (rowid, content) VALUES(1, 'one');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
33 INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
35 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
38 UPDATE t1 SET content = 'update one three' WHERE rowid = 1;
39 INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
42 INSERT INTO t1 (rowid, content) VALUES(11, 'one two four');
44 INSERT INTO t1 (rowid, content) VALUES(13, 'one three four');
51 INSERT INTO t1 (rowid, content) VALUES(17, 'one five');
53 INSERT INTO t1 (rowid, content) VALUES(19, 'one two five');
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5synonym2.test74 INSERT INTO ss VALUES('one 0 four ii eight one 3', 'iii eight vi vi vi');
80 INSERT INTO ss VALUES('one v v one viii 3 8', '2 1 3 five iii');
90 INSERT INTO ss VALUES('vi vi iv 3 0 one one', '9 6 eight ix iv');
96 INSERT INTO ss VALUES('eight four nine 8 seven', 'one three i nine iii one');
103 INSERT INTO ss VALUES('5 vii three 9 four', 'three five one 7 2 eight one');
116 2.4 "(one AND two) NOT 6"
118 3.1 "b:one AND a:two"
119 3.2 "b:one OR a:two"
120 3.3 "a:one OR b:1 OR {a b} : i"
122 4.1 "NEAR(one two, 2)"
[all …]
H A Dfts5synonym.test123 INSERT INTO ft VALUES('one one two three');
136 SELECT rowid FROM ft WHERE ft MATCH 'one + one + two + three';
153 2 {one} {"one"|"i"|"1"}
184 4 {ii four 4 one 5 three five} {one 5 1 iii 4 3}
187 7 {ii ii two three 2 5} {iii i ii iii iii one one}
197 1 {one} {
201 4 {ii four 4 [one] 5 three five} {[one] 5 [1] iii 4 3}
204 7 {ii ii two three 2 5} {iii [i] ii iii iii [one] [one]}
232 4 {ii four 4 one 5 three five} {one [5 1] iii 4 3}
237 7 {ii ii two three 2 5} {iii [i ii iii] iii one one}
[all …]
H A Dfts5ea.test40 5 {one AND two} {"one" AND "two"}
41 6 {one+two} {"one" + "two"}
42 7 {one AND two OR three} {("one" AND "two") OR "three"}
43 8 {one OR two AND three} {"one" OR ("two" AND "three")}
44 9 {NEAR(one two)} {NEAR("one" "two", 10)}
45 10 {NEAR("one three"* two, 5)} {NEAR("one" + "three" * "two", 5)}
47 12 "\x20one\x20two\x20three" {"one" AND "two" AND "three"}
48 13 "\x09one\x0Atwo\x0Dthree" {"one" AND "two" AND "three"}
57 2 {c2 : NEAR(one two) c1:"hello world"}
58 {c2 : NEAR("one" "two", 10) AND c1 : "hello" + "world"}

12345678910>>...25