| Showing all 10 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 26894 | 2007-03-06 21:06 | 2007-04-03 16:46 | MySQL Server: C API (client library) | Can't repeat (6231 days) | S2 | 5.0.27, 5.0.37 | Linux (linux) | Any | Use of C api to fetch field name returned by a select using a derived table. |
| 35002 | 2008-03-03 14:17 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5895 days) | S2 | 5.1.23-rc/5.1BK/5.0/6.0 | Linux (2.6.22.9-61.fc6) | Any | Wrong results returned when using derived table and group by |
| 41156 | 2008-12-01 18:44 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5377 days) | S3 | 5.0.72, 5.1.30, 6.0.7 | Any | Any | List of derived tables acts like a chain of mutually-nested subqueries |
| 27199 | 2007-03-16 5:03 | 2013-09-09 9:28 | MySQL Server: Optimizer | Closed (3880 days) | S2 | 5.0.22, 5.0.37, 4.1 BK, 5.1 BK | Linux (linux) | Any | Performance problem when query contains a left join against a subquery |
| 70220 | 2013-09-03 6:14 | 2015-10-26 15:51 | MySQL Server: Optimizer | Closed (3103 days) | S2 | 5.1,5.5, 5.6, 5.7.2-m12 | Any | Any | Grouping with a view may report 'Invalid use of group function' |
| 94988 | 2019-04-11 13:27 | 2022-11-09 15:48 | MySQL Server: Charsets | Verified (1840 days) | S3 | 5.6/5.7/8.0 | Linux | Any | Illegal mix of collations for derived tables |
| 78199 | 2015-08-25 6:25 | 2021-02-17 14:24 | MySQL Server: Parser | Can't repeat (1162 days) | S3 | 5.6.26,5.5.25,5.5.20 | Any | Any | CONCAT() with CASE in derived table returns unexpected results |
| 93188 | 2018-11-14 11:16 | 2020-07-15 12:53 | MySQL Server: Optimizer | Verified (1986 days) | S5 | 5.7 | Any | Any | Optimiser chose incorrect join order inside of derived table |
| 105509 | 2021-11-10 1:59 | 2021-11-10 6:02 | MySQL Server: DML | Verified (896 days) | S2 | 8.0.25, 8.0.27, 5.7.35 | Any | Any | DECIMAL results are truncated without errors when using derived table |
| 111189 | 2023-05-29 15:04 | 2023-08-09 12:50 | MySQL Server: Optimizer | Closed (259 days) | S3 | 8.0 | Any | Any | Scalar correlated subquery with group by clause mistakenly transformed |
| Showing all 10 (Edit, Save, CSV, Feed) |
