← Back to branch summary

~drizzle-pbxt/drizzle/drizzle-pbxt-2

« back to all changes in this revision

Viewing changes to tests/suite/big/t/sum_distinct-big.test

  • Committer: Paul McCullagh
  • Date: 2009-11-10 14:18:39 UTC
  • mfrom: (1038.1.7 drizzle-pbxt-pre-merge)
  • Revision ID: paul.mccullagh@primebase.org-20091110141839-2j3k43b17ag6f605
Merged Drizzle trunk and PBXT 1.0.09

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/big/t/sum_distinct-big.test
53
53
 
54
54
SET max_heap_table_size=16384;
55
55
 
 
56
# Drizzle bug 376299
 
57
# please uncomment the test after the bug is fixed
56
58
# to check that max_heap_table_size was actually set (hard limit for minimum
57
59
# max_heap_table_size is set in mysqld.cc):
58
 
 
 
60
#
59
61
SHOW variables LIKE 'max_heap_table_size';
60
62
 
61
 
SELECT SUM(DISTINCT id) sm FROM t1;
62
 
SELECT SUM(DISTINCT id) sm FROM t2;
63
 
SELECT SUM(DISTINCT id) sm FROM t1 GROUP BY id % 13;
 
63
#SELECT SUM(DISTINCT id) sm FROM t1;
 
64
#SELECT SUM(DISTINCT id) sm FROM t2;
 
65
#SELECT SUM(DISTINCT id) sm FROM t1 GROUP BY id % 13;
64
66
 
65
67
DROP TABLE t1;
66
68
DROP TABLE t2;