Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6, 10.11, 11.4, 11.8, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.7(EOL), 10.8(EOL)
-
Linux
-
Not for Release Notes
Description
create table t (c int);
|
insert into t values (20121212),(9),(19800101),(20121212),(19800101);
|
|
select c, count(*) from t group by c desc with rollup;
|
|
MariaDB [test]> select c, count(*) from t group by c desc with rollup;
|
+----------+----------+
|
| c | count(*) |
|
+----------+----------+
|
| 20121212 | 2 |
|
| 19800101 | 2 |
|
| 9 | 1 |
|
| NULL | 5 |
|
+----------+----------+
|
4 rows in set (0.001 sec)
|
|
select c, count(*) from t group by convert(c, int) desc with rollup;
|
MariaDB [test]> select c, count(*) from t group by convert(c,int) desc with rollup;
|
+----------+----------+
|
| c | count(*) |
|
+----------+----------+
|
| 20121212 | 2 |
|
| 19800101 | 2 |
|
| 9 | 1 |
|
| 9 | 5 |
|
+----------+----------+
|
When the group by with rollup in correct function ,there will be have different results.
Attachments
Issue Links
- duplicates
-
MDEV-19039 Wrong result from query, using window function and GROUP BY .. WITH ROLLUP
-
- Stalled
-
- relates to
-
MDEV-26853 Confusing row numbers upon ER_TRUNCATED_WRONG_VALUE with ROLLUP
-
- Confirmed
-