Home
last modified time | relevance | path

Searched refs:max (Results 1 – 25 of 162) sorted by relevance

1234567

/sqlite-3.40.0/test/
H A Dminmax2.test62 execsql {SELECT max(x) FROM t1}
237 SELECT max(x) FROM t1;
288 SELECT max(rowid) FROM t4 UNION SELECT max(rowid) FROM t5
293 SELECT max(yy) FROM (
294 SELECT max(rowid) AS yy FROM t4 UNION SELECT max(rowid) FROM t5
300 SELECT max(yy) FROM (
301 SELECT max(rowid) AS yy FROM t4 EXCEPT SELECT max(rowid) FROM t5
321 SELECT max(x) FROM t6;
332 SELECT max(x) FROM t6;
397 SELECT max(b+c) FROM t11;
[all …]
H A Dminmax.test60 execsql {SELECT max(x) FROM t1}
75 execsql {SELECT max(x) FROM t1}
248 SELECT max(x) FROM t1;
299 SELECT max(rowid) AS yy FROM t4 UNION SELECT max(rowid) FROM t5
304 SELECT max(yy) FROM (
305 SELECT max(rowid) AS yy FROM t4 UNION SELECT max(rowid) FROM t5
311 SELECT max(yy) FROM (
312 SELECT max(rowid) AS yy FROM t4 EXCEPT SELECT max(rowid) FROM t5
332 SELECT max(x) FROM t6;
343 SELECT max(x) FROM t6;
[all …]
H A Drandexpr1.test41 …max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a | d*d)+(ab…
44 …max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a | d*d)+(ab…
47 …max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a & d*d)+(ab…
119 …(~+count(*)+max(e)++abs(cast(avg(~19) AS integer))) then +cast(avg(c) AS integer) else ~ -max(+t1.…
122 …(~+count(*)+max(e)++abs(cast(avg(~19) AS integer))) then +cast(avg(c) AS integer) else ~ -max(+t1.…
125 …(~+count(*)+max(e)++abs(cast(avg(~19) AS integer))) then +cast(avg(c) AS integer) else ~ -max(+t1.…
4220 …max(t1.a) when ~count(distinct d+case -f*t1.d+11 when b then b else b end)-min(c) then case +max(…
4223 …max(t1.a) when ~count(distinct d+case -f*t1.d+11 when b then b else b end)-min(c) then case +max(…
7199 …max( -t1.a))* -case count(*) when case min(c) when max(d) then count(*) else max(17) end-cast(avg(…
7202 …max( -t1.a))* -case count(*) when case min(c) when max(d) then count(*) else max(17) end-cast(avg(…
[all …]
H A Dminmax3.test127 count { SELECT max(y) FROM t1; }
130 # Index i1 optimizes the max(y)
132 count { SELECT max(y) FROM t1; }
135 # Index i1 optimizes the max(y)
138 count { SELECT max(y) FROM t1; }
228 SELECT max(x) FROM t4;
233 SELECT max(x COLLATE nocase) FROM t4;
238 SELECT max(x), max(x COLLATE nocase) FROM t4;
243 SELECT max(x COLLATE binary), max(x COLLATE nocase) FROM t4;
248 SELECT max(x COLLATE nocase), max(x COLLATE rtrim) FROM t4;
[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 Dminmax4.test14 # SELECT p, max(q) FROM t1;
32 SELECT p, max(q) FROM t1;
43 SELECT p, max(q) FROM t1;
54 SELECT p, max(q) FROM t1;
66 SELECT p, max(q) FROM t1;
67 SELECT p FROM (SELECT max(q), p FROM t1);
78 SELECT p, max(q) FROM t1;
79 SELECT p FROM (SELECT max(q), p FROM t1);
90 SELECT p, max(q) FROM t1;
101 SELECT p, max(q) FROM t1;
[all …]
H A Dwindow4.test182 SELECT a, max(a) FILTER (WHERE (a%2)=0) OVER w FROM t5
187 SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 1 PRECEDING AND 2 PRECEDING)
192 SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING)
197 SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 0 PRECEDING AND 0 PRECEDING)
202 SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 2 FOLLOWING AND 1 FOLLOWING)
235 SELECT max(c), max(b) OVER (ORDER BY b) FROM ttt GROUP BY b;
239 SELECT max(b) OVER (ORDER BY max(c)) FROM ttt GROUP BY b;
243 SELECT abs(max(b) OVER (ORDER BY b)) FROM ttt GROUP BY b;
1199 max(d) OVER win,
1332 SELECT sum( max(t) ) OVER () FROM t8 GROUP BY total;
[all …]
H A Dwindowpushd.test76 CREATE VIEW v1 AS SELECT a, c, max(c) OVER (PARTITION BY a) FROM t1;
79 max(c) OVER (PARTITION BY a),
84 max(d) OVER (PARTITION BY b),
180 SELECT x, sum(y) AS s, max(z) AS m
192 SELECT x, sum(y) AS s, max(z) AS m,
193 max( max(z) ) OVER (PARTITION BY sum(y)
207 SELECT x, sum(y) AS s, max(z) AS m,
208 max( max(z) ) OVER (PARTITION BY sum(y)
220 SELECT x, sum(y) AS s, max(z) AS m,
221 max( max(z) ) OVER (PARTITION BY sum(y)
H A Dsqllimits1.test702 set max $::SQLITE_MAX_EXPR_DEPTH
712 set max $::SQLITE_MAX_EXPR_DEPTH
759 for {set max 5} {$max<=$SQLITE_MAX_FUNCTION_ARG} {incr max} {
760 do_test sqllimits1-11.$max.1 {
767 } "0 [expr {$::max - 1}]"
768 do_test sqllimits1-11.$max.2 {
779 do_test sqllimits1-11.$max.2 {
797 set max $::SQLITE_MAX_ATTACHED
807 set max $::SQLITE_MAX_ATTACHED
852 set max $::SQLITE_LIMIT_LIKE_PATTERN
[all …]
H A Dintreal.test35 SELECT max(1.0,intreal(2),3.0), max(1,intreal(2),3);
38 SELECT max(1.0,intreal(4),3.0), max(1,intreal(4),3);
41 SELECT max(1.0,intreal(2),intreal(3),4.0),
42 max(1,intreal(2),intreal(3),4);
45 SELECT max(1.0,intreal(5),intreal(3),4.0),
46 max(1,intreal(5),intreal(3),4);
H A Dsubquery.test323 SELECT max(a), (SELECT d FROM t2 WHERE a=c) FROM t1;
387 SELECT max((SELECT avg(y) FROM t35b)) FROM t35a;
392 SELECT max((SELECT count(y) FROM t35b)) FROM t35a;
397 SELECT max((SELECT count() FROM t35b)) FROM t35a;
402 SELECT max((SELECT count(x) FROM t35b)) FROM t35a;
407 SELECT max((SELECT count(x) FROM t35b)) FROM t35a;
537 SELECT (SELECT max(c7)+c8 FROM t7) FROM t8;
542 SELECT (SELECT c7+max(c8) FROM t8) FROM t7
547 SELECT (SELECT max(c7)+max(c8) FROM t8) FROM t7
552 SELECT (SELECT c8 FROM t8 WHERE rowid=max(c7)) FROM t7
[all …]
H A Dwindow4.tcl102 SELECT a, max(a) FILTER (WHERE (a%2)=0) OVER w FROM t5
107 SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 1 PRECEDING AND 2 PRECEDING)
111 SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING)
115 SELECT a, max(c) OVER (ORDER BY a ROWS BETWEEN 0 PRECEDING AND 0 PRECEDING)
151 SELECT max(c), max(b) OVER (ORDER BY b) FROM ttt GROUP BY b;
155 SELECT max(b) OVER (ORDER BY max(c)) FROM ttt GROUP BY b;
159 SELECT abs(max(b) OVER (ORDER BY b)) FROM ttt GROUP BY b;
187 SELECT max(c) OVER ($p1 $o1 $r1),
303 max(d) OVER win,
392 SELECT sum( max(t) ) OVER () FROM t8 GROUP BY total;
[all …]
H A Dselect3.test44 SELECT min(n),min(log),max(n),max(log),sum(n),sum(log),avg(n),avg(log)
49 execsql {SELECT max(n)/avg(n), max(log)/avg(log) FROM t1}
152 ORDER BY max(n)+0
160 ORDER BY max(n)+0
168 ORDER BY max(n)+0
176 ORDER BY max(n+log*2)+0, avg(n)+0
183 ORDER BY max(n+log*2)+0, min(log,avg(n))+0
328 SELECT max(t1.a),
359 SELECT max(a), val FROM t1 LEFT JOIN (
365 SELECT max(a), val FROM t1 LEFT JOIN (
[all …]
H A Daggnested.test168 (SELECT value1 as xyz, max(x1) AS pqr
174 (SELECT value1 as xyz, max(x1) AS pqr
187 SELECT (SELECT sum(value2=value1) FROM t2), max(value1)
207 SELECT max(value1), (SELECT count(*) FROM t2 WHERE value2=max(value1))
214 SELECT max(value1), (SELECT count(*) FROM t2 WHERE value2=value1)
229 WHERE value1 IN (SELECT max(value1) FROM t1 GROUP BY id1);
235 SELECT max(value1), (SELECT sum(value2=max(value1)) FROM t2)
239 } {1 {misuse of aggregate function max()}}
242 SELECT max(value1), (SELECT sum(value2=value1) FROM t2)
271 SELECT max((SELECT a FROM (SELECT count(*) AS a FROM ty) AS s)) FROM tx;
[all …]
H A Dfilter1.test47 SELECT max(a) FILTER (WHERE (a % 2)==0) FROM t1
97 SELECT sum(a) FILTER (WHERE 1 - max(a) OVER () > 0) FROM t1
98 } {1 {misuse of window function max()}}
111 SELECT b, max(a) FILTER (WHERE b='x') FROM t1;
122 SELECT a, c, max(b) FILTER (WHERE c='x') FROM t2 GROUP BY a;
134 SELECT a, c, max(b) FILTER (WHERE c='x') FROM t2 GROUP BY a;
218 SELECT max(a), max(a) FILTER (WHERE b<12345), b FROM t1;
H A Dfilter2.tcl46 max(a+b) FILTER (WHERE a>19),
47 max(b+a) FILTER (WHERE a BETWEEN 10 AND 40)
54 max(a+b),
55 max(b+a)
64 max(a+b) FILTER (WHERE a>19),
65 max(b+a) FILTER (WHERE a BETWEEN 10 AND 40)
H A Dselect1.test191 execsql {SELECT coalesce(max(a),'xyzzy') FROM t3}
239 HAVING max(m+5)<10
752 coalesce(max(f1/(f1-33),6),'z')
759 SELECT min(1,2,3), -max(1,2,3)
908 SELECT t3.* FROM t3, (SELECT max(a), max(b) FROM t4)
913 SELECT t3.* FROM (SELECT max(a), max(b) FROM t4), t3
918 SELECT * FROM t3, (SELECT max(a), max(b) FROM t4) AS 'tx'
920 } {a 1 b 2 max(a) 3 max(b) 4}
923 SELECT y.*, t3.* FROM t3, (SELECT max(a), max(b) FROM t4) AS y
925 } {max(a) 3 max(b) 4 a 1 b 2}
[all …]
H A Dthread001.test69 (SELECT md5sum(a, b) FROM ab WHERE a < (SELECT max(a) FROM ab)) ==
70 (SELECT b FROM ab WHERE a = (SELECT max(a) FROM ab))
91 (SELECT md5sum(a, b) FROM ab WHERE +a < (SELECT max(a) FROM ab)) ==
92 (SELECT b FROM ab WHERE a = (SELECT max(a) FROM ab))
135 (SELECT md5sum(a, b) FROM ab WHERE +a < (SELECT max(a) FROM ab)) ==
136 (SELECT b FROM ab WHERE a = (SELECT max(a) FROM ab))
H A Dfilter2.test55 max(a+b) FILTER (WHERE a>19),
56 max(b+a) FILTER (WHERE a BETWEEN 10 AND 40)
63 max(a+b),
64 max(b+a)
74 max(a+b) FILTER (WHERE a>19),
75 max(b+a) FILTER (WHERE a BETWEEN 10 AND 40)
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 Dlimit.test117 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
118 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
119 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
120 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
121 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
122 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
123 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
124 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
125 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
137 set max_x_t3 [execsql {SELECT max(x) FROM t3}]
[all …]
H A Dcollate4.test51 # collate4-4.* simple min() or max() queries.
582 SELECT max(a) FROM collate4t1
601 SELECT max(a) FROM collate4t1;
616 SELECT max(a) FROM collate4t1;
625 # Also test the scalar min() and max() functions.
636 SELECT max(a, b) FROM collate4t1;
641 SELECT max(b, a) FROM collate4t1;
646 SELECT max(a, '101') FROM collate4t1;
651 SELECT max('101', a) FROM collate4t1;
656 SELECT max(b, '101') FROM collate4t1;
[all …]
H A Dwindow1.test300 max(b) OVER (ORDER BY c)
306 max(b) OVER win
348 SELECT x, y, max(y) OVER xyz FROM t4
354 SELECT x, y, max(y) OVER xyz FROM t4
364 SELECT x, y, max(y) OVER xyz FROM t4
386 SELECT a, max(d) OVER w1 FROM t1
2012 SELECT max(b) OVER(
2022 SELECT max(b) OVER(
2047 ORDER BY max(b COLLATE nocase)||'';
2054 ORDER BY max(b COLLATE nocase)||'';
[all …]
H A Dinsert2.test165 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y FROM t4;
166 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y FROM t4;
167 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y FROM t4;
168 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y FROM t4;
173 db function max_x_t4 {execsql {SELECT max(x) FROM t4}}
198 INSERT INTO t4 SELECT x+(SELECT max(x)+1 FROM t4),y FROM t4;
H A Dtrace2.test136 "-- SELECT (SELECT max(idx) FROM 'main'.'x1_segdir' WHERE level = ?) + 1"
137 "-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)"
148 "-- SELECT max(level) FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?"
149 "-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)"

1234567