| « Show Previous 30 Entries | Showing 31-60 of 387 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | Target | OS | CPU | Summary | Assigned |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 29421 | 2007-06-28 13:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4317 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 (3431 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 (3113 days) | S3 | 5.1.19 | Any | Any | cost calculations are off | ||
| 30302 | 2007-08-08 12:41 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3263 days) | S3 | 5.0.40, 5.1, 5.2, 5.0 BK | Any | Any | Query from EXPLAIN EXTENDED .. SHOW WARNINGS returns different result | Evgeny Potemkin | |
| 30342 | 2007-08-09 18:52 | 2015-10-07 14:54 | MySQL Server: Optimizer | Verified (1294 days) | S5 | 5.0.37, 5.6.17 | Any | Any | Equality propagation can make optimization much slower | ||
| 30733 | 2007-08-30 19:36 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4253 days) | S3 | 5.1.20, 5.0.45, 4.1 BK | Linux | Any | Using where is shown in EXPLAIN output when there is no condition pushdown. | ||
| 31446 | 2007-10-08 12:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3841 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 (4087 days) | S5 | 5.0.45 | Any | Any | read_rnd_buffer_size doesn't seem to be used as written in Reference Manual | ||
| 32341 | 2007-11-13 19:29 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3841 days) | S3 | 5.0.41, 5.0.52 | Linux | Any | Subquery does not use index with session variable, works with string literal | ||
| 34078 | 2008-01-26 14:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4078 days) | S3 | 4.1,5.0,5.1,6.0-BK | Any (Linux) | Any | ref access is not used for varchar column | Evgeny Potemkin | |
| 34080 | 2008-01-26 17:25 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4105 days) | S3 | 5.0.54, 5.0.45 | Linux (Ubuntu) | Any | EXPLAIN EXTENDED converts NULL to empty string | Evgeny Potemkin | |
| 34310 | 2008-02-05 14:51 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (1952 days) | S5 | 5.0.51a-log, 5.0.54, 5.6.14 | Linux | Any | Optimizer is inefficient by using ORDER BY function() and LIMIT | ||
| 34666 | 2008-02-19 14:11 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4012 days) | S3 | 5.0/5.1/6.0.4 | Any | Any | Incomplete metadata returned to client on view + group by + Innodb/Falcon | Evgeny Potemkin | |
| 35633 | 2008-03-28 8:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4043 days) | S1 | 5.0.54, 5.0.56 | Linux (2.6.25-rc4) | Any | Column cant be NULL error on SELECT...FROM (SELECT not_null_column, agg_func...) | ||
| 35724 | 2008-03-31 22:24 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3702 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 | ||
| 35794 | 2008-04-03 12:06 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3963 days) | S3 | 5.0.45, 5.0, 5.1, 6.0 BK | Any | Any | Very bad query optimization on DELETE with subquery | ||
| 36195 | 2008-04-18 2:29 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4012 days) | S3 | 5.1-bk | Any | Any | mysqld calls handler->cond_push twice | ||
| 36300 | 2008-04-23 17:49 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3388 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 | ||
| 36422 | 2008-04-30 2:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4010 days) | S3 | 6.0.x | Any | Any | EXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins | ||
| 36725 | 2008-05-14 20:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3801 days) | S2 | 5.1.22/5.0BK/5.1BK | Linux (Ubuntu 7.04) | Any | UPDATE takes too long to execute | ||
| 36802 | 2008-05-19 15:42 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3858 days) | S3 | 5.0, 5.1, 6.0 BK | 5.6+ | Any | Any | MySQL only use covered index when selecting from a view (or subquery) with union | Evgeny Potemkin |
| 36817 | 2008-05-20 13:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3579 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 | Assigned Account | |
| 37053 | 2008-05-29 4:11 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3871 days) | S3 | 4.1, 5.0, 5.1,6.0.5 | Any (Linux, Solaris) | Any | Optimizer unnecessarily uses temporary and filesort with ORDER BY | Assigned Account | |
| 37264 | 2008-06-07 22:35 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3841 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 (3904 days) | S3 | 5.0/5.1/6.0, 5.7.18 | Any | Any | select count(*); returns value | ||
| 37902 | 2008-07-06 15:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3922 days) | S3 | 5.0.45, 5.0.68 | Mac OS X | Any | Bug (2) in the query optimizer (explain) | ||
| 38251 | 2008-07-21 0:29 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3928 days) | S5 | 5.0.51 | Any | Any | Useless external queries should be ignored | Evgeny Potemkin | |
| 38397 | 2008-07-27 20:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3921 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 (3841 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 (3704 days) | S3 | 4.0, 4.1, 5.0, 5.1, 6.0 | Any | Any | Prefix key search returns wrong result for multi-level collations |
| « Show Previous 30 Entries | Showing 31-60 of 387 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
