Showing 1-30 of 735 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
81132005-01-24
15:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5337 days)
S55.0, 5.1, azalea bzrAnyAnySelect with between optimization
86622005-02-21
21:31
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5233 days)
S56.0.14, 5.1.12-BK, 4.1.10AnyAnyoptimizer, query takes 3 to 10 times as long when using index
87492005-02-23
21:08
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5294 days)
S34.1.10, 5.0.67Any (*)AnyEXPLAIN report different "type" w and w/o USE INDEX(...) for the same used key
119482005-07-14
18:00
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6813 days)
S35.0AnyAnyMyISAM only, nested JOIN Views, dramatic performance loss
121132005-07-22
14:23
2014-01-24
12:43
MySQL Server: OptimizerVerified
(3717 days)
S15.0.28-BK, 4.0,5.0AnyAnyComposite index chosen partially for ORDER BY ... LIMIT query.
140842005-10-17
20:09
2014-01-23
9:50
MySQL Server: OptimizerVerified
(3718 days)
S35.0-bkAnyAnyindex_merge access method not used for federated engine
172992006-02-10
12:35
2014-01-23
9:53
MySQL Server: OptimizerVerified
(3718 days)
S35.0.18Any (All)AnyInefficient optimizer for fulltext queries.
184652006-03-23
17:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5299 days)
S25.0.20-BK, 5.0.19, 5.0.85Any (any)AnyOptimizer/execution plan bug with dependent subqueries in ON clauses of JOINs
268322007-03-04
18:17
2011-04-05
14:46
MySQL Server: OptimizerVerified
(4742 days)
S55.5AnyAnyENUM types not optimized
285542007-05-21
9:32
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5425 days)
S34.1.22, 5.0.42-BKAnyAnyOptimizer wrongly prefers index for (col = value) over (PK <= value)
294212007-06-28
13:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6119 days)
S25.1.14-beta/5.0AnyAnyMySQL allows mixing of GROUP columns with no GROUP columns in complex terms
294332007-06-29
0:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5233 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
(4915 days)
S35.1.19AnyAnycost calculations are off
303022007-08-08
12:41
2022-09-04
20:45
MySQL Server: OptimizerVerified
(5065 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
(3096 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
(5643 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
(5889 days)
S55.0.45AnyAnyread_rnd_buffer_size doesn't seem to be used as written in Reference Manual
340782008-01-26
14:19
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5880 days)
S34.1,5.0,5.1,6.0-BKAny (Linux)Anyref access is not used for varchar column
346662008-02-19
14:11
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5814 days)
S35.0/5.1/6.0.4AnyAnyIncomplete metadata returned to client on view + group by + Innodb/Falcon
357242008-03-31
22:24
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5504 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
(5814 days)
S35.1-bkAnyAnymysqld calls handler->cond_push twice
364222008-04-30
2:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5812 days)
S36.0.xAnyAnyEXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins
368172008-05-20
13:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5381 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
(5673 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
(5643 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
(5706 days)
S35.0/5.1/6.0, 5.7.18AnyAnyselect count(*); returns value
382512008-07-21
0:29
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5730 days)
S55.0.51AnyAnyUseless external queries should be ignored
383972008-07-27
20:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5723 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
(5643 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
(5506 days)
S34.0, 4.1, 5.0, 5.1, 6.0AnyAnyPrefix key search returns wrong result for multi-level collations
  Showing 1-30 of 735 (Edit, Save, CSV, Feed) Show Next 30 Entries »