← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/sum_distinct.result

  • Committer: Monty Taylor
  • Date: 2010-12-02 22:51:54 UTC
  • mto: (1975.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1976.
  • Revision ID: mordred@inaugust.com-20101202225154-h54ifmga9x6cckgs
Refactored syslog module and changed it to use sys_var directly.

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
55
55
SUM(DISTINCT LENGTH(g1.name)) s1,
56
56
SUM(DISTINCT SUBSTRING(g2.name, 1, 3)) s2,
57
57
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));
 
58
FROM t1 g1, t1 g2, t1 g3 GROUP BY LENGTH(SUBSTRING(g3.name, 5, 10));
59
59
s1      s2      s3
60
60
42      0       NULL
61
61
42      0       7
75
75
SUM(DISTINCT LENGTH(g1.name)) s1,
76
76
SUM(DISTINCT SUBSTRING(g2.name, 1, 3)) s2,
77
77
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));
 
78
FROM t1 g1, t1 g2, t1 g3 GROUP BY LENGTH(SUBSTRING(g3.name, 5, 10));
79
79
s1      s2      s3
80
80
42      0       NULL
81
81
42      0       7