diff options
| author | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2009-11-06 17:54:19 +0300 |
|---|---|---|
| committer | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2009-11-06 17:54:19 +0300 |
| commit | 05c4f3f3964e82c6cf217f8cc0775d9774ebe49f (patch) | |
| tree | ca008eff4c02a8554ea6a28e907086f32d9cb7b5 /mysql-test/r/olap.result | |
| parent | eb03f819f1f1d40b97f51d9345cbaa0bc6cbd801 (diff) | |
| parent | 39f9a3ffd0de8828be2a43b9674a19fa58c52f98 (diff) | |
| download | mariadb-git-05c4f3f3964e82c6cf217f8cc0775d9774ebe49f.tar.gz | |
Automerge.
Diffstat (limited to 'mysql-test/r/olap.result')
| -rw-r--r-- | mysql-test/r/olap.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/olap.result b/mysql-test/r/olap.result index a7516d97888..8fb6f787795 100644 --- a/mysql-test/r/olap.result +++ b/mysql-test/r/olap.result @@ -753,4 +753,16 @@ b 100 NULL DROP TABLE t1, t2; +# +# Bug #48475: DISTINCT is ignored with GROUP BY WITH ROLLUP +# and only const tables +CREATE TABLE t1 (a INT); +CREATE TABLE t2 (b INT); +INSERT INTO t1 VALUES (1); +INSERT INTO t2 VALUES (1); +SELECT DISTINCT b FROM t1, t2 GROUP BY a, b WITH ROLLUP; +b +1 +NULL +DROP TABLE t1, t2; End of 5.0 tests |