Showing 1-30 of 740 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
8113 | 2005-01-24 15:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5358 days) | S5 | 5.0, 5.1, azalea bzr | Any | Any | Select with between optimization |
8662 | 2005-02-21 21:31 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5254 days) | S5 | 6.0.14, 5.1.12-BK, 4.1.10 | Any | Any | optimizer, query takes 3 to 10 times as long when using index |
8749 | 2005-02-23 21:08 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5315 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 |
11948 | 2005-07-14 18:00 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6834 days) | S3 | 5.0 | Any | Any | MyISAM only, nested JOIN Views, dramatic performance loss |
12113 | 2005-07-22 14:23 | 2014-01-24 12:43 | MySQL Server: Optimizer | Verified (3738 days) | S1 | 5.0.28-BK, 4.0,5.0 | Any | Any | Composite index chosen partially for ORDER BY ... LIMIT query. |
14084 | 2005-10-17 20:09 | 2014-01-23 9:50 | MySQL Server: Optimizer | Verified (3739 days) | S3 | 5.0-bk | Any | Any | index_merge access method not used for federated engine |
17299 | 2006-02-10 12:35 | 2014-01-23 9:53 | MySQL Server: Optimizer | Verified (3739 days) | S3 | 5.0.18 | Any (All) | Any | Inefficient optimizer for fulltext queries. |
18465 | 2006-03-23 17:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5320 days) | S2 | 5.0.20-BK, 5.0.19, 5.0.85 | Any (any) | Any | Optimizer/execution plan bug with dependent subqueries in ON clauses of JOINs |
26832 | 2007-03-04 18:17 | 2011-04-05 14:46 | MySQL Server: Optimizer | Verified (4763 days) | S5 | 5.5 | Any | Any | ENUM types not optimized |
28554 | 2007-05-21 9:32 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5446 days) | S3 | 4.1.22, 5.0.42-BK | Any | Any | Optimizer wrongly prefers index for (col = value) over (PK <= value) |
29421 | 2007-06-28 13:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6140 days) | S2 | 5.1.14-beta/5.0 | Any | Any | MySQL allows mixing of GROUP columns with no GROUP columns in complex terms |
29433 | 2007-06-29 0:03 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5254 days) | S3 | 5.0.27, 5.0, 5.1, 4.1, 5.2 BK, 6.0.14-bzr | Any | Any | composite index not used |
29443 | 2007-06-29 13:28 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4936 days) | S3 | 5.1.19 | Any | Any | cost calculations are off |
30302 | 2007-08-08 12:41 | 2022-09-04 20:45 | MySQL Server: Optimizer | Verified (5086 days) | S3 | 5.0.40, 5.1, 5.2, 5.0 BK | Any | Any | Query from EXPLAIN EXTENDED .. SHOW WARNINGS returns different result |
30342 | 2007-08-09 18:52 | 2015-10-07 14:54 | MySQL Server: Optimizer | Verified (3117 days) | S5 | 5.0.37, 5.6.17 | Any | Any | Equality propagation can make optimization much slower |
31446 | 2007-10-08 12:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5664 days) | S5 | 5.0.44, 5.0.37, 6.0.2 Alpha | Any | Any | Inefficient index use with order by and joins |
31901 | 2007-10-29 2:51 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5910 days) | S5 | 5.0.45 | Any | Any | read_rnd_buffer_size doesn't seem to be used as written in Reference Manual |
34078 | 2008-01-26 14:19 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5901 days) | S3 | 4.1,5.0,5.1,6.0-BK | Any (Linux) | Any | ref access is not used for varchar column |
34666 | 2008-02-19 14:11 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5835 days) | S3 | 5.0/5.1/6.0.4 | Any | Any | Incomplete metadata returned to client on view + group by + Innodb/Falcon |
35724 | 2008-03-31 22:24 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5525 days) | S2 | MySQL 5.0.51a-community-nt, 5.1, 6.0 BK | Any | Any | Non-found left join data passed as a parameter to a function in WHERE |
36195 | 2008-04-18 2:29 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5835 days) | S3 | 5.1-bk | Any | Any | mysqld calls handler->cond_push twice |
36422 | 2008-04-30 2:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5833 days) | S3 | 6.0.x | Any | Any | EXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins |
36817 | 2008-05-20 13:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5402 days) | S5 | 5.0.54a,5.1.19, 5.1.25, 5.0.60, 5.5 | Any | Any | Non optimal index choice, depending on index creation order |
37053 | 2008-05-29 4:11 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5694 days) | S3 | 4.1, 5.0, 5.1,6.0.5 | Any (Linux, Solaris) | Any | Optimizer unnecessarily uses temporary and filesort with ORDER BY |
37264 | 2008-06-07 22:35 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5664 days) | S5 | 5.1.24-rc 5.1.29-rc 5.1.30 | Any | Any | MySQL wrongly uses filesort |
37305 | 2008-06-10 9:53 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5727 days) | S3 | 5.0/5.1/6.0, 5.7.18 | Any | Any | select count(*); returns value |
38251 | 2008-07-21 0:29 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5751 days) | S5 | 5.0.51 | Any | Any | Useless external queries should be ignored |
38397 | 2008-07-27 20:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5744 days) | S3 | 5.1.26, 5.0.62 | Any | Any | select distinct + order by desc is executed inefficiently |
38550 | 2008-08-04 21:47 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5664 days) | S5 | 5.0.60, 5.1 | Any | Any | multiple optimizer bugs for queries with references from preceding table |
39298 | 2008-09-08 6:42 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5527 days) | S3 | 4.0, 4.1, 5.0, 5.1, 6.0 | Any | Any | Prefix key search returns wrong result for multi-level collations |
Showing 1-30 of 740 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |