Showing 1-30 of 734 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
46853 | 2009-08-21 11:07 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5238 days) | S3 | Any | Any | valgrind warnings in mysql-pe branch with the testcase for the BUG#45816 | |
64036 | 2012-01-15 15:51 | 2012-01-15 19:07 | MySQL Server: Optimizer | Verified (4457 days) | S3 | Any | Any | Use non-materializing loose-scan-merge for certain subqueries in FROM with LIMIT | |
72892 | 2014-06-05 16:27 | 2014-06-09 9:39 | MySQL Server: Optimizer | Verified (3581 days) | S3 | Any | Any | Please allow multiple ranges in the LIMIT clause | |
96137 | 2019-07-09 9:20 | 2019-07-09 16:25 | MySQL Server: Optimizer | Verified (1725 days) | S2 | 5.7.17 MySQL Community Server | Linux | Any | NOT(NOT( FIELD > ALL (SUBQUERY) )) 'S RESULT NOT EQUAL FIELD > ALL (SUBQUERY) |
108150 | 2022-08-16 13:19 | 2023-01-27 16:19 | MySQL Server: Optimizer | Verified (427 days) | S3 | 8.0.30 | Ubuntu (22.04.1) | x86 (x86_x64) | ALL query with UNION and ROLLUP wrong result |
109173 | 2022-11-23 7:51 | 2022-11-24 12:16 | MySQL Server: Optimizer | Verified (491 days) | S5 | .31, 8.0.31 | Any | Any | Contribution: Offset pushdown to InnoDB and removal of redundant conditions |
81803 | 2016-06-10 12:35 | 2016-06-15 16:58 | MySQL Server: Optimizer | Verified (2844 days) | S5 | >=5.1 | Any | Any | Mysql 5.1 and later Update performance regression |
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 |
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 |
39298 | 2008-09-08 6:42 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5506 days) | S3 | 4.0, 4.1, 5.0, 5.1, 6.0 | Any | Any | Prefix key search returns wrong result for multi-level collations |
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 |
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 |
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 |
39944 | 2008-10-09 2:10 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5650 days) | S3 | 4.1, 5.0, 5,1, 6.0 bzr | Any | Any | With join buffer executor ignores index scan |
42808 | 2009-02-12 22:17 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5523 days) | S5 | 4.1, 5.0, 5.1 | Any | Any | Execution Plan Cache |
52174 | 2010-03-18 10:59 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5106 days) | S3 | 4.1, 5.0, 5.1 | Any | Any | Sometimes wrong plan when reading a MAX value from non-NULL index |
37053 | 2008-05-29 4:11 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5673 days) | S3 | 4.1, 5.0, 5.1,6.0.5 | Any (Linux, Solaris) | Any | Optimizer unnecessarily uses temporary and filesort with ORDER BY |
34078 | 2008-01-26 14:19 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5880 days) | S3 | 4.1,5.0,5.1,6.0-BK | Any (Linux) | Any | ref access is not used for varchar column |
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 |
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 |
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 |
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) |
36300 | 2008-04-23 17:49 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5190 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 |
80802 | 2016-03-21 9:22 | 2016-03-21 10:56 | MySQL Server: Optimizer | Verified (2930 days) | S3 | 5..1/5.5/5.6/57 | Any | Any | "ORDER BY expression" does not allow alias to aggregate |
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 |
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 |
54921 | 2010-06-30 16:41 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5021 days) | S3 | 5.0-bzr, 5.1-bzr | Any | Any | ORDER BY doesn't use index if ref lookup on VARBINARY column used |
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 |
45880 | 2009-07-01 14:21 | 2022-09-04 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0, 5.1 | Any | Any | OUTER JOINed tables with no condition in WHERE must be at the end of explain |
46277 | 2009-07-17 21:33 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.0, 5.1, 5.4, 6.0 | Any | Any | differing results for equivalent queries using VAR_POP() & AVG() with DISTINCT |
Showing 1-30 of 734 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |