« Show Previous 30 Entries Showing 31-60 of 458 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
294332007-06-29
0:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4069 days)
S35.0.27, 5.0, 5.1, 4.1, 5.2 BK, 6.0.14-bzrAnyAnycomposite index not used
294432007-06-29
13:28
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3751 days)
S35.1.19AnyAnycost calculations are off
303022007-08-08
12:41
2020-05-03
20:45
MySQL Server: OptimizerVerified
(3901 days)
S35.0.40, 5.1, 5.2, 5.0 BKAnyAnyQuery from EXPLAIN EXTENDED .. SHOW WARNINGS returns different result
303422007-08-09
18:52
2015-10-07
14:54
MySQL Server: OptimizerVerified
(1932 days)
S55.0.37, 5.6.17AnyAnyEquality propagation can make optimization much slower
314462007-10-08
12:14
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4479 days)
S55.0.44, 5.0.37, 6.0.2 AlphaAnyAnyInefficient index use with order by and joins
319012007-10-29
2:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4725 days)
S55.0.45AnyAnyread_rnd_buffer_size doesn't seem to be used as written in Reference Manual
323412007-11-13
19:29
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4479 days)
S35.0.41, 5.0.52LinuxAnySubquery does not use index with session variable, works with string literal
340782008-01-26
14:19
2020-05-03
20:45
MySQL Server: OptimizerVerified
(4716 days)
S34.1,5.0,5.1,6.0-BKAny (Linux)Anyref access is not used for varchar column
340802008-01-26
17:25
2020-05-03
20:45
MySQL Server: OptimizerVerified
(4743 days)
S35.0.54, 5.0.45Linux (Ubuntu)AnyEXPLAIN EXTENDED converts NULL to empty string
343102008-02-05
14:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(2590 days)
S55.0.51a-log, 5.0.54, 5.6.14LinuxAnyOptimizer is inefficient by using ORDER BY function() and LIMIT
346662008-02-19
14:11
2020-05-03
20:45
MySQL Server: OptimizerVerified
(4650 days)
S35.0/5.1/6.0.4AnyAnyIncomplete metadata returned to client on view + group by + Innodb/Falcon
356332008-03-28
8:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4681 days)
S15.0.54, 5.0.56Linux (2.6.25-rc4)AnyColumn cant be NULL error on SELECT...FROM (SELECT not_null_column, agg_func...)
357242008-03-31
22:24
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4340 days)
S2MySQL 5.0.51a-community-nt, 5.1, 6.0 BKAnyAnyNon-found left join data passed as a parameter to a function in WHERE
361952008-04-18
2:29
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4650 days)
S35.1-bkAnyAnymysqld calls handler->cond_push twice
363002008-04-23
17:49
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4026 days)
S34.1.26, 5.0.32, 5.0+, 5.1.43-bzr, 6.0.14-bzrLinuxAnymin() and max() functions returns NULL when using NOT + BETWEEN in where
364222008-04-30
2:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4648 days)
S36.0.xAnyAnyEXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins
367252008-05-14
20:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4439 days)
S25.1.22/5.0BK/5.1BKLinux (Ubuntu 7.04)AnyUPDATE takes too long to execute
368022008-05-19
15:42
2020-05-03
20:45
MySQL Server: OptimizerVerified
(4496 days)
S35.0, 5.1, 6.0 BKAnyAnyMySQL only use covered index when selecting from a view (or subquery) with union
368172008-05-20
13:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4217 days)
S55.0.54a,5.1.19, 5.1.25, 5.0.60, 5.5AnyAnyNon optimal index choice, depending on index creation order
370532008-05-29
4:11
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4509 days)
S34.1, 5.0, 5.1,6.0.5Any (Linux, Solaris)AnyOptimizer unnecessarily uses temporary and filesort with ORDER BY
372642008-06-07
22:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4479 days)
S55.1.24-rc 5.1.29-rc 5.1.30AnyAnyMySQL wrongly uses filesort
373052008-06-10
9:53
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4542 days)
S35.0/5.1/6.0, 5.7.18AnyAnyselect count(*); returns value
379022008-07-06
15:14
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4560 days)
S35.0.45, 5.0.68Mac OS XAnyBug (2) in the query optimizer (explain)
382512008-07-21
0:29
2020-05-03
20:45
MySQL Server: OptimizerVerified
(4566 days)
S55.0.51AnyAnyUseless external queries should be ignored
383972008-07-27
20:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4559 days)
S35.1.26, 5.0.62AnyAnyselect distinct + order by desc is executed inefficiently
385502008-08-04
21:47
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4479 days)
S55.0.60, 5.1AnyAnymultiple optimizer bugs for queries with references from preceding table
392982008-09-08
6:42
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4342 days)
S34.0, 4.1, 5.0, 5.1, 6.0AnyAnyPrefix key search returns wrong result for multi-level collations
399442008-10-09
2:10
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4486 days)
S34.1, 5.0, 5,1, 6.0 bzrAnyAnyWith join buffer executor ignores index scan
401512008-10-19
18:12
2020-05-03
20:45
MySQL Server: OptimizerVerified
(2820 days)
S36.0/5.6AnyAnyEXPLAIN doesn't show DISTINCT+join optimization
410642008-11-27
2:25
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4437 days)
S3MySQL 5.0.27-standard, 5.0.70, 6.0.7LinuxAnyenum query never use index and it should
« Show Previous 30 Entries Showing 31-60 of 458 (Edit, Save, CSV, Feed) Show Next 30 Entries »