| Showing all 23 (Edit, Save, CSV, Feed) |
| ID# | Date | Type | Status | Sev | Version | Target | OS | Summary | Assigned |
|---|---|---|---|---|---|---|---|---|---|
| 26232 | 2007-02-09 17:28 | Server: Optimizer | Verified (1925 days) | S3 | 4.1.22, 5.0.34, 5.0.36-BK | Linux (Linux) | review of bug #20944 / proof of concept attached | ||
| 27199 | 2007-03-16 5:03 | Server: Optimizer | Verified (1316 days) | S2 | 5.0.22, 5.0.37, 4.1 BK, 5.1 BK | Linux (linux) | Performance problem when query contains a left join against a subquery | Takeover System Account | |
| 27975 | 2007-04-20 11:20 | Server: Optimizer | Verified (1316 days) | S3 | 5.0.38, 5.0.44, 4.1, 5.0, 5.1, 5.2 BK | Linux (RHEL 4) | optimizer error after discovering impossible where clause in a large view | ||
| 29443 | 2007-06-29 13:28 | Server: Optimizer | Verified (588 days) | S3 | 5.1.19 | Any | cost calculations are off | ||
| 30342 | 2007-08-09 18:52 | Server: Optimizer | Analyzing (1670 days) | S5 | 5.0.37 | Any | Equality propagation can make optimization much slower | Valeriy Kravchuk | |
| 31188 | 2007-09-25 16:52 | Server: Optimizer | Verified (868 days) | S5 | 5.0.37, 5.5 | Any | Optimizer does not do index range scans using predicates in IN lists | ||
| 31648 | 2007-10-16 19:01 | Server: Optimizer | Verified (1650 days) | S2 | 5.1.22, 5.0.50 | Any | full table scans being done when range should be used | ||
| 33321 | 2007-12-18 6:34 | Server: Optimizer | Verified (1150 days) | S3 | 5.0.52, 5.0-bzr, 5.1-bzr | Any | print_plan does not print appropriate values. | ||
| 35794 | 2008-04-03 12:06 | Server: Optimizer | Verified (1438 days) | S3 | 5.0.45, 5.0, 5.1, 6.0 BK | Any | Very bad query optimization on DELETE with subquery | ||
| 36802 | 2008-05-19 15:42 | Server: Optimizer | Verified (1333 days) | S3 | 5.0, 5.1, 6.0 BK | 5.6+ | Any | MySQL only use covered index when selecting from a view (or subquery) with union | Evgeny Potemkin |
| 42094 | 2009-01-13 23:01 | Server: Optimizer | Verified (1158 days) | S3 | 5.1 | 5.6+ | Any | Optimizer chooses a wrong index when group by, order by and limit is present | |
| 42948 | 2009-02-17 23:02 | Server: Optimizer | Verified (1178 days) | S5 | 5.0.67-0ubuntu6, 6.0.11 | Linux (Ubuntu 8.10) | MySQL Optimizer does not properly use Indexes on Views with "Group By" | ||
| 43319 | 2009-03-03 2:24 | Server: Optimizer | Verified | S3 | 5.0, 5.1 | Any | Table/index scan when quoting large numbers in an 'IN' of a SELECT ... WHERE | Evgeny Potemkin | |
| 44201 | 2009-04-10 3:04 | Server: Optimizer | Verified (709 days) | S3 | 5.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99 | Any | Performance problem with View | ||
| 44549 | 2009-04-29 17:47 | Server: Optimizer | Verified | S3 | 5.0.80, 5.1.34 | Any | optimizer incorrectly chooses table scan and filesort over index | ||
| 46376 | 2009-07-24 17:05 | Server: Optimizer | Verified (1030 days) | S5 | 5.0.85, 5.1.36, 5.1.38, 5.1.39 | Microsoft Windows (XP) | Optimizer choose wrong index even when where clause and order-by are covered | Tor Didriksen | |
| 47454 | 2009-09-19 19:33 | Server: Optimizer | Verified (977 days) | S3 | 5.1.35 | Any | Not exists optimization method is not used for NULL columns in the right table | ||
| 48049 | 2009-10-14 16:46 | Server: Optimizer | Verified | S3 | 5.1.37, 5.5.7 | Any | SELECT MIN(1) reports differently for MERGE tables in 5.0 and 5.1 | ||
| 53161 | 2010-04-26 13:12 | Server: Optimizer | Verified (736 days) | S1 | 5.1.37, 5.1.46, 5.1.47 | Any | Left join optimized into join leads to incorrect results | ||
| 58101 | 2010-11-10 0:21 | Server: Optimizer | Verified (560 days) | S5 | 5.1.38-community-log, 5.1.54-bzr | Linux | Optimizer picks wrong order of queries | ||
| 62676 | 2011-10-11 1:23 | Server: Docs | Verified (226 days) | S3 | 5.6.3 | Any | I don't understand the MRR docs | Paul DuBois | |
| 64557 | 2012-03-06 0:12 | Server: Optimizer | Verified (78 days) | S2 | 5.1.56, 5.5.20, 5.6.4 | Microsoft Windows (XP Pro SP3) | Correlated subquery performance is degraded in releases alfter 5.0 | Sveta Smirnova | |
| 64567 | 2012-03-06 18:38 | Server: Optimizer | Verified (79 days) | S3 | 5.5.20, 5.5.21 | Any | Last_query_cost is not updated when executing an unique key lookup |
| Showing all 23 (Edit, Save, CSV, Feed) |
