Home
last modified time | relevance | path

Searched refs:two (Results 1 – 25 of 428) sorted by relevance

12345678910>>...18

/sqlite-3.40.0/test/
H A Dfts3malloc.test123 {one} {one two} {one three} {one two three}
131 {one} {one two} {one three} {one two three}
171 {two three five} {one two three five}
172 {two three four five} {one two three four five}
176 {two three five} {one two three five}
177 {two three four five} {one two three four five}
192 {one two three} {one two three four}
193 {one two three five} {one two three four five}
197 {two three five} {one two three five}
231 {one two three} {one two three four}
[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}
102 } {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}
[all …]
H A Dfts1a.test33 INSERT INTO t1(content) VALUES('two');
34 INSERT INTO t1(content) VALUES('one two');
37 INSERT INTO t1(content) VALUES('two three');
38 INSERT INTO t1(content) VALUES('one two three');
41 INSERT INTO t1(content) VALUES('two four');
42 INSERT INTO t1(content) VALUES('one two four');
45 INSERT INTO t1(content) VALUES('two three four');
49 INSERT INTO t1(content) VALUES('two five');
50 INSERT INTO t1(content) VALUES('one two five');
53 INSERT INTO t1(content) VALUES('two three 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 Dfts2a.test33 INSERT INTO t1(content) VALUES('two');
34 INSERT INTO t1(content) VALUES('one two');
37 INSERT INTO t1(content) VALUES('two three');
38 INSERT INTO t1(content) VALUES('one two three');
41 INSERT INTO t1(content) VALUES('two four');
42 INSERT INTO t1(content) VALUES('one two four');
45 INSERT INTO t1(content) VALUES('two three four');
49 INSERT INTO t1(content) VALUES('two five');
50 INSERT INTO t1(content) VALUES('one two five');
53 INSERT INTO t1(content) VALUES('two three five');
[all …]
H A Dfts3aa.test34 INSERT INTO t1(content) VALUES('two');
35 INSERT INTO t1(content) VALUES('one two');
38 INSERT INTO t1(content) VALUES('two three');
39 INSERT INTO t1(content) VALUES('one two three');
42 INSERT INTO t1(content) VALUES('two four');
43 INSERT INTO t1(content) VALUES('one two four');
46 INSERT INTO t1(content) VALUES('two three four');
50 INSERT INTO t1(content) VALUES('two five');
51 INSERT INTO t1(content) VALUES('one two five');
58 INSERT INTO t1(content) VALUES('two four five');
[all …]
H A Dfts3snippet.test211 do_snippet_test $T.3.3 two 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]}
491 {five [one] two three [four]}
492 {[four] five [one] two three}
531 } {{[<b>one</b> two three]}}
534 } {{[one <b>two</b> three]}}
[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');
37 {one two} one
38 {one two} three
39 {one two} two
43 SELECT * FROM t1 WHERE t1 MATCH 'two'
46 {one two} two
47 {one two} one
48 {one two} three
[all …]
H A Dfts1j.test42 ATTACH DATABASE 'test2.db' AS two;
44 DETACH DATABASE two;
48 catch {db eval {DETACH DATABASE two}}
57 ATTACH DATABASE 'test2.db' AS two;
58 CREATE VIRTUAL TABLE two.t2 USING fts1(content);
63 DETACH DATABASE two;
66 catch {db eval {DETACH DATABASE two}}
74 ATTACH DATABASE 'test2.db' AS two;
76 CREATE VIRTUAL TABLE two.t3 USING fts1(content);
81 DETACH DATABASE two;
[all …]
H A Dfts3aj.test40 ATTACH DATABASE 'test2.db' AS two;
42 DETACH DATABASE two;
46 catch {db eval {DETACH DATABASE two}}
55 ATTACH DATABASE 'test2.db' AS two;
56 CREATE VIRTUAL TABLE two.t2 USING fts3(content);
61 DETACH DATABASE two;
64 catch {db eval {DETACH DATABASE two}}
72 ATTACH DATABASE 'test2.db' AS two;
74 CREATE VIRTUAL TABLE two.t3 USING fts3(content);
79 DETACH DATABASE two;
[all …]
H A Dfts2j.test42 ATTACH DATABASE 'test2.db' AS two;
44 DETACH DATABASE two;
48 catch {db eval {DETACH DATABASE two}}
57 ATTACH DATABASE 'test2.db' AS two;
58 CREATE VIRTUAL TABLE two.t2 USING fts2(content);
63 DETACH DATABASE two;
66 catch {db eval {DETACH DATABASE two}}
74 ATTACH DATABASE 'test2.db' AS two;
76 CREATE VIRTUAL TABLE two.t3 USING fts2(content);
81 DETACH DATABASE two;
[all …]
H A Dfts1o.test29 INSERT INTO t1(a, b, c) VALUES('one three four', 'one four', 'one four two');
68 INSERT INTO fts_t1(a, b, c) VALUES('one two three', 'one four', 'one two');
89 } {{one three four} {one two three}}
92 } {{one three four} {one four} {one four two}}
104 SELECT a, b, c FROM t1 WHERE c MATCH 'two';
106 } {{one three four} {one four} {one four two} {one two three} {one four} {one two}}
123 execsql { SELECT a, b, c FROM t1 WHERE c MATCH 'two'; }
124 } {{one three four} {one four} {one four two} {one two three} {one four} {one two}}
135 execsql { SELECT a, b, c FROM t1 WHERE c MATCH 'two'; }
136 } {{one three four} {one four} {one four two} {one two three} {one four} {one two}}
H A Dcollate9.test53 INSERT INTO xy VALUES('two', 'two');
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 Dunionvtab.test49 1 one 2 two 3 three
51 20 twenty 21 twenty-one 22 twenty-two
68 } {2 two 10 ten 12 twelve}
81 1 one 2 two 3 three
83 20 twenty 21 twenty-one 22 twenty-two
94 1 one 2 two 3 three
96 20 twenty 21 twenty-one 22 twenty-two
328 INSERT INTO s1 VALUES($S+1, 'two');
416 INSERT INTO c2 VALUES('two', 2);
438 SELECT sum(two) FROM cc;
[all …]
H A Drowvaluefault.test21 CREATE TABLE xyz(one, two, thr, fou);
27 CREATE UNIQUE INDEX xyz_one_two ON xyz(one, two);
31 execsql { SELECT fou FROM xyz WHERE (one, two, thr) = ('B', 'B', 'B') }
37 execsql { SELECT fou FROM xyz WHERE (two, thr) IS ('C', 'C') }
43 execsql { SELECT fou FROM xyz WHERE (one, two, thr) > ('B', 'B', 'B') }
49 execsql { SELECT fou FROM xyz WHERE (one, two) IN (SELECT one, two FROM xyz) }
57 WHERE (one, two, thr) IN (SELECT one, two, thr FROM xyz)
66 WHERE (one, two, thr) BETWEEN ('B', 'B', 'B') AND ('C', 'C', 'C') }
74 WHERE (one, two, thr) IN ( ('a','b','c'), ('A','A','A'), (1,2,3) );
83 WHERE (two, one) IN ( ('a','b','c'), ('A','A','A'), (1,2,3) );
H A Dfts4langid.test255 do_test_query1 2.1.2 {"zero one two"} { rowid_list "zero one two" }
256 do_test_query1 2.1.3 {zero one two} {
271 do_test_query1 2.2.2 {"zero one two"} { rowid_list "zero one two" }
272 do_test_query1 2.2.3 {zero one two} {
275 do_test_query1 2.2.4 {"zero one" OR "one two"} {
287 do_test_query1 2.3.2 {"zero one two"} { rowid_list "zero one two" }
288 do_test_query1 2.3.3 {zero one two} {
313 do_test_query1 3.1.2 {"zero one two"} { rowid_list "zero one two" }
314 do_test_query1 3.1.3 {zero one two} {
335 do_test_query1 3.3.2 {"zero one two"} { rowid_list "zero one two" }
[all …]
H A Dfts2o.test37 } {1 {one <b>four</b> two}}
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}}
119 SELECT a, b, c FROM t1 WHERE c MATCH 'two';
121 } {{one three four} {one four} {one two}}
127 SELECT a, b, c FROM t1 WHERE c MATCH 'two';
129 SELECT a, b, c FROM t1 WHERE c MATCH '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 Dfts1f.test30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
34 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
35 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
40 INSERT INTO t1 (rowid, content) VALUES(10, 'two four');
42 INSERT INTO t1 (rowid, content) VALUES(11, 'one two four');
46 INSERT INTO t1 (rowid, content) VALUES(14, 'two three four');
48 UPDATE t1 SET content = 'update two five' WHERE rowid = 8;
52 INSERT INTO t1 (rowid, content) VALUES(18, 'two five');
53 INSERT INTO t1 (rowid, content) VALUES(19, 'one two five');
[all …]
H A Dfts2f.test30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
34 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
35 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
40 INSERT INTO t1 (rowid, content) VALUES(10, 'two four');
42 INSERT INTO t1 (rowid, content) VALUES(11, 'one two four');
46 INSERT INTO t1 (rowid, content) VALUES(14, 'two three four');
48 UPDATE t1 SET content = 'update two five' WHERE rowid = 8;
52 INSERT INTO t1 (rowid, content) VALUES(18, 'two five');
53 INSERT INTO t1 (rowid, content) VALUES(19, 'one two five');
[all …]
H A Dfts3af.test30 INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31 INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
34 INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
35 INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
40 INSERT INTO t1 (rowid, content) VALUES(10, 'two four');
42 INSERT INTO t1 (rowid, content) VALUES(11, 'one two four');
46 INSERT INTO t1 (rowid, content) VALUES(14, 'two three four');
48 UPDATE t1 SET content = 'update two five' WHERE rowid = 8;
52 INSERT INTO t1 (rowid, content) VALUES(18, 'two five');
53 INSERT INTO t1 (rowid, content) VALUES(19, 'one two five');
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5synonym2.test63 INSERT INTO ss VALUES('3 ix two 9 0 nine i', 'five ii nine two viii i five');
67 INSERT INTO ss VALUES('4 v 7 two 0 one 8', 'vii 1 two five i zero 9');
83 INSERT INTO ss VALUES('five two 4 viii nine', '9 7 nine zero 1 two one');
87 INSERT INTO ss VALUES('two 5 two two ix 4 1', '3 nine ii v nine 3 five');
93 INSERT INTO ss VALUES('0 two two seven ii', 'vii ix four 4 zero vi vi');
107 2.1 "one OR two OR three OR four"
116 2.4 "(one AND two) NOT 6"
118 3.1 "b:one AND a:two"
119 3.2 "b:one OR a:two"
122 4.1 "NEAR(one two, 2)"
[all …]
H A Dfts5synonym.test96 one 1 1 three 1 1 two 1 1
127 one 1 4 three 1 2 two 1 2
139 SELECT rowid FROM ft WHERE ft MATCH 'one two two three';
142 SELECT rowid FROM ft WHERE ft MATCH 'one + two + two + three';
182 2 {5 1 3 4 i} {2 2 v two 4}
188 8 {2 ii i two 3 three 2} {two iv v iii 3 five}
205 8 {2 ii [i] two 3 three 2} {two iv v iii 3 five}
214 8 {2 ii i two 3 three 2} {two [iv] [v] iii 3 [five]}
225 8 {[2] [ii] [i] [two] [3] [three] [2]} {[two] [iv] [v] [iii] [3] [five]}
236 5 {one + two + three} {
[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"}
H A Dfts5vocab2.test28 INSERT INTO t1 VALUES('one two', 'two three');
43 two 1 a 1
44 two 1 b 0
62 two 1 a 1
63 two 1 b 0
94 INSERT INTO t1 VALUES('one two', 'two three');
107 two 1 a {}
108 two 1 b {}
126 two 1 a {}
127 two 1 b {}
[all …]

12345678910>>...18