Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
-
None
Description
CREATE TABLE t1 (i int); |
INSERT INTO t1 VALUES (1), (1), (2), (2), (3), (3); |
|
SELECT i, SUM(i) OVER () FROM t1 GROUP BY i ; |
SELECT i, SUM(i) OVER () FROM t1 GROUP BY i WITH ROLLUP; |
MariaDB [test]> SELECT i, SUM(i) OVER () FROM t1 GROUP BY i;
|
+------+----------------+
|
| i | SUM(i) OVER () |
|
+------+----------------+
|
| 1 | 6 |
|
| 2 | 6 |
|
| 3 | 6 |
|
+------+----------------+
|
3 rows in set (0.005 sec)
|
|
MariaDB [test]> SELECT i, SUM(i) OVER () FROM t1 GROUP BY i WITH ROLLUP;
|
+------+----------------+
|
| i | SUM(i) OVER () |
|
+------+----------------+
|
| 1 | 9 |
|
| 2 | 9 |
|
| 3 | 9 |
|
| NULL | 9 |
|
+------+----------------+
|
4 rows in set (0.003 sec)
|
|