← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/sum_distinct.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

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