~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_group.result

  • Committer: Brian Aker
  • Date: 2010-10-21 17:41:40 UTC
  • mfrom: (1865.1.2 trunk-bug-662980)
  • Revision ID: brian@tangent.org-20101021174140-m1jk977sz1r39i6u
Merge in fix for Andrew.

Show diffs side-by-side

added added

removed removed

Lines of Context:
867
867
3.00000 3
868
868
SELECT b/c as v, SUM(a) FROM t1 GROUP BY v;
869
869
v       SUM(a)
 
870
0.33333 6
870
871
0.50000 6
 
872
0.66667 6
871
873
1.00000 18
872
874
1.50000 6
873
875
2.00000 6
874
876
3.00000 6
875
 
9999999999.99999        12
876
877
SELECT SUM(a) FROM t1 GROUP BY b/c;
877
878
SUM(a)
878
879
6
 
880
6
 
881
6
879
882
18
880
883
6
881
884
6
882
885
6
883
 
12
884
886
DROP TABLE t1;
885
887
set div_precision_increment= @sav_dpi;
886
888
CREATE TABLE t1 (a INT PRIMARY KEY, b INT);