sum_distinct-big test fails after resetting max_heap_table_size
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
High
|
Stewart Smith | ||
7.0 |
Fix Released
|
Medium
|
Stewart Smith | ||
Cherry |
Won't Fix
|
High
|
Stewart Smith |
Bug Description
When running the big test suite (make test-big) the sum_distinct-big test fails when it resets the max_heap_table_size to a smaller size then runs several sum distinct commands again. According to the test notes it creates a situation where all the values can not fit in memory and thus must be stored in a temporary table. This was run on x86 OpenSolaris (drizzle-os machine) but I have also seen this fail on other platforms as well.
From the test:
-------------------
# SELECT '++++++
SELECT SUM(DISTINCT id) sm FROM t1;
SELECT SUM(DISTINCT id) sm FROM t2;
SELECT SUM(DISTINCT id) sm FROM t1 group by id % 13;
# this limit for max_heap_table_size is set to force testing the case, when
# all distinct sum values can not fit in memory and must be stored in a
# temporary table
SET max_heap_
# to check that max_heap_table_size was actually set (hard limit for minimum
# max_heap_table_size is set in mysqld.cc):
SHOW variables LIKE 'max_heap_
SELECT SUM(DISTINCT id) sm FROM t1;
SELECT SUM(DISTINCT id) sm FROM t2;
SELECT SUM(DISTINCT id) sm FROM t1 GROUP BY id % 13;
Test differences:
-------
$ diff suite/big/
87c87
< 134225920
---
> 134479903
90c90
< 134225920
---
> 16639377498
93,105c93,105
< 10327590
< 10328851
< 10330112
< 10331373
< 10332634
< 10317510
< 10318770
< 10320030
< 10321290
< 10322550
< 10323810
< 10325070
< 10326330
---
> 10353720
> 10344349
> 10349239
> 10358227
> 10364964
> 10330676
> 10338685
> 10346883
> 10351045
> 10342415
> 10347591
> 10355365
> 10340237
Related branches
- Drizzle Developers: Pending requested
-
Diff: 55 lines (+25/-6)2 files modifiedtests/suite/big/r/sum_distinct-big.result (+21/-0)
tests/suite/big/t/sum_distinct-big.test (+4/-6)
Changed in drizzle: | |
importance: | Undecided → High |
milestone: | none → aloha |
assignee: | nobody → Stewart Smith (stewart-flamingspork) |
Changed in drizzle: | |
milestone: | aloha → bell |
Changed in drizzle: | |
milestone: | bell → cherry |
Changed in drizzle: | |
milestone: | 2010-05-24 → none |
I was able to reproduce this failure. My platform is
opensuse 11.1 x86_64
jdaly@rx8:~/stats> uname -a
Linux rx8 2.6.27.7-9-xen #1 SMP 2008-12-04 18:10:04 +0100 x86_64 x86_64 x86_64 GNU/Linux
jdaly@rx8:~/stats>