Lines Matching refs:min

62   execsql {SELECT *, min(f1,f2), max(f1,f2) FROM test1}
93   execsql {SELECT max(test1.f1,test2.r1), min(test1.f2,test2.r2)
97   execsql {SELECT min(test1.f1,test2.r1), max(test1.f2,test2.r2)
150   set v [catch {execsql {SELECT min(*) FROM test1}} msg]
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}
220   set v [catch {execsql {SELECT SUM(min(f1,f2)) FROM test1}} msg]
224   set v [catch {execsql {SELECT SUM(min(f1)) FROM test1}} msg]
226 } {1 {misuse of aggregate function min()}}
232      SELECT min(f1) AS m FROM test1 GROUP BY f1 HAVING max(m+5)<10
237      SELECT coalesce(min(f1)+5,11) AS m FROM test1
280   set v [catch {execsql {SELECT f1 FROM test1 WHERE min(f1,f2)!=11}} msg]
303   set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1,f2)}} msg]
307   set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1)}} msg]
309 } {1 {misuse of aggregate: min()}}
311   INSERT INTO test1(f1) SELECT f1 FROM test1 ORDER BY min(f1);
312 } {1 {misuse of aggregate: min()}}
751            coalesce(min(f1/(f1-11),5),'y'),
759     SELECT min(1,2,3), -max(1,2,3)