| Showing all 14 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 24856 | 2006-12-06 16:07 | 2007-05-08 0:40 | MySQL Server | Closed (6198 days) | S3 | 4.1.22 / 5.0.22, 5.1 BK | Linux (Linux) | Any | distinct with constant item and rollup => missing summary lines |
| 27848 | 2007-04-16 11:59 | 2008-07-18 15:51 | MySQL Server | Closed (5761 days) | S3 | 5.0.40 4.1.23 | Any | Any | rollup in union part causes error with order of union |
| 30874 | 2007-09-06 18:12 | 2007-09-07 14:58 | MySQL Server: General | Can't repeat (6076 days) | S3 | 5.0.26 | Linux | Any | rollup doesn't work with substr |
| 31095 | 2007-09-19 12:22 | 2007-11-09 0:24 | MySQL Server: General | Closed (6013 days) | S1 | 5.0.48, 5.1.23BK | Any | Any | server crashes with group by null with rollup |
| 38297 | 2008-07-22 20:04 | 2014-12-21 3:15 | MySQL Server: User-defined functions ( UDF ) | Verified (5756 days) | S3 | 5.0, 5.1 | Windows (Vista Ultimat) | Any | aggregate UDF xxx_init / deinit only called once for aggregation with rollup |
| 47650 | 2009-09-25 16:53 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5159 days) | S3 | 5.0.X, 5.1.39, next-mr | Any (Mac OS X Snow leopard, Linux) | Any | using group by with rollup without indexes returns incorrect results with where |
| 80653 | 2016-03-08 6:43 | 2016-03-15 10:10 | MySQL Server | Closed (2964 days) | S2 | 5.7.10 | Any | Any | COUNT DISTINCT GROUP BY ROLLUP return wrong number |
| 84720 | 2017-01-30 12:09 | 2017-01-30 13:19 | MySQL Server: Optimizer | Verified (2643 days) | S3 | 5.6.27,5.7, 5.7.17 | Any | Any | WITH ROLLUP not providing expected NULL values |
| 100791 | 2020-09-10 0:55 | 2020-10-01 14:18 | MySQL Server: Optimizer | Closed (1303 days) | S1 | 8.0.21 | Debian (Buster 10) | x86 | Data type changed in a GROUP BY WITH ROLLUP |
| 101175 | 2020-10-14 18:12 | 2021-02-17 11:11 | MySQL Server: DML | Closed (1164 days) | S3 | 8.0.21 | Ubuntu (Ver 8.0.21-0ubuntu0.20.04.4) | Any | COALESCE and IFNULL do not work as expected in WITH ROLLUP queries |
| 103583 | 2021-05-05 8:21 | 2021-05-18 13:36 | MySQL Server: DDL | Closed (1074 days) | S1 | 8.0.24, 8.0.23, 8.0.21 | Any | Any | Dump/Restore fails with nested VIEWS having ROLLUP over DISTINCT groups |
| 103852 | 2021-05-29 20:02 | 2021-07-01 1:00 | MySQL Server: Optimizer | No Feedback (1031 days) | S2 | 8.0.17 | Other (official Docker image) | x86 | intermediate ROLLUP gives incorrect result |
| 104394 | 2021-07-23 10:18 | 2021-08-30 12:06 | MySQL Server: DML | Closed (973 days) | S3 | 8.0 | Any | Any | SELECT's GROUPING() not taken in account in HAVING when JOIN used |
| 108150 | 2022-08-16 13:19 | 2023-01-27 16:19 | MySQL Server: Optimizer | Verified (455 days) | S3 | 8.0.30 | Ubuntu (22.04.1) | x86 (x86_x64) | ALL query with UNION and ROLLUP wrong result |
| Showing all 14 (Edit, Save, CSV, Feed) |
