Lines Matching refs:min

13 # aggregate min() and max() functions and which are handled as
53   execsql {SELECT min(x) FROM t1}
68   execsql {SELECT min(x) FROM t1}
89   execsql {SELECT min(x) FROM t1 WHERE x=5}
92   execsql {SELECT min(x) FROM t1 WHERE x>=5}
95   execsql {SELECT min(x) FROM t1 WHERE x>=4.5}
98   execsql {SELECT min(x) FROM t1 WHERE x<4.5}
107   execsql {SELECT min(a) FROM t2}
154       SELECT coalesce(min(x+0),-1), coalesce(max(x+0),-1) FROM
174 # Make sure the min(x) and max(x) optimizations work on empty tables
180     SELECT coalesce(min(x),999) FROM t3;
185     SELECT coalesce(min(rowid),999) FROM t3;
204 # Make sure the min(x) and max(x) optimizations work when there
209     SELECT min(a) FROM t2 LIMIT 1
219     SELECT min(a) FROM t2 LIMIT 0,100
229     SELECT min(x) FROM t3 LIMIT 1
243 # Make sure the max(x) and min(x) optimizations work for nested
260     SELECT min(x) FROM t1;
266       SELECT * FROM (SELECT min(x) FROM t1);
271 # Make sure min(x) and max(x) work correctly when the datatype is
280     SELECT min(a), max(a) FROM t4;
289     SELECT min(a), max(a) FROM t5;
293 # Ticket #658:  Test the min()/max() optimization when the FROM clause
318 # If there is a NULL in an aggregate max() or min(), ignore it.  An
319 # aggregate min() or max() will only return NULL if all values are NULL.
327     SELECT coalesce(min(x),-1) FROM t6;
338     SELECT coalesce(min(x),-1) FROM t6;
360       SELECT (SELECT min(x) FROM t6), (SELECT max(x) FROM t6);
366     SELECT min(x), max(x) FROM t6;
392       SELECT (SELECT min(x) FROM t6), (SELECT max(x) FROM t6);
398     SELECT min(x), max(x) FROM t6;
406     SELECT min(x) FROM t1 WHERE y=5;
416     SELECT min(x) FROM t1 WHERE y=6;
426     SELECT min(x) FROM t1 WHERE y=1;
436     SELECT min(x) FROM t1 WHERE y=0;
446     SELECT min(x) FROM t1 WHERE y=5 AND x>=17.5;
461     SELECT min(a) FROM t7;
476     SELECT min(b) FROM t7 WHERE a=5;
486     SELECT min(b) FROM t7 WHERE a=4;
496     SELECT min(c) FROM t7 WHERE a=4 AND b=10;
506     SELECT min(rowid) FROM t7;
516     SELECT min(rowid) FROM t7 WHERE a=3;
526     SELECT min(rowid) FROM t7 WHERE a=3 AND b=5;
536     SELECT min(rowid) FROM t7 WHERE a=3 AND b=5 AND c=1015;
601   SELECT min(b) FROM t1 WHERE a='b'
603   SELECT min(c) FROM t1 WHERE a='b'
607   SELECT a, min(b) FROM t1 WHERE a='b'
609   SELECT a, min(c) FROM t1 WHERE a='b'
631   SELECT min(b), count(b) FROM t1 WHERE a='a';
633   SELECT min(c), count(c) FROM t1 WHERE a='a';
637 # Incorrect result on a min() query after a CREATE INDEX.
642   SELECT min(a) FROM t14 WHERE b='2' AND a>'50';
646   SELECT min(a) FROM t14 WHERE b='2' AND a>'50';