← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/sum_distinct.test

  • Committer: Stewart Smith
  • Date: 2009-06-16 06:55:11 UTC
  • mto: This revision was merged to the branch mainline in revision 1094.
  • Revision ID: stewart@flamingspork.com-20090616065511-ps3ewfxj7918lwy3
rollback.test for MyISAM temp only.
- rename to myisam_rollback to reflect what it's testing
- just use create temporary table

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