Home
last modified time | relevance | path

Searched refs:q (Results 1 – 25 of 144) sorted by relevance

123456

/sqlite-3.40.0/ext/fts5/test/
H A Dfts5ac.test46 18 {f l q y q q g e e x j r} {n b r r g e i r t x q k}
62 34 {v y h c q u u s q y x x k s q} {d n r m y k n t i r n w e}
65 37 {k q t i c a q n m v v} {v r z e f m y o}
99 71 {f g q e l n d m z x q} {z s i i i m f w w f n g p e q}
103 75 {p g b i u r b e q d v o a g w m k} {q y z s f q o h}
111 83 {m d g q q b k b w f q q p p} {j m q f b y c i z k y q p l e a}
118 90 {w t d q j g m r f k n} {l e w f w w a l y q k i q t p c t}
122 94 {s f e a e t i h h d q p z t q} {b k m k w h c}
164 1.4 "b q"
166 1.6 "m d g q q b k b w f q q p p"
[all …]
H A Dfts5auto.test29 {a o q v e n q r} {q v g u c y a z y}
39 {j} {q l w u k e q v r i}
41 {p i k j k q c t g u s} {g u y s m h q k g t e s o r}
51 {e u t q v z q k j p u f j p} {y c b}
64 {v b b h d d q y j q j} {a m w d t}
87 {q v q j w y y x u t} {r q z n h a b o}
91 {n j j u q d o a u c f} {r d b w o q n g}
100 {i c x q w g v o x z i z p} {q o g k i n z x e d v w v}
111 {s o o s d s k q b f q v p e} {j r o b t o p d l o o x}
117 {r q v x i r a n h s} {m y p b v w r a u o g q r}
[all …]
H A Dfts5ag.test45 {m v g n d x q r r s} {q t d a q a v l h j} {s k l f s i n v q v}
46 {m f f d h h s o h a} {y e v r q i u m h d} {b c k q m z l z h n}
49 {k d g o u j p z n o} {t g e q l z i g b j} {f i q q j y h b g h}
52 {b c k s c w j p w b} {m o c o w o b d q q} {n t y o y z y r z e}
53 {p n q l e l h z q c} {n s e i h c v b b u} {m p d i t a o o f f}
58 {z r c t d q q h x b} {u c g z n z u v s s} {y t n f f x b f d x}
60 {h o q w t f v i c y} {c q u n r z s l l q} {z x a q w s b w s y}
66 {q l f d a p w l q o} {y z q w j o p b o v} {s u h z h f d f n l}
67 {q o e o x x l g q i} {j g m h q q w c d b} {o m d h w a g b f n}
70 {x v b l m t l m h l} {t p y i y i q b q a} {k o o z w a c h c f}
[all …]
H A Dfts5al.test89 INSERT INTO t1 VALUES('q w e r t y');
90 INSERT INTO t1 VALUES('y t r e w q');
97 SELECT argtest(t1, 123) FROM t1 WHERE t1 MATCH 'q'
108 SELECT rowidtest(t1) FROM t1 WHERE t1 MATCH 'q'
121 SELECT insttest(t1) FROM t1 WHERE t1 MATCH 'q'
142 SELECT coltest(t1) FROM t1 WHERE t1 MATCH 'q'
144 {6 {q w e r t y}}
145 {6 {y t r e w q}}
163 INSERT INTO t2 VALUES('a e c q n m o m d g', 'l c t g i s q g q e');
165 INSERT INTO t2 VALUES('s q k f q b j g h f', 'n m a o p e i e k t');
[all …]
H A Dfts5ah.test94 foreach {tn q res} "
107 set n [execsql_reads $q]
113 set n [execsql_reads "$q ORDER BY rowid DESC"]
118 do_execsql_test 1.6.$tn.3 $q [lsort -int -incr $res]
119 do_execsql_test 1.6.$tn.4 "$q ORDER BY rowid DESC" [lsort -int -decr $res]
138 set q "SELECT rowid FROM t1 WHERE t1 MATCH 'x' AND $tail"
139 set n [execsql_reads $q]
140 set ret [llength [execsql $q]]
151 set q "SELECT rowid FROM t1 WHERE t1 MATCH 'x' AND $tail ORDER BY rowid DESC"
152 set n [execsql_reads $q]
[all …]
H A Dfts5ae.test62 INSERT INTO t2 VALUES('f g q e l n d m z x q', 'z s i i i m f w w f n g p');
75 WHERE t2 MATCH 'u OR q' ORDER BY rowid;
213 {q i b w s a a e l o} {i b z a l f p t e u}
224 foreach {tn q res} {
233 SELECT fts5_test_queryphrase(t7) FROM t7 WHERE t7 MATCH $q LIMIT 1
265 foreach {tn q res} {
274 SELECT rowid FROM t8 WHERE t8 MATCH $q ORDER BY bm25(t8);
278 SELECT rowid FROM t8 WHERE t8 MATCH $q ORDER BY +rank;
282 SELECT rowid FROM t8 WHERE t8 MATCH $q ORDER BY rank;
298 foreach {tn q cnt} {
[all …]
H A Dfts5umlaut.test32 foreach {tn q res1 res2} {
44 SELECT count(*) FROM t1($q)
48 INSERT INTO t1(rowid, x) VALUES (1, $q);
55 SELECT count(*) FROM t2($q)
59 INSERT INTO t2(rowid, x) VALUES (1, $q);
H A Dfts5synonym.test196 foreach {tn q res} {
246 if {![fts5_expr_ok $q t1]} continue
249 FROM t1 WHERE t1 MATCH $q
264 foreach {tn q res} {
299 if {[fts5_expr_ok "NEAR(y q)" t1]} {
324 foreach {tn q res} {
332 2 {a AND q} {
337 3 {o OR (q AND a)} {
345 4 {NEAR(q y, 20)} {
350 if {![fts5_expr_ok $q t2]} continue
[all …]
/sqlite-3.40.0/test/
H A Dthreadtest5.c127 if( sqlite3_step(q)==SQLITE_ROW && sqlite3_column_int(q,0)!=0 ){ in waitOnTable()
130 sqlite3_finalize(q); in waitOnTable()
249 sqlite3_stmt *q; in main() local
309 q = prepare(db, "MAIN", __LINE__, in main()
315 sqlite3_finalize(q); in main()
318 if( sqlite3_step(q)!=SQLITE_ROW || sqlite3_column_int(q,0)<10 ){ in main()
322 sqlite3_finalize(q); in main()
324 if( sqlite3_step(q)==SQLITE_ROW ){ in main()
328 sqlite3_finalize(q); in main()
330 if( sqlite3_step(q)==SQLITE_ROW ){ in main()
[all …]
H A Dminmax4.test14 # SELECT p, max(q) FROM t1;
17 # the maximum q.
31 CREATE TABLE t1(p,q);
32 SELECT p, max(q) FROM t1;
37 SELECT p, min(q) FROM t1;
43 SELECT p, max(q) FROM t1;
48 SELECT p, min(q) FROM t1;
54 SELECT p, max(q) FROM t1;
59 SELECT p, min(q) FROM t1;
66 SELECT p, max(q) FROM t1;
[all …]
H A Dselect6.test89 SELECT q, p, r
92 WHERE q=s ORDER BY s
100 WHERE q=s ORDER BY s
145 SELECT q, p, r
148 WHERE q=s ORDER BY s
153 SELECT a.q, a.p, b.r
154 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
156 WHERE a.q=b.s ORDER BY a.q
169 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
171 WHERE a.q=b.s ORDER BY a.q)
[all …]
H A Ddelete2.test43 CREATE TABLE q(s string, id string, constraint pk_q primary key(id));
45 INSERT INTO q(s,id) VALUES('hello','id.1');
46 INSERT INTO q(s,id) VALUES('goodbye','id.2');
47 INSERT INTO q(s,id) VALUES('again','id.3');
49 SELECT * FROM q;
54 SELECT * FROM q WHERE id='id.1';
63 set STMT [sqlite3_prepare $DB {SELECT * FROM q} -1 TAIL]
73 DELETE FROM q WHERE rowid=1
79 SELECT * FROM q;
89 DELETE FROM q WHERE rowid=1
[all …]
H A Dbackcompat.test329 foreach {n q} {
336 do_test backcompat-3.2 [list sql1 $q] [sql2 $q]
350 foreach {n q} {
357 do_test backcompat-3.4 [list sql1 $q] [sql2 $q]
366 foreach {n q} {
377 do_test backcompat-3.5 [list sql1 $q] [sql2 $q]
384 foreach {n q} {
395 do_test backcompat-3.7 [list sql1 $q] [sql2 $q]
501 do_test backcompat-4.2.$n [list sql1 $q] [sql2 $q]
509 do_test backcompat-4.4.$n [list sql1 $q] [sql2 $q]
[all …]
H A Dskipscan5.test41 foreach {tn q res} {
61 set sql "EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE $q"
91 set vocab(c) { a b c d e f g h i j k l m n o p q r s t }
105 foreach {tn2 q res} {
108 3 { c > 'q' } {/*ANY(a) AND ANY(b) AND c>?*/}
110 5 { c < 'q' } {/*SCAN t2*/}
113 set sql "EXPLAIN QUERY PLAN SELECT * FROM t2 WHERE $q"
170 foreach {tn q res} {
178 set sql "EXPLAIN QUERY PLAN SELECT * FROM t3 WHERE $q"
H A Dfts4aa.test55 foreach q $::fts4aa_queries {
56 set r [db eval {SELECT docid FROM t1 WHERE words MATCH $q ORDER BY docid}]
57 set ::fts4aa_res($q) $r
142 foreach {q r} [array get fts4aa_res] {
145 db eval {SELECT docid FROM t1 WHERE words MATCH $::q ORDER BY docid}
163 foreach {q r} [array get fts4aa_res] {
166 db eval {SELECT docid FROM t1 WHERE words MATCH $::q ORDER BY docid}
187 foreach {q r} [array get fts4aa_res] {
190 db eval {SELECT docid FROM t1 WHERE words MATCH $::q ORDER BY docid}
199 CREATE VIRTUAL TABLE t1 USING fts4(a, b, c, d, e,f,g,h,i,j,k,l,m,n,o,p,q,r);
H A Dfts4umlaut.test32 foreach {tn q res1 res2} {
44 SELECT count(*) FROM t1 WHERE t1 MATCH $q
48 INSERT INTO t1(rowid, x) VALUES (1, $q);
55 SELECT count(*) FROM t2 WHERE t2 MATCH $q
59 INSERT INTO t2(rowid, x) VALUES (1, $q);
H A De_update.test514 CREATE TABLE t7(q, r, s);
532 1 "UPDATE t7 SET s = q LIMIT 5" {1 2 3 4 5 X X X X X}
540 1 "UPDATE t7 SET s = q LIMIT -1" {1 2 3 4 5 6 7 8 9 10}
541 2 "UPDATE t7 SET s = r WHERE q>4 LIMIT -1"
554 3 "UPDATE t7 SET s = q ORDER BY q DESC LIMIT 5" {X two three 4 5 6 7 8 9 10}
565 1 "UPDATE t7 SET s = q ORDER BY q LIMIT 3 OFFSET 2" {X X 3 4 5 X X X X X}
566 2 "UPDATE t7 SET s = q ORDER BY q DESC LIMIT 2, 3 " {X X 3 4 5 6 7 8 X X}
580 1 "UPDATE t7 SET s = q LIMIT 4, 2" {X X X X 5 6 X X X X}
581 2 "UPDATE t7 SET s = q LIMIT 2 OFFSET 7" {X X X X 5 6 X 8 9 X}
592 INSERT INTO t8 VALUES(old.q);
[all …]
H A Dbestindex5.test82 set q [lindex $args 1]
86 set q [string map [list %$v% '$val'] $q]
88 if {$q==""} { set q 1 }
89 lappend ::xFilterQueries "WHERE $q"
90 return [list sql "SELECT rowid, * FROM t1x WHERE $q"]
/sqlite-3.40.0/ext/fts1/
H A Dfulltext.c62 while( (*q & 0x80) == 0x80 ){ in getVarint()
63 x += y * (*q++ & 0x7f); in getVarint()
70 x += y * (*q++); in getVarint()
1134 ++q->nTerms; in query_add()
1135 q->pTerm = realloc(q->pTerm, q->nTerms * sizeof(q->pTerm[0])); in query_add()
1136 t = &q->pTerm[q->nTerms - 1]; in query_add()
1146 free(q->pTerm); in query_free()
1207 Query q; in fulltext_query() local
1220 int need_positions = i<q.nTerms-1 && !q.pTerm[i+1].is_phrase; in fulltext_query()
1222 if( q.pTerm[i].is_phrase ){ in fulltext_query()
[all …]
H A Dfts1.c140 x += y * (*q++); in getVarint()
2161 free(q->pTerms); in queryClear()
2162 memset(q, 0, sizeof(*q)); in queryClear()
2292 pFts = p->q.pFts; in snippetAllOffsets()
2528 queryClear(&c->q); in fulltextClose()
2623 ++q->nTerms; in queryAdd()
2624 q->pTerms = realloc(q->pTerms, q->nTerms * sizeof(q->pTerms[0])); in queryAdd()
2626 q->nTerms = 0; in queryAdd()
2629 t = &q->pTerms[q->nTerms - 1]; in queryAdd()
2636 q->nextIsOr = 0; in queryAdd()
[all …]
/sqlite-3.40.0/src/
H A Dtest_hexio.c329 const unsigned char *q = (const unsigned char *) p; in getFts3Varint() local
331 while( (*q & 0x80) == 0x80 ){ in getFts3Varint()
332 x += y * (*q++ & 0x7f); in getFts3Varint()
335 x += y * (*q++); in getFts3Varint()
337 return (int) (q - (unsigned char *)p); in getFts3Varint()
341 unsigned char *q = (unsigned char *) p; in putFts3Varint() local
344 *q++ = (unsigned char) ((vu & 0x7f) | 0x80); in putFts3Varint()
347 q[-1] &= 0x7f; /* turn off high bit in final byte */ in putFts3Varint()
348 assert( q - (unsigned char *)p <= 10 ); in putFts3Varint()
349 return (int) (q - (unsigned char *)p); in putFts3Varint()
H A Dtest_bestindex.c127 char q = z[0]; in tclDequote() local
130 if( q=='[' || q=='\'' || q=='"' || q=='`' ){ in tclDequote()
133 if( q=='[' ) q = ']'; in tclDequote()
136 if( z[iIn]==q ){ in tclDequote()
137 if( z[iIn+1]!=q ){ in tclDequote()
146 z[iOut++] = q; in tclDequote()
/sqlite-3.40.0/ext/fts5/
H A Dfts5_test_tok.c82 char q = z[0]; in fts5tokDequote() local
84 if( q=='[' || q=='\'' || q=='"' || q=='`' ){ in fts5tokDequote()
87 if( q=='[' ) q = ']'; in fts5tokDequote()
90 if( z[iIn]==q ){ in fts5tokDequote()
91 if( z[iIn+1]!=q ){ in fts5tokDequote()
100 z[iOut++] = q; in fts5tokDequote()
H A Dfts5_config.c144 char q; in fts5Dequote() local
147 q = z[0]; in fts5Dequote()
150 assert( q=='[' || q=='\'' || q=='"' || q=='`' ); in fts5Dequote()
151 if( q=='[' ) q = ']'; in fts5Dequote()
154 if( z[iIn]==q ){ in fts5Dequote()
155 if( z[iIn+1]!=q ){ in fts5Dequote()
164 z[iOut++] = q; in fts5Dequote()
/sqlite-3.40.0/ext/wasm/
H A Ddemo-123.js87 let q = db.prepare([
95 q.bind( [i, i*2] ).step();
96 q.reset();
100 q.bind(1, i).bind(2, i*2).stepReset();
103 q.finalize();

123456