Home
last modified time | relevance | path

Searched refs:l (Results 1 – 25 of 110) sorted by relevance

12345

/sqlite-3.40.0/ext/fts5/test/
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}
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}
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}
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}
72 {l m v l c z j b p b} {z p z f l n k i b a} {j v q k g i x g i b}
76 {w k h d t l j g n n} {r z m v y b l n c u} {v b v s c l n k g v}
78 {v s g x k z a k a r} {l t g v j q l k p l} {f h n a x t v s t y}
81 {d t w n y b o g f o} {d a j e r l g g s h} {d z e l w q l t h f}
82 {f l u w q v x j a h} {f n u l l d m h h w} {d x c c e r o d q j}
92 {l j s g k j k h z l} {p v d a t x d e q u} {r l u z b m g k s j}
[all …]
H A Dfts5ac.test28 0 {p o q e z k z p n f y u z y n y} {l o o l v v k}
29 1 {p k h h p y l l h i p v n} {p p l u r i f a j g e r r x w}
33 5 {k o a w y b s z} {s g l m m l m g p}
55 27 {j l s q u g y v e c l o} {m f l m m m h g x x l n c}
75 47 {w l n l t y x} {n h s l a f c h u f l x x m v n o}
80 52 {f w g r c o d l t u e z h i} {j l l s s b j m}
97 69 {c x f d x o n p o b r t b l p l} {m i t k b x v f p t m l l y r o}
106 78 {c a r k i a p u x} {f w l p t e m l}
119 91 {c b o k l i c b s j n m b l} {y f p q o w g}
167 1.7 "l o o l v v k"
[all …]
H A Dfts5auto.test36 {w r j z n s l} {m j i w d t w e l}
40 {j l} {u v w r s p e l}
79 {z z l f a l g e d c d h} {j b j p k o o u b q}
96 {n q s} {o p z r m l l t}
143 {l d p l b g f} {e k e}
152 {m x a t} {l q x l}
184 {u r x l h} {h r l m r}
188 {l y i q z k j p u f q s k} {c i l l i m a a g a z r x f}
224 {v a z o i e n l x l r} {r u f o r k w m d w}
256 q i r i s j t j u k v k w l x l
[all …]
H A Dfts5unindexed.test28 INSERT INTO t1 VALUES('g h i', 'j k l');
48 do_execsql_test 1.14 { SELECT rowid FROM t1 WHERE t1 MATCH 'l' } {}
53 INSERT INTO t1 VALUES('g h i', 'j k l');
66 INSERT INTO x4 VALUES(20, 'j k l', 'm n o', 'p q r');
72 INSERT INTO t4(t4, rowid, a, b, c) VALUES('delete', 20, 'j k l', '', 'p q r');
H A Dfts5al.test158 INSERT INTO t2 VALUES('r h n t a g r d d i', 'l d n j r c f t o q');
160 INSERT INTO t2 VALUES('h j g t r e l s g s', 'k q k c i i c k n s');
161 INSERT INTO t2 VALUES('b l k h d n n n m i', 'p t i a r b t q o l');
162 INSERT INTO t2 VALUES('k r i l j b g i p a', 't q c h a i m g n l');
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');
164 INSERT INTO t2 VALUES('b o j h f o g b p e', 'r t l h s b g i c p');
H A Dfts5ae.test61 INSERT INTO t2 VALUES('u t l w w m s', 'm f m o l t k o p e');
62 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');
213 {q i b w s a a e l o} {i b z a l f p t e u}
214 {b a z t a l o x d i} {b p a d b f h d w y}
216 {a g i m v a u c b i} {p k s o t l r t b m}
H A Dfts5aa.test160 REPLACE INTO t1(rowid, x, y) VALUES('22', 'l l l', 'l l l');
174 22 {l l l} {l l l}
H A Dfts5bigtok.test20 set L [list a b c d e f g h i j k l m n o p q r s t u v w x y z]
21 set l [lindex $L [expr int(rand() * [llength $L])]]
22 string repeat $l [expr int(rand() * 5) + 60]
/sqlite-3.40.0/test/
H A Danalyze3.test136 unset -nocomplain l
141 set l 200
146 set l 0
171 set l [expr int(200)]
184 set l [expr int(0)]
221 sf_execsql {SELECT typeof($l), typeof($u), sum(y) FROM t2 WHERE x>$l AND x<$u}
224 set l [expr int(12)]
226 sf_execsql {SELECT typeof($l), typeof($u), sum(y) FROM t2 WHERE x>$l AND x<$u}
237 set l [expr int(0)]
276 set l [expr int(200)]
[all …]
H A Dtkt3201.test29 SELECT l.a, r.a FROM t1 AS l, t1 AS r WHERE l.a < r.a;
39 SELECT l.a, r.a FROM t1 AS l, t2 AS r WHERE l.a < r.a;
48 SELECT l.a, r.a FROM t1 AS l, t2 AS r WHERE l.a < r.a;
H A Dfts3conf.test78 2 "INSERT OR ABORT $T1" 0 1 {{a b c d} {e f g h} {i j k l}}
79 3 "INSERT OR FAIL $T1" 0 1 {{a b c d} {e f g h} {i j k l}}
80 4 "INSERT OR IGNORE $T1" 0 0 {{a b c d} {e f g h} {i j k l}}
81 5 "INSERT OR REPLACE $T1" 0 0 {x {e f g h} {i j k l}}
84 7 "INSERT OR ABORT $T2" 1 1 {{a b c d} {e f g h} {i j k l}}
87 10 "INSERT OR REPLACE $T2" 1 0 {{a b c d} y {i j k l} z}
90 12 "UPDATE OR ABORT $T3" 0 1 {{a b c d} {e f g h} {i j k l}}
91 13 "UPDATE OR FAIL $T3" 0 1 {{a b c d} {e f g h} {i j k l}}
92 14 "UPDATE OR IGNORE $T3" 0 0 {{a b c d} {e f g h} {i j k l}}
93 15 "UPDATE OR REPLACE $T3" 0 0 {{a b c d} {i j k l}}
[all …]
H A Dfts4langid.test128 $db eval { CREATE VIRTUAL TABLE t2 USING fts4(x, y, languageid=l) }
150 $db eval { INSERT INTO t2(docid, x, y, l) VALUES($i, $x, $y, $iLangid) }
154 CREATE TABLE data(x, y, l);
155 INSERT INTO data(rowid, x, y, l) SELECT docid, x, y, l FROM t2;
165 db eval {SELECT rowid, x, y FROM data WHERE l = $langid ORDER BY rowid ASC} {
247 execsql {SELECT docid FROM t2 WHERE t2 MATCH $query AND l = $langid}
302 CREATE TABLE t3_data(l, x, y);
303 INSERT INTO t3_data(rowid, l, x, y) SELECT docid, l, x, y FROM t2;
308 CREATE VIRTUAL TABLE t2 USING fts4(content=t3_data, languageid=l);
323 CREATE VIRTUAL TABLE t2 USING fts4(x, y, languageid=l, content=nosuchtable);
[all …]
H A Dshmlock.test140 for {set l $iSlot} {$l<8 && [lindex $L($idx) $l]=="n"} {incr l} {}
141 set n [expr int(rand()*($l-$iSlot))+1]
146 # puts "iSlot=$iSlot l=$l L=$L($idx)"
H A Dfts2.test13 upvar $lvar l
14 set ret [lindex $l 0]
15 set l [lrange $l 1 end]
H A DmallocAll.test12 upvar $lvar l
13 set ret [lindex $l 0]
14 set l [lrange $l 1 end]
H A Dfts2n.test71 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'l*'"
99 execsql "SELECT rowid FROM t1 WHERE t1 MATCH '\"a* l*\"'"
104 execsql "SELECT rowid FROM t1 WHERE t1 MATCH '\"a* l* row\"'"
140 execsql "SELECT rowid FROM t2 WHERE t2 MATCH 'l*'"
181 db eval {SELECT offsets(t3) as o FROM t3 WHERE t3 MATCH 'l*'} {
182 set l [llength $o]
183 lappend t [expr {$l/4}]
H A Dfts3an.test71 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'l*'"
99 execsql "SELECT rowid FROM t1 WHERE t1 MATCH '\"a* l*\"'"
104 execsql "SELECT rowid FROM t1 WHERE t1 MATCH '\"a* l* row\"'"
140 execsql "SELECT rowid FROM t2 WHERE t2 MATCH 'l*'"
181 db eval {SELECT offsets(t3) as o FROM t3 WHERE t3 MATCH 'l*'} {
182 set l [llength $o]
183 lappend t [expr {$l/4}]
H A Dlock6.test57 set l [open log w]
62 puts $l "READ $line"
66 puts $l "WRITE $result"
68 puts $l "WRITE OVER"
76 close $l
H A Dshell7.test32 foreach {tn l x} [db eval { SELECT tn, length(x) AS l, x FROM f1 }] {
40 do_test 1.$tn.1 { file size shell7_test.bin } $l
H A Dwalro.test133 INSERT INTO t1 VALUES('k', 'l');
137 do_test 1.2.8 { sql1 "SELECT * FROM t1" } {a b c d e f g h i j k l}
150 } {0 {a b c d e f g h i j k l}}
169 } {0 {a b c d e f g h i j k l}}
198 } {0 {a b c d e f g h i j k l 1 2 3 4 5 6}}
223 } {0 {a b c d e f g h i j k l 1 2 3 4 5 6}}
H A Dspellfix2.test64 foreach l {a b c d e f g h i j k l m n o p q r s t u v w x y z} {
65 execsql { INSERT INTO demo(word) VALUES ('amsterdam' || $l) }
H A Dfts4merge4.test30 execsql {INSERT INTO t1 VALUES('a b c d e f g h i j k l');}
37 execsql {INSERT INTO t1 VALUES('a b c d e f g h i j k l');}
49 execsql {INSERT INTO t1 VALUES('a b c d e f g h i j k l');}
H A Dfts3matchinfo.test201 l {{5 5} {5 5}}
218 l {{5 5} {5 5}}
306 # + Matchinfo flags 'a', 'l' and 'n' can only be used with fts4, not fts3.
307 # + Matchinfo flag 'l' cannot be used with matchinfo=fts3.
321 SELECT matchinfo(t7, 'l') FROM t7 WHERE t7 MATCH 'x y'
322 } {1 {unrecognized matchinfo request: l}}
328 SELECT matchinfo(t8, 'l') FROM t8 WHERE t8 MATCH 'x y'
329 } {1 {unrecognized matchinfo request: l}}
H A DcorruptK.test124 foreach l [split $hex "\n"] {
125 if {[string is space $l]} continue
127 foreach b [split $l] {
/sqlite-3.40.0/ext/rbu/
H A Drbuvacuum2.test47 INSERT INTO t1 VALUES('l h i', 'd e f');
58 {l h i} {d e f}
85 INSERT INTO t1 VALUES('l h i', 'd e f');
96 {l h i} {d e f}

12345