« Show Previous 30 Entries | Showing 31-60 of 742 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
46283 | 2009-07-18 15:22 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0, 5.1, 5.4, 6.0 | Any | Any | COUNT() returning bad values when LIMIT 1 clause added to query |
8113 | 2005-01-24 15:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5362 days) | S5 | 5.0, 5.1, azalea bzr | Any | Any | Select with between optimization |
46135 | 2009-07-12 19:03 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5022 days) | S2 | 5.0, 5.1, next, 6.0.0, 6.0.2, 5.1.36 | Any | Any | LIMIT + JOIN problem |
50168 | 2010-01-08 2:16 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5214 days) | S3 | 5.0,5.1 | Any | Any | The value of 'rows' in EXPLAIN output is not accurate for LIMIT |
46056 | 2009-07-08 20:24 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0,5.1,5.4 | Any | Any | Duplicate rows returned on MAX + ORDER BY |
46217 | 2009-07-16 11:16 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0,5.1,5.4 | Any | Any | Wrong result on aggregate + JOIN + ORDER BY + LIMIT |
46227 | 2009-07-16 14:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5395 days) | S3 | 5.0,5.1,5.4 | Any | Any | Wrong result on DISTINCT + aggregate + JOIN + InnoDB |
12799 | 2005-08-25 9:46 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5319 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 |
17259 | 2006-02-09 2:23 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5650 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 (3743 days) | S3 | 5.0.18 | Any (All) | Any | Inefficient optimizer for fulltext queries. |
15907 | 2005-12-21 15:23 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5243 days) | S5 | 5.0.19-BK, 5.0.13, 6.0.14-bzr | Linux (Linux) | Any | Binary comparison ignores indexes |
18465 | 2006-03-23 17:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5324 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 |
7604 | 2004-12-31 20:13 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5244 days) | S3 | 5.0.21-BK, 6.0.14 | Linux (Linux) | Any | Row subqueries don't work with ALL |
24697 | 2006-11-29 15:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4861 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 |
19195 | 2006-04-19 12:09 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5324 days) | S3 | 5.0.27-BK, 5.0.21-BK, 5.0.19 | Linux (Linux) | Any | Optimizer does not use proper index for join |
29433 | 2007-06-29 0:03 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5258 days) | S3 | 5.0.27, 5.0, 5.1, 4.1, 5.2 BK, 6.0.14-bzr | Any | Any | composite index not used |
12113 | 2005-07-22 14:23 | 2014-01-24 12:43 | MySQL Server: Optimizer | Verified (3742 days) | S1 | 5.0.28-BK, 4.0,5.0 | Any | Any | Composite index chosen partially for ORDER BY ... LIMIT query. |
25764 | 2007-01-22 20:59 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5567 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. |
30342 | 2007-08-09 18:52 | 2015-10-07 14:54 | MySQL Server: Optimizer | Verified (3121 days) | S5 | 5.0.37, 5.6.17 | Any | Any | Equality propagation can make optimization much slower |
27452 | 2007-03-26 17:35 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5636 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 |
30302 | 2007-08-08 12:41 | 2022-09-04 20:45 | MySQL Server: Optimizer | Verified (5090 days) | S3 | 5.0.40, 5.1, 5.2, 5.0 BK | Any | Any | Query from EXPLAIN EXTENDED .. SHOW WARNINGS returns different result |
32341 | 2007-11-13 19:29 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5668 days) | S3 | 5.0.41, 5.0.52 | Linux | Any | Subquery does not use index with session variable, works with string literal |
31446 | 2007-10-08 12:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5668 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 (5914 days) | S5 | 5.0.45 | Any | Any | read_rnd_buffer_size doesn't seem to be used as written in Reference Manual |
37902 | 2008-07-06 15:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5749 days) | S3 | 5.0.45, 5.0.68 | MacOS | Any | Bug (2) in the query optimizer (explain) |
41350 | 2008-12-10 8:00 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5613 days) | S3 | 5.0.46-log | Linux | Any | String expression collation determined only by the first equality operand |
38251 | 2008-07-21 0:29 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5755 days) | S5 | 5.0.51 | Any | Any | Useless external queries should be ignored |
60185 | 2011-02-20 15:58 | 2011-03-03 8:35 | MySQL Server: Optimizer | Verified (4811 days) | S3 | 5.0.51, 5.5.11 | Linux | Any | index DEPENDENT SUBQUERY |
34310 | 2008-02-05 14:51 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3779 days) | S5 | 5.0.51a-log, 5.0.54, 5.6.14 | Linux | Any | Optimizer is inefficient by using ORDER BY function() and LIMIT |
45424 | 2009-06-10 6:58 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5431 days) | S2 | 5.0.51a, 5.0.77 and 5.1.34, 5.1, 6.0 bzr | Linux | Any | UPDATE statement cause full table scan ? |
« Show Previous 30 Entries | Showing 31-60 of 742 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |