| Showing 1-30 of 908 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 7080 | 2004-12-07 15:23 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (7471 days) | S3 | 4.0 | Linux (Linux) | Any | Optimizer choose incorrect index |
| 7604 | 2004-12-31 20:13 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5691 days) | S3 | 5.0.21-BK, 6.0.14 | Linux (Linux) | Any | Row subqueries don't work with ALL |
| 8036 | 2005-01-20 10:12 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (7471 days) | S3 | 4.0.18, 4.1.10, 5.1.52 | FreeBSD (Free BSD 4.5, Linux) | Any | Bad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB |
| 8113 | 2005-01-24 15:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5809 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 (5705 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 (5766 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 (7285 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 (4189 days) | S1 | 5.0.28-BK, 4.0,5.0 | Any | Any | Composite index chosen partially for ORDER BY ... LIMIT query. |
| 12799 | 2005-08-25 9:46 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5766 days) | S3 | 5.0.10-log, 4.1.13a-log on win, 4.1 on RHES3.0 | Windows (windows xp) | Any | one result returned when change from summer time causes dup unique key recs |
| 14084 | 2005-10-17 20:09 | 2014-01-23 9:50 | MySQL Server: Optimizer | Verified (4190 days) | S3 | 5.0-bk | Any | Any | index_merge access method not used for federated engine |
| 14253 | 2005-10-24 9:26 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5674 days) | S3 | 5.0, 4.1, 6.0.14-bzr | Linux (Linux) | Any | Optimizer uses partial indexes for subqueries, where it should not |
| 15907 | 2005-12-21 15:23 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5690 days) | S5 | 5.0.19-BK, 5.0.13, 6.0.14-bzr | Linux (Linux) | Any | Binary comparison ignores indexes |
| 17259 | 2006-02-09 2:23 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6097 days) | S5 | 5.0.15, 6.0.7 | Linux (Linux) | Any | Query optimizer chooses wrong index |
| 17299 | 2006-02-10 12:35 | 2014-01-23 9:53 | MySQL Server: Optimizer | Verified (4190 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 (5771 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 |
| 18688 | 2006-03-31 14:07 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6520 days) | S3 | 4.0, 4.1, 5.0 | Linux (linux) | Any | non-optimal plan for SELECT |
| 19195 | 2006-04-19 12:09 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5771 days) | S3 | 5.0.27-BK, 5.0.21-BK, 5.0.19 | Linux (Linux) | Any | Optimizer does not use proper index for join |
| 20111 | 2006-05-28 10:57 | 2014-01-24 13:26 | MySQL Server: Optimizer | Verified (4189 days) | S5 | 4.1.19-log | Linux (Linux) | Any | named columns used in subqueries hinder optimisation of LIKE, BETWEEN, range |
| 24697 | 2006-11-29 15:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5308 days) | S3 | 5.0.24a-community-nt-log/4.1BK/5.0BK/5.1BK | Windows (Windows 2000 and Linux) | Any | insert .. select ....ON DUPLICATE KEY UPDATE fails with ambiguous column name |
| 24754 | 2006-12-01 13:34 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5695 days) | S3 | 5.1.14, 5.1.43-bzr | Linux (Linux) | Any | Index is not used when joining two tables |
| 25068 | 2006-12-14 11:56 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6115 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 |
| 25764 | 2007-01-22 20:59 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6014 days) | S3 | 5.0.36-BK, 6.0.8-bzr | Linux (Linux, Mac OS X) | Any | Query Cost Estimate seems to only cover a part of subqueries, not full query. |
| 26232 | 2007-02-09 17:28 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6724 days) | S3 | 4.1.22, 5.0.34, 5.0.36-BK | Linux (Linux) | Any | review of bug #20944 / proof of concept attached |
| 26284 | 2007-02-12 12:32 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6455 days) | S3 | 5.0.bk | Linux (Linux) | Any | bug #26273 / optimize, not executed for index, if datafile is gap-free |
| 26832 | 2007-03-04 18:17 | 2011-04-05 14:46 | MySQL Server: Optimizer | Verified (5214 days) | S5 | 5.5 | Any | Any | ENUM types not optimized |
| 27452 | 2007-03-26 17:35 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6083 days) | S3 | 5.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzr | Linux | Any | Correlated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA |
| 28404 | 2007-05-13 18:33 | 2018-11-11 14:44 | MySQL Server: Optimizer | Verified (2437 days) | S2 | 4.0.31, 4.1.25, 4.1.26, 5.0.42-BK, 5.0.46, 5.1.33 | Linux | Any | Optimizer does not consider index that can be used for ORDER BY |
| 28554 | 2007-05-21 9:32 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5897 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 (6591 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 (5705 days) | S3 | 5.0.27, 5.0, 5.1, 4.1, 5.2 BK, 6.0.14-bzr | Any | Any | composite index not used |
| Showing 1-30 of 908 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
