← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/sum_distinct.test

  • 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/t/sum_distinct.test
59
59
FROM t1 g1, t1 g2, t1 g3;
60
60
 
61
61
SELECT
 
62
  SQL_BIG_RESULT
62
63
  SUM(DISTINCT LENGTH(g1.name)) s1,
63
64
  SUM(DISTINCT SUBSTRING(g2.name, 1, 3)) s2,
64
65
  SUM(DISTINCT LENGTH(SUBSTRING(g3.name, 1, 4))) s3
73
74
  SUM(DISTINCT LENGTH(SUBSTRING(name, 1, 4))) s3
74
75
FROM t1;
75
76
 
76
 
SELECT SQL_BUFFER_RESULT
 
77
SELECT SQL_BIG_RESULT
77
78
  SUM(DISTINCT LENGTH(g1.name)) s1,
78
79
  SUM(DISTINCT SUBSTRING(g2.name, 1, 3)) s2,
79
80
  SUM(DISTINCT LENGTH(SUBSTRING(g3.name, 1, 4))) s3