diff options
author | unknown <ramil@ram-book.(none)> | 2005-05-09 11:43:52 +0500 |
---|---|---|
committer | unknown <ramil@ram-book.(none)> | 2005-05-09 11:43:52 +0500 |
commit | 51e862786b47792a78a1931fff728b2fa0059659 (patch) | |
tree | 380ba2b33d0dfdcbf80c9395a2abefca06ae846e /mysql-test/t/group_min_max.test | |
parent | 848611b5ed1e565d02eea896e22753b818c458c5 (diff) | |
download | mariadb-git-51e862786b47792a78a1931fff728b2fa0059659.tar.gz |
Fix for bug #9798: Rollup crash with InnoDB in setup_sum_funcs().
sql/opt_range.cc:
Fix for bug #9798: Rollup crash with InnoDB in setup_sum_funcs().
Disable mix/max group by optimization for queries with rollup for now.
Note: the actual bug was hidden; if this optimization works with rollup
queries we will have to change some code:
the problem is that we call the join->make_sum_func_list() function against
changed thd->mem_root (see SQL_SELECT::test_quick_select()) which creates some
items for rollup, then we free that mem_root, then we try to reuse (free) those
items.
Diffstat (limited to 'mysql-test/t/group_min_max.test')
-rw-r--r-- | mysql-test/t/group_min_max.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/group_min_max.test b/mysql-test/t/group_min_max.test index d85b3395853..9feb4f33682 100644 --- a/mysql-test/t/group_min_max.test +++ b/mysql-test/t/group_min_max.test @@ -610,3 +610,14 @@ create table t1 ( --enable_warnings select distinct a from t1; drop table t1; + +# +# Bug #9798: group by with rollup +# + +--disable_warnings +create table t1(a int, key(a)) engine=innodb; +--enable_warnings +insert into t1 values(1); +select a, count(a) from t1 group by a with rollup; +drop table t1; |