Lines Matching refs:sum

373       execsql {EXPLAIN SELECT sum(a) FROM t2;}
376       SELECT sum(a), count(a), round(avg(a),2), min(a), max(a), count(*) FROM t2;
383       execsql {EXPLAIN SELECT sum(a) FROM t2;}
386       SELECT sum(a), count(a), avg(a), min(a), max(a), count(*) FROM t2;
419       SELECT sum(x) FROM (SELECT '9223372036' || '854775807' AS x
425       SELECT typeof(sum(x)) FROM (SELECT '9223372036' || '854775807' AS x
431       SELECT typeof(sum(x)) FROM (SELECT '9223372036' || '854775808' AS x
438       SELECT sum(x)>0.0 FROM (SELECT '9223372036' || '854775808' AS x
446       SELECT sum(x)>0 FROM (SELECT '9223372036' || '854775808' AS x
521     sum(length(replace(printf('abc%.*cxyz',x,'m'),'m','nnnn'))-(6+x*4))
783     SELECT sum(x) FROM t5;
790       SELECT sum(x) FROM t5;
795 # The sum of nothing is NULL.  But the sum of all NULLs is NULL.
802     SELECT sum(x), total(x) FROM t5;
808     SELECT sum(x), total(x) FROM t5
814     SELECT sum(x), total(x) FROM t5
820     SELECT sum(x), total(x) FROM t5
833     SELECT sum(x) - ((1<<62)+1) from t6;
838     SELECT typeof(sum(x)) FROM t6
845       SELECT sum(x) - ((1<<62)*2.0+1) from t6;
858       SELECT sum(x) - ((1<<62)*2+1) from t6;
870       SELECT sum(-9223372036854775805);
878     SELECT sum(x) FROM 
886       SELECT sum(x) FROM 
893       SELECT sum(x) FROM 
901     SELECT sum(x) FROM 
908     SELECT sum(x) FROM (SELECT 9 AS x UNION ALL SELECT -10 AS x);
913     SELECT sum(x) FROM (SELECT -9 AS x UNION ALL SELECT 10 AS x);
918     SELECT sum(x) FROM (SELECT -10 AS x UNION ALL SELECT 9 AS x);
923     SELECT sum(x) FROM (SELECT 10 AS x UNION ALL SELECT -9 AS x);
1349   db eval {SELECT sum(length(x)) FROM t29}