← 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: 2009-10-07 16:55:53 UTC
  • mfrom: (1161.2.1 bug444827)
  • Revision ID: brian@gaz-20091007165553-9tnp7liw1k9g6gvc
Merge Padraig

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/sum_distinct.result
47
47
SUM(DISTINCT LENGTH(g1.name)) s1,
48
48
SUM(DISTINCT SUBSTRING(g2.name, 1, 3)) s2,
49
49
SUM(DISTINCT LENGTH(SUBSTRING(g3.name, 1, 4))) s3
50
 
FROM t1 g1 CROSS JOIN t1 g2 CROSS JOIN t1 g3;
 
50
FROM t1 g1, t1 g2, t1 g3;
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
58
 
FROM t1 g1 CROSS JOIN t1 g2 CROSS JOIN t1 g3 GROUP BY LENGTH(SUBSTRING(g3.name, 5, 10));
 
57
FROM t1 g1, t1 g2, t1 g3 GROUP BY LENGTH(SUBSTRING(g3.name, 5, 10));
59
58
s1      s2      s3
60
59
42      0       NULL
61
60
42      0       7
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
78
 
FROM t1 g1 CROSS JOIN t1 g2 CROSS JOIN t1 g3 GROUP BY LENGTH(SUBSTRING(g3.name, 5, 10));
 
77
FROM t1 g1, t1 g2, t1 g3 GROUP BY LENGTH(SUBSTRING(g3.name, 5, 10));
79
78
s1      s2      s3
80
79
42      0       NULL
81
80
42      0       7