Home
last modified time | relevance | path

Searched refs:abs (Results 1 – 25 of 42) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dtkt2927.test66 SELECT abs(a), abs(b) FROM t1
94 SELECT abs(a), abs(b) FROM t1
122 SELECT abs(a), abs(b) FROM t1
127 SELECT abs(a), abs(b) FROM t1
134 SELECT abs(a), abs(b) FROM t1
141 SELECT abs(a), abs(b) FROM t1
148 SELECT abs(a), abs(b) FROM t1
150 SELECT abs(a), abs(b) FROM t1
183 SELECT abs(a), abs(b) FROM t1
215 SELECT abs(a), abs(b) FROM t1
[all …]
H A Drandexpr1.test263 …abs(case when a>=b then t1.c-case when not exists(select 1 from t1 where case d when +17 then 19+c…
266 …abs(case when a>=b then t1.c-case when not exists(select 1 from t1 where case d when +17 then 19+c…
3209 …abs( -(select ~ -~abs(case ~min((c* -b+c))+min(f) when ~abs(count(distinct 13))+(min(13)) then max…
3212 …abs( -(select ~ -~abs(case ~min((c* -b+c))+min(f) when ~abs(count(distinct 13))+(min(13)) then max…
3215 …abs( -(select ~ -~abs(case ~min((c* -b+c))+min(f) when ~abs(count(distinct 13))+(min(13)) then max…
4625 …CT (abs(19)/abs(coalesce((select max((abs((abs(t1.a)/abs(e)))/abs(b))) from t1 where not t1.f<13 a…
4628 …CT (abs(19)/abs(coalesce((select max((abs((abs(t1.a)/abs(e)))/abs(b))) from t1 where not t1.f<13 a…
4793 …abs((abs(a)/abs(~17+t1.b-e+(abs(a)/abs(coalesce((select max(13) from t1 where c not in (c-(abs(+co…
4796 …abs((abs(a)/abs(~17+t1.b-e+(abs(a)/abs(coalesce((select max(13) from t1 where c not in (c-(abs(+co…
6101 …al {SELECT (abs(t1.e)/abs(coalesce((select +t1.a*c from t1 where (abs(e)/abs(d)) in (select +~coun…
[all …]
H A DvtabE.test44 abs(t3.b + abs(t2.value + abs(t1.value)))
H A Dboundary2.tcl144 if {abs($r)<9.22337203685477580800e+18} {
229 if {abs($r)>9223372036854775808 || [string length $r5]>15} continue
300 if {abs($r)<9.22337203685477580800e+18} {
385 if {abs($r)>9223372036854775808 || [string length $r5]>15} continue
H A Drandexpr1.tcl47 {(abs(EXPR)/abs(EXPR)) (abs(EXPR)/abs(EXPR))}
137 {abs(AGG) abs(AGG)}
H A Dfunc.test150 # Test the abs() and round() functions.
160 catchsql {SELECT abs(a,b) FROM t1}
171 catchsql {SELECT abs(a,b) FROM t1}
175 catchsql {SELECT abs() FROM t1}
179 catchsql {SELECT abs(b) FROM t1 ORDER BY a}
182 catchsql {SELECT abs(c) FROM t1 ORDER BY a}
196 execsql {SELECT abs(a) FROM t2}
199 execsql {SELECT abs(t1) FROM tbl1}
929 # Integer overflow on abs()
934 SELECT abs(-9223372036854775807);
[all …]
H A Dindexexpr2.test242 SELECT * FROM t5 WHERE abs(a)=2 or abs(b)=9;
245 CREATE INDEX t5a ON t5( abs(a) );
246 CREATE INDEX t5b ON t5( abs(b) );
249 SELECT * FROM t5 WHERE abs(a)=2 or abs(b)=9;
H A Doptfuzz-db01.txt17 INSERT INTO t1(a,b,c,d,e) SELECT x,abs(random()%51),
18 abs(random()%100), abs(random()%51), abs(random()%100) FROM c;
86 (SELECT c,d,e FROM t1 WHERE t1.a=abs(t5.a+random()/100)%50+1);
H A Dtrace3.test297 word MATCH (?1) AND abs(?1) = abs(term)
322 word MATCH ('A') AND abs('A') = abs(term)
H A Dboundary1.tcl143 if {abs($r)<9.22337203685477580800e+18} {
228 if {abs($r)>9223372036854775808 || [string length $r5]>15} continue
H A Djoin5.test248 CREATE INDEX t1x1 on t1(abs(aa), abs(bb));
251 WHERE ((abs(aa)=1 AND 1=2) OR abs(aa)=2)
252 AND abs(bb)=3
H A Dcrash.test71 set seed [expr {int(abs(rand()*10000))}]
191 set seed [expr {int(abs(rand()*10000))}]
230 set seed [expr {int(abs(rand()*10000))}]
261 set seed [expr {int(abs(rand()*10000))}]
H A Dexpr.test833 test_expr2 expr-7.64 {b = abs(-2)} {1}
834 test_expr2 expr-7.65 {b = abs(+-2)} {1}
835 test_expr2 expr-7.66 {b = abs(++-2)} {1}
836 test_expr2 expr-7.67 {b = abs(+-+-2)} {1}
837 test_expr2 expr-7.68 {b = abs(+-++-2)} {1}
838 test_expr2 expr-7.69 {b = abs(++++-2)} {1}
839 test_expr2 expr-7.70 {b = 5 - abs(+3)} {1}
840 test_expr2 expr-7.71 {b = 5 - abs(-3)} {1}
842 test_expr2 expr-7.72 {b = abs(-2.0)} {1}
844 test_expr2 expr-7.73 {b = 6 - abs(-a)} {2}
[all …]
H A Dintpkey.test634 CREATE UNIQUE INDEX t17x ON t17(abs(x));
635 DELETE FROM t17 WHERE abs(x) IS NULL OR abs(x)<130;
641 UPDATE t17 SET y='ostrich' WHERE abs(x)=248;
H A DwhereG.test382 CREATE INDEX t1x2 ON t1(abs(a));
383 SELECT typeof(abs(a)) FROM t1 NOT INDEXED;
384 SELECT typeof(abs(a)) FROM t1 INDEXED BY t1x2;
H A Dselect5.test258 CREATE UNIQUE INDEX t1b ON t1(abs(b));
259 SELECT quote(a), quote(b), '|' FROM t1 GROUP BY a, abs(b);
H A Dcoalesce.test60 SELECT coalesce(b,NOT b,-b,abs(b),lower(b),length(b),min(b,5),b*123,c)
H A Dboundary3.tcl160 if {abs($r)<0x7FFFFFFFFFFFFFFF || $r==-9223372036854775808} {
H A Dindexexpr1.test303 CREATE UNIQUE INDEX t9x1 ON t9(c,abs(d),b);
404 CREATE INDEX t1400x ON t1400(abs(15+3));
405 SELECT abs(15+3) IN (SELECT 17 UNION ALL SELECT 18) FROM t1;
H A Ddefault.test125 CREATE TABLE t2(a TEXT, b TEXT DEFAULT(abs(:xyz)));
H A Dcrash4.test68 set seed [expr {int(abs(rand()*10000))}]
H A Dfuzz_common.tcl82 {abs([Expr])} \
H A Dfunc7.test37 SELECT abs(-17.4)
H A Dswarmvtab3.test154 set ctx [expr abs(int(rand() *1000000))]
H A DwhereD.test352 SELECT t1.* FROM t1 LEFT JOIN t2 ON abs(t1.a)=abs(t2.b);

12