← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/sum_distinct.result

  • Committer: Brian Aker
  • Date: 2010-04-20 18:23:07 UTC
  • mto: This revision was merged to the branch mainline in revision 1502.
  • Revision ID: brian@gaz-20100420182307-jwyhun4vm2dtugyb
There is room for improvement around this. We should be using rows as well
in the future as a metric for disk/memory store. 

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/sum_distinct.result
51
51
s1      s2      s3
52
52
42      0       7
53
53
SELECT
 
54
SQL_BIG_RESULT
54
55
SUM(DISTINCT LENGTH(g1.name)) s1,
55
56
SUM(DISTINCT SUBSTRING(g2.name, 1, 3)) s2,
56
57
SUM(DISTINCT LENGTH(SUBSTRING(g3.name, 1, 4))) s3
70
71
FROM t1;
71
72
s1      s2      s3
72
73
42      0       7
73
 
SELECT SQL_BUFFER_RESULT
 
74
SELECT SQL_BIG_RESULT
74
75
SUM(DISTINCT LENGTH(g1.name)) s1,
75
76
SUM(DISTINCT SUBSTRING(g2.name, 1, 3)) s2,
76
77
SUM(DISTINCT LENGTH(SUBSTRING(g3.name, 1, 4))) s3