Lines Matching refs:min
16 # aggregate min() and max() functions and which are handled as
55 execsql {SELECT min(x) FROM t1}
70 execsql {SELECT min(x) FROM t1}
96 execsql {SELECT min(a) FROM t2}
130 SELECT coalesce(min(x+0),-1), coalesce(max(x+0),-1) FROM
149 # Make sure the min(x) and max(x) optimizations work on empty tables
155 SELECT coalesce(min(x),999) FROM t3;
160 SELECT coalesce(min(rowid),999) FROM t3;
179 # Make sure the min(x) and max(x) optimizations work when there
184 SELECT min(a) FROM t2 LIMIT 1
194 SELECT min(a) FROM t2 LIMIT 0,100
204 SELECT min(x) FROM t3 LIMIT 1
218 # Make sure the max(x) and min(x) optimizations work for nested
233 SELECT min(x) FROM t1;
238 SELECT * FROM (SELECT min(x) FROM t1);
242 # Make sure min(x) and max(x) work correctly when the datatype is
251 SELECT min(a), max(a) FROM t4;
260 SELECT min(a), max(a) FROM t5;
264 # Ticket #658: Test the min()/max() optimization when the FROM clause
282 # If there is a NULL in an aggregate max() or min(), ignore it. An
283 # aggregate min() or max() will only return NULL if all values are NULL.
291 SELECT coalesce(min(x),-1) FROM t6;
302 SELECT coalesce(min(x),-1) FROM t6;
323 SELECT (SELECT min(x) FROM t6), (SELECT max(x) FROM t6);
328 SELECT min(x), max(x) FROM t6;
353 SELECT (SELECT min(x) FROM t6), (SELECT max(x) FROM t6);
358 SELECT min(x), max(x) FROM t6;