| Showing 1-30 of 393 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | Target | OS | CPU | Summary | Assigned |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 8749 | 2005-02-23 21:08 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3547 days) | S3 | 4.1.10, 5.0.67 | Any (*) | Any | EXPLAIN report different "type" w and w/o USE INDEX(...) for the same used key | ||
| 17299 | 2006-02-10 12:35 | 2014-01-23 9:53 | MySQL Server: Optimizer | Verified (1971 days) | S3 | 5.0.18 | Any (All) | Any | Inefficient optimizer for fulltext queries. | ||
| 25068 | 2006-12-14 11:56 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3896 days) | S3 | 4.0.27, 5.0.19, 5.0.36-BK | Linux (Linux) | Any | MyISAM-Optimizer prefers full table scan than index for IN with >15 elements | ||
| 29421 | 2007-06-28 13:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4372 days) | S2 | 5.1.14-beta/5.0 | Any | Any | MySQL allows mixing of GROUP columns with no GROUP columns in complex terms | ||
| 34078 | 2008-01-26 14:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4133 days) | S3 | 4.1,5.0,5.1,6.0-BK | Any (Linux) | Any | ref access is not used for varchar column | Evgeny Potemkin | |
| 36300 | 2008-04-23 17:49 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3443 days) | S3 | 4.1.26, 5.0.32, 5.0+, 5.1.43-bzr, 6.0.14-bzr | Linux | Any | min() and max() functions returns NULL when using NOT + BETWEEN in where | ||
| 37902 | 2008-07-06 15:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3977 days) | S3 | 5.0.45, 5.0.68 | Mac OS X | Any | Bug (2) in the query optimizer (explain) | ||
| 41109 | 2008-11-28 17:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3729 days) | S2 | 5.1.30, 5.0, 5.1, 6.0 bzr | Any | Any | Query takes >5 hrs and locks db, when optimised manually takes <1s | ||
| 42948 | 2009-02-17 23:02 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3758 days) | S5 | 5.0.67-0ubuntu6, 6.0.11 | Linux (Ubuntu 8.10) | Any | MySQL Optimizer does not properly use Indexes on Views with "Group By" | ||
| 44201 | 2009-04-10 3:04 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3289 days) | S3 | 5.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99 | Any | Any | Performance problem with View | ||
| 45680 | 2009-06-23 14:15 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0.54, 5.0.82, 5.1.35, 6.0.12 | Any | Any | wrong results when using index for lookup with implicitly casted values | ||
| 46227 | 2009-07-16 14:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3623 days) | S3 | 5.0,5.1,5.4 | Any | Any | Wrong result on DISTINCT + aggregate + JOIN + InnoDB | ||
| 46717 | 2009-08-14 11:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3584 days) | S5 | 5.1.32 | Any | Any | Unnecessary joins are not optimized away | ||
| 48190 | 2009-10-20 14:59 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.1,6.0 | Any | Any | Error processing ALL subqueries on empty sets - different than JavaDB/Postgres | ||
| 50388 | 2010-01-16 4:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S5 | 5.1.41,5.1.42, 5.1.43-bzr | Any | Any | partition pruning not working with some right joins | ||
| 52762 | 2010-04-12 10:49 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3352 days) | S5 | 5.3 | Any | Any | like should be index optimised if starts with _ rather than % | ||
| 54312 | 2010-06-07 22:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3296 days) | S3 | 5.1.47, 5.1.48-bzr | Any | Any | insert ... select .. order by rand(): difference depending on indexes. | ||
| 57216 | 2010-10-04 12:59 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3174 days) | S3 | 5.1, 5.6.99 bzr | Any | Any | InnoDB column prefix index not treated as a covering one | ||
| 59187 | 2010-12-27 15:31 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3094 days) | S2 | 5.1.55, 5.6.2-m5 | Any | Any | Wrong result with NULL NOT IN subquery | Roy Lyseng | |
| 61551 | 2011-06-17 12:26 | 2011-06-18 8:34 | MySQL Server: Optimizer | Verified (2922 days) | S3 | 5.1.56 | Any | Any | Loose index scan is not used for select COUNT(distinct a) | ||
| 64016 | 2012-01-12 19:38 | 2012-01-19 11:48 | MySQL Server: Optimizer | Verified (2712 days) | S3 | 5.5.19 | Any | Any | Optimizer doesn't seem to take into account enum definition | ||
| 66849 | 2012-09-17 18:49 | 2013-06-10 19:50 | MySQL Server: Optimizer | Verified (2198 days) | S1 | 5.5.16, 5.1.70, 5.5.32, 5.6.12 | Linux | Any | [REGRESSION] this query hangs the server (100% CPU for several minutes) | ||
| 68554 | 2013-03-03 16:16 | 2016-10-09 20:45 | MySQL Server: Optimizer | Verified (2282 days) | S5 | 5.6.10 | Any | Any | Optimizer wrongly choses covering index over ICP | Assigned Account | |
| 69219 | 2013-05-13 20:14 | 2013-05-13 20:32 | MySQL Server: Optimizer | Verified (2226 days) | S5 | 5.6.12 | Any | Any | CREATE TEMPORARY TABLE ... SELECT is slower on 5.6 than on 5.1 | ||
| 70314 | 2013-09-12 12:28 | 2013-09-12 14:07 | MySQL Server: Optimizer | Verified (2104 days) | S3 | 5.6 | Any | Any | Ambiguous column updated with UPDATE ... JOIN ... USING | ||
| 70684 | 2013-10-22 8:13 | 2013-10-22 11:35 | MySQL Server: Optimizer | Verified (2064 days) | S3 | 5.5.33, 5.6.14 | Any | Any | HAVING referring to subquery results in WARNING 1292 | ||
| 71206 | 2013-12-22 17:13 | 2013-12-31 20:00 | MySQL Server: Optimizer | Verified (2002 days) | S1 | 5.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3 | Linux (ubuntu 12.04) | Any | GROUP_CONCAT changes GROUP BY behavior | ||
| 72501 | 2014-05-01 17:31 | 2014-05-01 18:12 | MySQL Server: Optimizer | Verified | S3 | 5.6.17 | Any | Any | joining NULLs + different collation is not efficient | ||
| 72892 | 2014-06-05 16:27 | 2014-06-09 9:39 | MySQL Server: Optimizer | Verified (1834 days) | S3 | Any | Any | Please allow multiple ranges in the LIMIT clause | |||
| 73825 | 2014-09-06 16:45 | 2014-11-06 11:39 | MySQL Server: Optimizer | Verified (1745 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | Wrong result (extra row) with group by, multi-part key |
| Showing 1-30 of 393 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
