Showing 1-30 of 735 (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 (6999 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 (5219 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 (6999 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 (5337 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 (5233 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 (5294 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 (6813 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 (3717 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 (5294 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 (3718 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 (5202 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 (5218 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 (5625 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 (3718 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 (5299 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 (6048 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 (5299 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 (3717 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 (4836 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 (5223 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 (5643 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 (5542 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 (6252 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 (5983 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 (4742 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 (5611 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 (1965 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 (5425 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 (6119 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 (5233 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 735 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |