diff options
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 86 |
1 files changed, 86 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result new file mode 100644 index 00000000000..ea9a06123ae --- /dev/null +++ b/mysql-test/r/func_group.result @@ -0,0 +1,86 @@ +a c sum(a) +1 a 1 +2 b 2 +3 c 3 +4 E 4 +5 C 5 +6 D 6 +a c sum(a) +sum(a) +NULL +a +1 +3 +6 +5 +2 +4 +a +1 +3 +6 +5 +2 +4 +count(distinct a) count(distinct grp) +6 3 +count(distinct a) count(distinct grp) +6 3 +sum(a) count(a) avg(a) std(a) bit_or(a) bit_and(a) min(a) max(a) min(c) max(c) +21 6 3.5000 1.7078 7 0 1 6 E +grp sum(a) count(a) avg(a) std(a) bit_or(a) bit_and(a) min(a) max(a) min(c) max(c) +NULL 0 0 NULL NULL 0 0 NULL NULL +1 1 1 1.0000 0.0000 1 1 1 1 a a +2 5 2 2.5000 0.5000 3 2 2 3 b c +3 15 3 5.0000 0.8165 7 4 4 6 C E +grp sum +NULL NULL +1 7 +2 20 +3 44.816496580928 +grp a c +NULL NULL +1 2 a +2 5 c +3 9 E +2 3 c +id avg(value1) std(value1) +1 1.000000 0.816497 +2 11.000000 0.816497 +name avg(value1) std(value1) +Set One 1.000000 0.816497 +Set Two 11.000000 0.816497 +id avg(rating) +1 3.0000 +2 NULL +3 2.0000 +count(*) +3 +count(*) +1 +count(*) +0 +count(*) +0 +count(a) +1 +count(a) +0 +count(a) +0 +count(b) +2 +count(b) +0 +count(c) +0 +COUNT(i) i COUNT(i)*i +1 1 1 +COUNT(i) (i+0) COUNT(i)*(i+0) +1 1 1 +sum(num) +147.58 +sum(num) +50.15 +45.63 +51.80 |