| Showing all 8 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 108937 | 2022-10-31 13:30 | 2022-12-13 4:03 | MySQL Server: Optimizer | Verified (1395 days) | S3 | 8.0.30 | Any | Any | Date value change caused by HAVING |
| 70684 | 2013-10-22 8:13 | 2013-10-22 11:35 | MySQL Server: Optimizer | Verified (4734 days) | S3 | 5.5.33, 5.6.14 | Any | Any | HAVING referring to subquery results in WARNING 1292 |
| 100301 | 2020-07-23 5:16 | 2020-07-23 5:23 | MySQL Server: Optimizer | Verified (2268 days) | S3 | 5.7.31, 5.6.48 | Any | Any | LOG result used as predicate causes the conversion to boolean inconsistent |
| 70466 | 2013-09-30 7:24 | 2013-09-30 8:45 | MySQL Server: Optimizer | Verified (4756 days) | S2 | 5.5,5.6 | Any | Any | No results when filesorting with a correlation in subquery's HAVING clause |
| 121336 | 2026-09-21 10:42 | 2026-09-23 6:51 | MySQL Server: Optimizer | Verified (15 days) | S2 | 8.0.46, 8.4.11, 9.7.2 | Ubuntu (24.04) | x86 | SQL_BUFFER_RESULT causes aggregate row failing HAVING predicate to be returned |
| 82317 | 2016-07-22 7:42 | 2018-07-18 8:55 | MySQL Server: Parser | Verified (3730 days) | S3 | 5.5.49 | Any (v14.04.1) | Any | Unrelevant error message: Unknown column in 'having' clause |
| 100270 | 2020-07-21 4:30 | 2020-07-21 6:34 | MySQL Server: Optimizer | Verified (2270 days) | S3 | 5.7.31, 5.6.48 | Any | Any | Use MOD result (float number) in HAVING/WHERE is not considered as TRUE |
| 112169 | 2023-08-23 15:41 | 2023-08-24 13:51 | MySQL Server: Optimizer | Verified (1141 days) | S3 | 5.7 | Any | Any | Using LOWER in HAVING clause falsifies result of GROUP_CONCAT |
| Showing all 8 (Edit, Save, CSV, Feed) |
