| « Show Previous 30 Entries | Showing 31-60 of 739 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 29443 | 2007-06-29 13:28 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4933 days) | S3 | 5.1.19 | Any | Any | cost calculations are off |
| 30302 | 2007-08-08 12:41 | 2022-09-04 20:45 | MySQL Server: Optimizer | Verified (5083 days) | S3 | 5.0.40, 5.1, 5.2, 5.0 BK | Any | Any | Query from EXPLAIN EXTENDED .. SHOW WARNINGS returns different result |
| 30342 | 2007-08-09 18:52 | 2015-10-07 14:54 | MySQL Server: Optimizer | Verified (3114 days) | S5 | 5.0.37, 5.6.17 | Any | Any | Equality propagation can make optimization much slower |
| 31446 | 2007-10-08 12:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5661 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 (5907 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 (5661 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 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5898 days) | S3 | 4.1,5.0,5.1,6.0-BK | Any (Linux) | Any | ref access is not used for varchar column |
| 34080 | 2008-01-26 17:25 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5925 days) | S3 | 5.0.54, 5.0.45 | Linux (Ubuntu) | Any | EXPLAIN EXTENDED converts NULL to empty string |
| 34310 | 2008-02-05 14:51 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3772 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 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5832 days) | S3 | 5.0/5.1/6.0.4 | Any | Any | Incomplete metadata returned to client on view + group by + Innodb/Falcon |
| 35633 | 2008-03-28 8:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5863 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 (5522 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 |
| 36195 | 2008-04-18 2:29 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5832 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 (5208 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 (5830 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 (5621 days) | S2 | 5.1.22/5.0BK/5.1BK | Linux (Ubuntu 7.04) | Any | UPDATE takes too long to execute |
| 36817 | 2008-05-20 13:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5399 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 |
| 37053 | 2008-05-29 4:11 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5691 days) | S3 | 4.1, 5.0, 5.1,6.0.5 | Any (Linux, Solaris) | Any | Optimizer unnecessarily uses temporary and filesort with ORDER BY |
| 37264 | 2008-06-07 22:35 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5661 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 (5724 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 (5742 days) | S3 | 5.0.45, 5.0.68 | MacOS | Any | Bug (2) in the query optimizer (explain) |
| 38251 | 2008-07-21 0:29 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5748 days) | S5 | 5.0.51 | Any | Any | Useless external queries should be ignored |
| 38397 | 2008-07-27 20:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5741 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 (5661 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 (5524 days) | S3 | 4.0, 4.1, 5.0, 5.1, 6.0 | Any | Any | Prefix key search returns wrong result for multi-level collations |
| 39944 | 2008-10-09 2:10 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5668 days) | S3 | 4.1, 5.0, 5,1, 6.0 bzr | Any | Any | With join buffer executor ignores index scan |
| 40151 | 2008-10-19 18:12 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (4002 days) | S3 | 6.0/5.6 | Any | Any | EXPLAIN doesn't show DISTINCT+join optimization |
| 41064 | 2008-11-27 2:25 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5619 days) | S3 | MySQL 5.0.27-standard, 5.0.70, 6.0.7 | Linux | Any | enum query never use index and it should |
| 41109 | 2008-11-28 17:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5494 days) | S2 | 5.1.30, 5.0, 5.1, 6.0 bzr | Any | Any | Query takes >5 hrs and locks db, when optimised manually takes <1s |
| 41220 | 2008-12-04 9:59 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5355 days) | S5 | 5.1.30, 5.0, 5.1, azalea bzr | Any | Any | LEFT JOIN with compound clause uses table scan, while INNER JOIN uses indexes |
| « Show Previous 30 Entries | Showing 31-60 of 739 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
