diff options
| author | unknown <igor@rurik.mysql.com> | 2005-03-16 15:55:04 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-03-16 15:55:04 -0800 |
| commit | 56c345f4600f5cde9b625d7cec70a93aa2b4ef35 (patch) | |
| tree | aea08e93e777896437566b45ea6a3d9a6aa0eb50 /mysql-test | |
| parent | 870ea1692958090fcff16bee6904c94d825f381e (diff) | |
| download | mariadb-git-56c345f4600f5cde9b625d7cec70a93aa2b4ef35.tar.gz | |
olap.result, olap.test:
Added a test for bug #8615.
sql_select.cc:
Fixed bug #8615.
This fix only removed the cause of the reported crash.
It does not resolve other problems of rollup queries
with DISTINCT. They were fixed in the previous patch
for bug 8616.
sql/sql_select.cc:
Fixed bug #8615.
This fix only removed the cause of the reported crash.
It does not resolve other problems of rollup queries
with DISTINCT. They were fixed in the previous patch
for bug 8616.
mysql-test/t/olap.test:
Added a test for bug #8615.
mysql-test/r/olap.result:
Added a test for bug #8615.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/olap.result | 18 | ||||
| -rw-r--r-- | mysql-test/t/olap.test | 5 |
2 files changed, 22 insertions, 1 deletions
diff --git a/mysql-test/r/olap.result b/mysql-test/r/olap.result index 67610108c61..fe83800f658 100644 --- a/mysql-test/r/olap.result +++ b/mysql-test/r/olap.result @@ -360,4 +360,22 @@ SUM(b) COUNT(DISTINCT b) COUNT(*) 6 2 4 4 1 4 14 3 9 +SELECT a, sum(b) FROM t1 GROUP BY a,b WITH ROLLUP; +a sum(b) +1 4 +1 4 +2 2 +2 4 +2 6 +4 4 +4 4 +NULL 14 +SELECT DISTINCT a, sum(b) FROM t1 GROUP BY a,b WITH ROLLUP; +a sum(b) +1 4 +2 2 +2 4 +2 6 +4 4 +NULL 14 DROP TABLE t1; diff --git a/mysql-test/t/olap.test b/mysql-test/t/olap.test index d2ea582e58c..6778af3d533 100644 --- a/mysql-test/t/olap.test +++ b/mysql-test/t/olap.test @@ -126,7 +126,7 @@ SELECT DROP TABLE user_day; # -# Test for bug #8616: distinct sum with rollup +# Tests for bugs #8616, #8615: distinct sum with rollup # CREATE TABLE t1 (a int, b int); @@ -150,5 +150,8 @@ SELECT SUM(b), COUNT(DISTINCT b), COUNT(*) FROM t1 GROUP BY a WITH ROLLUP; SELECT DISTINCT SUM(b), COUNT(DISTINCT b), COUNT(*) FROM t1 GROUP BY a WITH ROLLUP; +SELECT a, sum(b) FROM t1 GROUP BY a,b WITH ROLLUP; +SELECT DISTINCT a, sum(b) FROM t1 GROUP BY a,b WITH ROLLUP; + DROP TABLE t1; |