Home
last modified time | relevance | path

Searched refs:r (Results 1 – 25 of 348) sorted by relevance

12345678910>>...14

/sqlite-3.40.0/test/
H A Dboundary2.test243 SELECT a FROM t1 WHERE r > 16384 ORDER BY r
268 SELECT a FROM t1 WHERE r >= 16384 ORDER BY r
293 SELECT a FROM t1 WHERE r < 16384 ORDER BY r
818 SELECT a FROM t1 WHERE r > 2 ORDER BY r
843 SELECT a FROM t1 WHERE r >= 2 ORDER BY r
868 SELECT a FROM t1 WHERE r < 2 ORDER BY r
893 SELECT a FROM t1 WHERE r <= 2 ORDER BY r
933 SELECT a FROM t1 WHERE r > 4 ORDER BY r
958 SELECT a FROM t1 WHERE r >= 4 ORDER BY r
983 SELECT a FROM t1 WHERE r < 4 ORDER BY r
[all …]
H A Dboundary4.tcl150 lappend ans $r $t1ra($r) $t1rx($r)
157 lappend ans $r $t1ra($r) $t1rx($r)
165 lappend ans $r $a $t1rx($r)
173 lappend ans $r $a $t1rx($r)
181 lappend ans $r $t1ra($r) $x
198 lappend ans $r $t1ra($r) $t1rx($r)
205 lappend ans $r $t1ra($r) $t1rx($r)
247 lappend ans $r $t1ra($r) $t1rx($r)
254 lappend ans $r $t1ra($r) $t1rx($r)
296 lappend ans $r $t1ra($r) $t1rx($r)
[all …]
H A Dwindow3.test381 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
398 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
415 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
432 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
449 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
466 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
483 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
500 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
517 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
534 if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
[all …]
H A Dboundary2.tcl115 foreach r $nums1 {
117 set t1ra($r) $a
118 set t1ar($a) $r
119 set x [format %08x%08x [expr {wide($r)>>32}] $r]
120 set t1rx($r) $x
121 set t1xr($x) $r
141 foreach r $nums3 {
145 set x $t1rx($r)
146 set a $t1ra($r)
297 foreach r $nums3 {
[all …]
H A Dboundary3.test102 CREATE TABLE t2(r,a);
104 CREATE INDEX t2i1 ON t2(r);
140 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
147 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
154 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
206 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
213 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
220 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r
287 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
294 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
[all …]
H A Dboundary1.tcl115 foreach r $nums1 {
117 set t1ra($r) $a
118 set t1ar($a) $r
119 set x [format %08x%08x [expr {wide($r)>>32}] $r]
120 set t1rx($r) $x
121 set t1xr($x) $r
140 foreach r $nums3 {
144 set x $t1rx($r)
145 set a $t1ra($r)
157 puts "\175 {$r $a}"
[all …]
H A Dcursorhint2.test73 t2 {EQ(r[2],c0)}
79 t2 {AND(EQ(r[2],c0),EQ(r[3],10))}
91 t2 {EQ(r[2],c0)} t3 {EQ(r[6],c1)}
98 t2 {EQ(r[2],c0)} t3 {AND(EQ(r[6],c0),EQ(r[7],c1))}
112 x2 {EQ(c0,r[2])}
118 x2 {EQ(c0,r[2])}
124 x2 {EQ(c0,r[2])}
130 x2 {EQ(c0,r[2])}
136 x2 {EQ(c0,r[2])}
145 x2 {EQ(c0,r[2])}
[all …]
H A Dboundary3.tcl114 foreach r $nums1 {
116 set t1ra($r) $a
117 set t1ar($a) $r
119 set t1rx($r) $x
120 set t1xr($x) $r
155 foreach r $nums3 {
161 set x $t1rx($r)
162 set a $t1ra($r)
172 puts "\175 {$r $a}"
177 puts "\175 {$r $x}"
[all …]
H A Dlock.test115 # set r
126 set r
141 set r
154 set r
169 lappend r $msg
191 lappend r $msg
199 lappend r $msg
212 lappend r $msg
225 lappend r $msg
237 lappend r $msg
[all …]
H A Dpg_common.tcl105 foreach r $res {
106 if {$r != ""} { set r [format $F $r] }
107 lappend res2 $r
114 foreach r [db eval {$sql}] {
115 lappend myres [format $F [set r]]
119 foreach r [set myres] r2 [set res2] {
120 if {[set r]<([set r2]-$T) || [set r]>([set r2]+$T)} {
H A Dsort2.test38 WITH r(x,y) AS (
41 SELECT x+1, randomblob(100) FROM r
44 SELECT count(x), length(y) FROM r GROUP BY (x%5)
51 WITH r(x,y) AS (
54 SELECT x+1, randomblob(100) FROM r
56 ) INSERT INTO t1 SELECT * FROM r;
75 WITH r(x,y) AS (
78 SELECT x+1, randomblob(100) FROM r
81 SELECT count(x), length(y) FROM r GROUP BY (x%5)
H A Dselect6.test89 SELECT q, p, r
145 SELECT q, p, r
153 SELECT a.q, a.p, b.r
395 CREATE TABLE t4(q,r);
406 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
417 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
426 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
435 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
438 WHERE e.r=f.z
447 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
[all …]
H A Dspeed1p.explain88 set r [expr {int(rand()*500000)}]
89 set x [number_name $r]
90 lappend list $i $r $x
93 foreach {i r x} $::list {
106 set r [expr {int(rand()*500000)}]
107 set x [number_name $r]
108 lappend list $i $r $x
111 foreach {i r x} $::list {
263 lappend list $i $r
266 foreach {i r} $::list {
[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;
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5ac.test29 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}
37 9 {r k o m c c j s x m x m x m q r} {y r c a q d z k n x n}
46 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}
66 38 {r w t t t t r v v o e p g h} {l w x a g a u h y}
74 46 {f y k l d r q w r s t r e} {h m v r r l r r t f q e x y}
88 60 {f r z v m p k r} {x x r i s b a g f c}
90 62 {n x p r e x q r m v i b y} {f o o z n b s r q j}
108 80 {t i g v y q s r x m r x z e f} {x o j w a u e y s j c b u p p r o}
109 81 {n j n h r l a r e o z w e} {v o r r j a v b}
114 86 {z n a y f b t k k t d b z a v} {r p c n r u k u}
[all …]
H A Dfts5auto.test32 {x c p f w r s m l r b f d} {g g u e}
48 {x n z r c d} {n r x i r}
53 {u o x s d} {f s g r d b d r m m m z y}
56 {} {r r p j k x w q}
63 {o u d n w o m o o s n t r h} {k p e u y p e z d j r y g}
71 {r v i u m q d r} {f z u v h c m r f g}
116 {t g s r w x j l r z r} {h}
117 {r q v x i r a n h s} {m y p b v w r a u o g q r}
131 {m w g x r n e u t s r} {b x a t u u j c r n}
184 {u r x l h} {h r l m r}
[all …]
H A Dfts5ag.test44 {j s m y m r n l u k} {z k f u z g h s w g} {r n o s s b v n w w}
45 {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}
50 {j s w x o t j b t m} {v a v v r t x c q a} {r t k x w u l h a g}
56 {f z k r b u s k z e} {n z v z w l e r h t} {t i s v v a v p n s}
57 {k f e c t z r e f d} {f m g r c w q k b v} {v y s y f r b f e f}
65 {u r e q j y h o o s} {x x z r x y t f j s} {k n h x i i u e c v}
73 {m c i w u z m i s z} {i z r f n l q z k w} {x n b p b q r g i z}
80 {q z l t w o l m p e} {t s g h r p r o t z} {y b f a o n u m z g}
88 {r h u x f c d z n o} {x y l g u m i i w d} {t f h b z v r s r g}
90 {g j t y d c n j y g} {w e s k v c w i g t} {g a h r g v g h r o}
[all …]
/sqlite-3.40.0/ext/misc/
H A Dieee754.c109 double r; in ieee754func() local
123 memcpy(&r, &v, sizeof(r)); in ieee754func()
127 if( r<0.0 ){ in ieee754func()
129 r = -r; in ieee754func()
133 memcpy(&a,&r,sizeof(a)); in ieee754func()
166 double r; in ieee754func() local
209 memcpy(&r, &a, sizeof(r)); in ieee754func()
226 double r; in ieee754func_from_blob() local
233 memcpy(&r, &v, sizeof(r)); in ieee754func_from_blob()
250 memcpy(&v, &r, sizeof(r)); in ieee754func_to_blob()
[all …]
/sqlite-3.40.0/tool/
H A Dspeedtest2.tcl15 set fd [open $sqlfile r]
122 set r [expr {int(rand()*500000)}]
123 puts $fd "INSERT INTO t1 VALUES($i,$r,'[number_name $r]');"
139 set r [expr {int(rand()*500000)}]
140 puts $fd "INSERT INTO t1 VALUES($i,$r,'[number_name $r]');"
156 set r [expr {int(rand()*500000)}]
157 puts $fd "INSERT INTO t1 VALUES($i,$r,'[number_name $r]');"
173 set r [expr {int(rand()*500000)}]
174 puts $fd "INSERT INTO t1 VALUES($i,$r,'[number_name $r]');"
190 set r [expr {int(rand()*500000)}]
[all …]
H A Dspeedtest.tcl15 set fd [open $sqlfile r]
131 set r [expr {int(rand()*100000)}]
132 puts $fd "INSERT INTO t1 VALUES($i,$r,'[number_name $r]');"
143 set r [expr {int(rand()*500000)}]
144 puts $fd "INSERT INTO t2 VALUES($i,$r,'[number_name $r]');"
207 set r [expr {int(rand()*500000)}]
208 puts $fd "UPDATE t2 SET b=$r WHERE a=$i;"
218 set r [expr {int(rand()*500000)}]
219 puts $fd "UPDATE t2 SET c='[number_name $r]' WHERE a=$i;"
262 set r [expr {int(rand()*100000)}]
[all …]
H A Dmkspeedsql.tcl72 set r [expr {int(rand()*500000)}]
73 set x [number_name $r]
75 puts "INSERT INTO t1 VALUES($i,$r,'$x');"
83 set r [expr {int(rand()*500000)}]
84 puts "INSERT INTO t2 VALUES($i,$r,'[number_name $r]');"
143 set r [expr {int(rand()*$nt1c)}]
166 set r [expr {int(rand()*500000)}]
167 puts "UPDATE t1 SET b=$r WHERE a=$i;"
182 set r [expr {int(rand()*500000)}]
183 puts "UPDATE t1 SET c='[number_name $r]' WHERE a=$i;"
/sqlite-3.40.0/src/
H A Ddate.c355 p->s = r; in setRawDateNumber()
357 if( r>=0.0 && r<5373484.5 ){ in setRawDateNumber()
384 double r; in parseDateOrTime() local
392 setRawDateNumber(p, r); in parseDateOrTime()
670 double r; in parseModifier() local
738 if( r>=0.0 && r<464269060800000.0 ){ in parseModifier()
788 && r>=0.0 && r<7.0 && (n=(int)r)==r ){ in parseModifier()
887 && r>-aXformType[i].rLimit && r<aXformType[i].rLimit in parseModifier()
894 p->M += (int)r; in parseModifier()
899 r -= (int)r; in parseModifier()
[all …]
/sqlite-3.40.0/ext/session/
H A Dsession_common.tcl3 set r [list]
4 foreach x $res {lappend r $x}
9 }]] [list $r]
13 set r [list]
14 foreach x $res {lappend r $x}
19 }]] [list $r]
24 set r [list]
25 foreach x $res {lappend r $x}
31 }]] [list $r]
138 set r [list]
[all …]
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A Dlsmtest_util.c22 } r; variable
101 randomBlob(sizeof(r.aRand1), (unsigned char *)r.aRand1); in testPrngInit()
102 randomBlob(sizeof(r.aRand2), (unsigned char *)r.aRand2); in testPrngInit()
103 randomBlob(sizeof(r.aRand3), (unsigned char *)r.aRand3); in testPrngInit()
109 r.aRand1[iVal & 0x000007FF] ^ in testPrngValue()
110 r.aRand2[(iVal>>11) & 0x000007FF] ^ in testPrngValue()
111 r.aRand3[(iVal>>22) & 0x000003FF] in testPrngValue()
/sqlite-3.40.0/ext/wasm/
H A Ddemo-worker1-promiser.js77 const r = ev.result;
78 log('sqlite3.config subset:', r);
79 T.assert('boolean' === typeof r.bigIntEnabled)
80 .assert('string'===typeof r.wasmfsOpfsDir)
81 .assert('boolean' === typeof r.wasmfsOpfsEnabled);
82 sqConfig = r;
91 const r = ev.result;
92 log("then open result",r);
93 T.assert(ev.dbId === r.dbId)
95 .assert('string' === typeof r.vfs);

12345678910>>...14