Home
last modified time | relevance | path

Searched refs:min (Results 1 – 25 of 90) sorted by relevance

1234

/sqlite-3.40.0/test/
H A Dminmax.test53 execsql {SELECT min(x) FROM t1}
68 execsql {SELECT min(x) FROM t1}
107 execsql {SELECT min(a) FROM t2}
209 SELECT min(a) FROM t2 LIMIT 1
229 SELECT min(x) FROM t3 LIMIT 1
260 SELECT min(x) FROM t1;
280 SELECT min(a), max(a) FROM t4;
289 SELECT min(a), max(a) FROM t5;
366 SELECT min(x), max(x) FROM t6;
461 SELECT min(a) FROM t7;
[all …]
H A Dminmax3.test111 count { SELECT min(y) FROM t1; }
114 # Index i1 optimizes the min(y)
116 count { SELECT min(y) FROM t1; }
119 # Index i1 optimizes the min(y)
121 count { SELECT min(y) FROM t1; }
258 SELECT min(x) FROM t4;
263 SELECT min(x COLLATE nocase) FROM t4;
268 SELECT min(x), min(x COLLATE nocase) FROM t4;
273 SELECT min(x COLLATE binary), min(x COLLATE nocase) FROM t4;
278 SELECT min(x COLLATE nocase), min(x COLLATE rtrim) FROM t4;
[all …]
H A Dminmax2.test55 execsql {SELECT min(x) FROM t1}
70 execsql {SELECT min(x) FROM t1}
96 execsql {SELECT min(a) FROM t2}
198 SELECT min(a) FROM t2 LIMIT 1
218 SELECT min(x) FROM t3 LIMIT 1
249 SELECT min(x) FROM t1;
269 SELECT min(a), max(a) FROM t4;
278 SELECT min(a), max(a) FROM t5;
355 SELECT min(x), max(x) FROM t6;
411 SELECT a, min(b+c) FROM t11;
[all …]
H A Dminmax4.test37 SELECT p, min(q) FROM t1;
48 SELECT p, min(q) FROM t1;
59 SELECT p, min(q) FROM t1;
72 SELECT p, min(q) FROM t1;
84 SELECT p, min(q) FROM t1;
95 SELECT p, min(q) FROM t1;
106 SELECT p, min(q) FROM t1;
148 SELECT a, min(b), b, min(c), c FROM t2 GROUP BY a ORDER BY a;
165 SELECT min(a), b FROM t1;
168 SELECT min(a), b FROM t1 WHERE a<50;
[all …]
H A Dpcache.test40 } {current 0 max 0 min 0 recyclable 0}
50 } {current 1 max 12 min 10 recyclable 1}
62 } {current 6 max 12 min 10 recyclable 0}
72 } {current 10 max 12 min 10 recyclable 0}
78 } {current 11 max 22 min 20 recyclable 1}
86 } {current 11 max 22 min 20 recyclable 0}
107 } {current 23 max 22 min 20 recyclable 0}
114 } {current 24 max 22 min 20 recyclable 0}
124 } {current 23 max 22 min 20 recyclable 0}
129 } {current 22 max 22 min 20 recyclable 22}
[all …]
H A Dwindow4.test278 min(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
326 min(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
374 min(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
422 min(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
962 min(c) OVER (PARTITION BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
1200 min(d) OVER win
1289 SELECT id, min(b) OVER (PARTITION BY a ORDER BY id) FROM t7;
1328 SELECT sum( min(t) ) OVER () FROM t8 GROUP BY total;
1336 SELECT sum( min(t) ) OVER () FROM t8;
1350 SELECT (SELECT min(a) OVER ()) FROM t2
[all …]
H A Drandexpr1.test1676 …min(17)+min(13)+min(11))-max(t1.a) then count(distinct -13) else min(t1.c) end-max( - -t1.d)*coun…
3209 …val {SELECT t1.b | (abs( -(select ~ -~abs(case ~min((c* -b+c))+min(f) when ~abs(count(distinct 13)…
3212 …val {SELECT t1.b | (abs( -(select ~ -~abs(case ~min((c* -b+c))+min(f) when ~abs(count(distinct 13)…
3215 …val {SELECT t1.b & (abs( -(select ~ -~abs(case ~min((c* -b+c))+min(f) when ~abs(count(distinct 13)…
3467 …min(t1.f+17+(11-case when b between d and d and t1.a not in (13,c,t1.c) and e< -t1.b then 17+(11) …
3470 …min(t1.f+17+(11-case when b between d and d and t1.a not in (13,c,t1.c) and e< -t1.b then 17+(11) …
3473 …min(t1.f+17+(11-case when b between d and d and t1.a not in (13,c,t1.c) and e< -t1.b then 17+(11) …
3731 …min(t1.f)+case abs((count(distinct 11-t1.a-t1.f)-case ((min(13))) when count(distinct t1.f) then …
3734 …min(t1.f)+case abs((count(distinct 11-t1.a-t1.f)-case ((min(13))) when count(distinct t1.f) then …
5249 …min( -13)+ -count(*)+(count(*)) | ((cast(avg(t1.e) AS integer))) when min(t1.c) then min(t1.d) els…
[all …]
H A Dselect3.test44 SELECT min(n),min(log),max(n),max(log),sum(n),sum(log),avg(n),avg(log)
58 execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
183 ORDER BY max(n+log*2)+0, min(log,avg(n))+0
192 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
197 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
202 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
207 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1 DESC;
213 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log;
218 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log DESC;
223 SELECT log, min(n) FROM t1 GROUP BY log ORDER BY 1;
[all …]
H A Dfilter2.tcl44 SELECT min(b) FILTER (WHERE a>19),
45 min(b) FILTER (WHERE a>0),
52 SELECT min(b),
53 min(b),
62 SELECT min(b) FILTER (WHERE a>19),
63 min(b) FILTER (WHERE a>0),
H A Dfilter2.test53 SELECT min(b) FILTER (WHERE a>19),
54 min(b) FILTER (WHERE a>0),
61 SELECT min(b),
62 min(b),
72 SELECT min(b) FILTER (WHERE a>19),
73 min(b) FILTER (WHERE a>0),
H A Dfunc3.test122 db eval {EXPLAIN SELECT likelihood(min(1.0+'2.0',4*11), 0.5)}
123 } [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}]
153 db eval {EXPLAIN SELECT unlikely(min(1.0+'2.0',4*11))}
154 } [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}]
197 db eval {EXPLAIN SELECT likely(min(1.0+'2.0',4*11))}
198 } [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}]
H A Dauth2.test39 } elseif {$arg2=="min"} {
55 catchsql {SELECT min(a,b,c) FROM t1}
59 } min
62 catchsql {SELECT coalesce(min(a,b,c),999) FROM t1}
66 } {coalesce min}
H A Dselect1.test62 execsql {SELECT *, min(f1,f2), max(f1,f2) FROM test1}
152 } {1 {wrong number of arguments to function min()}}
162 execsql {SELECT coalesce(min(a),'xyzzy') FROM t3}
165 execsql {SELECT min(coalesce(a,'xyzzy')) FROM t3}
168 execsql {SELECT min(b), min(b) FROM t4}
226 } {1 {misuse of aggregate function min()}}
237 SELECT coalesce(min(f1)+5,11) AS m FROM test1
309 } {1 {misuse of aggregate: min()}}
312 } {1 {misuse of aggregate: min()}}
751 coalesce(min(f1/(f1-11),5),'y'),
[all …]
H A Doptfuzz-db01.txt103 SELECT sum(a), avg(b), count(*), min(d), e FROM t1 GROUP BY 5;
105 SELECT sum(a), avg(b), count(*), min(d), e FROM t2 GROUP BY 5
108 SELECT sum(a), avg(b), count(*), min(d), e FROM t3 GROUP BY 5
111 SELECT sum(a), avg(b), count(*), min(d), e FROM t4 GROUP BY 5
112 HAVING min(d)<30 ORDER BY 3, 1;
114 SELECT count(*), min(b), substr(b,1,1), min(a), max(a) FROM t5
H A Dwindow4.tcl188 min(c) OVER ($p2 $o2 $r2)
304 min(d) OVER win
351 SELECT id, min(b) OVER (PARTITION BY a ORDER BY id) FROM t7;
389 SELECT sum( min(t) ) OVER () FROM t8 GROUP BY total;
396 SELECT sum( min(t) ) OVER () FROM t8;
409 SELECT (SELECT min(a) OVER ()) FROM t2
418 (SELECT avg(a) UNION SELECT min(a) OVER ())
H A Dwindow9.test127 SELECT min(a) OVER (),
240 SELECT min( sum(a) ) OVER () FROM t1;
244 SELECT min( sum(a) ) OVER () FROM t1 GROUP BY a;
257 SELECT min( max((SELECT x FROM v1)) ) OVER()
H A Dtkt3541.test25 SELECT CASE ~max(x) WHEN min(x) THEN 1 ELSE max(x) END FROM t1;
30 SELECT CASE NOT max(x) WHEN min(x) THEN 1 ELSE max(x) END FROM t1;
H A Dfts4min.test42 SELECT min(rowid) FROM ft
50 SELECT min(rowid) FROM ft
H A Dclosure01.test144 # depth==5 with min() and max()
146 SELECT count(*), min(id), max(id) FROM cx WHERE root=1 AND depth=5;
157 SELECT count(*), min(id), max(id) FROM below WHERE depth=5;
171 SELECT count(*), min(id), max(id) FROM c2 WHERE root=1;
H A Dmem5.test39 # try with min request size = 2^30
48 # try with min request size = 2^30+1
H A Dwindow8.test3606 min(c) OVER win,
3652 min(c) OVER win,
3700 min(c) OVER win,
3746 min(c) OVER win,
3793 min(c) OVER win,
3838 min(c) OVER win,
3883 min(c) OVER win,
3933 min(c) OVER win,
3979 min(c) OVER win,
4027 min(c) OVER win,
[all …]
H A Dwith2.test53 SELECT min(i)-1 FROM x1 UNION SELECT a+1 FROM i WHERE a<10
173 set ::min [expr 3]
177 VALUES($min) UNION ALL SELECT x+1 FROM i WHERE x < $max
184 VALUES($min) UNION ALL SELECT x+1 FROM i WHERE x < $max
459 SELECT coalesce(miny, min(min(y2),
460 min(y))), coalesce(maxy, max(max(y2),
H A Dview.test325 SELECT min(x), min(a), min(b), min(c), min(a+b+c) FROM v2;
697 CREATE VIEW v16 AS SELECT max(a) AS mx, min(b) AS mn FROM t16 GROUP BY c;
706 WITH v17(x,y) AS (SELECT max(a), min(b) FROM t16 GROUP BY c)
H A Dcollate4.test51 # collate4-4.* simple min() or max() queries.
565 # These tests - collate4-4.* check that min() and max() only ever
568 # CHANGED: min() and max() now use the collation type. If there
587 SELECT min(a) FROM collate4t1
596 SELECT min(a) FROM collate4t1;
611 SELECT min(a) FROM collate4t1;
625 # Also test the scalar min() and max() functions.
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5unicode3.test87 SELECT count(*), min(i) FROM ii WHERE fts5_fold(i)!=CAST(tcl_fold(i) AS int);
96 SELECT count(*), min(i) FROM ii
106 SELECT count(*), min(i) FROM ii
116 SELECT count(*), min(i) FROM ii

1234