Showing 1-30 of 734 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
468532009-08-21
11:07
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5237 days)
S3AnyAnyvalgrind warnings in mysql-pe branch with the testcase for the BUG#45816
640362012-01-15
15:51
2012-01-15
19:07
MySQL Server: OptimizerVerified
(4456 days)
S3AnyAnyUse non-materializing loose-scan-merge for certain subqueries in FROM with LIMIT
728922014-06-05
16:27
2014-06-09
9:39
MySQL Server: OptimizerVerified
(3580 days)
S3AnyAnyPlease allow multiple ranges in the LIMIT clause
961372019-07-09
9:20
2019-07-09
16:25
MySQL Server: OptimizerVerified
(1724 days)
S2 5.7.17 MySQL Community ServerLinuxAnyNOT(NOT( FIELD > ALL (SUBQUERY) )) 'S RESULT NOT EQUAL FIELD > ALL (SUBQUERY)
1081502022-08-16
13:19
2023-01-27
16:19
MySQL Server: OptimizerVerified
(426 days)
S3 8.0.30Ubuntu (22.04.1)x86 (x86_x64)ALL query with UNION and ROLLUP wrong result
1091732022-11-23
7:51
2022-11-24
12:16
MySQL Server: OptimizerVerified
(490 days)
S5.31, 8.0.31AnyAnyContribution: Offset pushdown to InnoDB and removal of redundant conditions
818032016-06-10
12:35
2016-06-15
16:58
MySQL Server: OptimizerVerified
(2843 days)
S5>=5.1AnyAnyMysql 5.1 and later Update performance regression
70802004-12-07
15:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6998 days)
S34.0Linux (Linux)AnyOptimizer choose incorrect index
186882006-03-31
14:07
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6047 days)
S34.0, 4.1, 5.0Linux (linux)Anynon-optimal plan for SELECT
392982008-09-08
6:42
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5505 days)
S34.0, 4.1, 5.0, 5.1, 6.0AnyAnyPrefix key search returns wrong result for multi-level collations
80362005-01-20
10:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6998 days)
S34.0.18, 4.1.10, 5.1.52FreeBSD (Free BSD 4.5, Linux)AnyBad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB
250682006-12-14
11:56
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5642 days)
S34.0.27, 5.0.19, 5.0.36-BKLinux (Linux)AnyMyISAM-Optimizer prefers full table scan than index for IN with >15 elements
284042007-05-13
18:33
2018-11-11
14:44
MySQL Server: OptimizerVerified
(1964 days)
S24.0.31, 4.1.25, 4.1.26, 5.0.42-BK, 5.0.46, 5.1.33LinuxAnyOptimizer does not consider index that can be used for ORDER BY
399442008-10-09
2:10
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5649 days)
S34.1, 5.0, 5,1, 6.0 bzrAnyAnyWith join buffer executor ignores index scan
428082009-02-12
22:17
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5522 days)
S54.1, 5.0, 5.1AnyAnyExecution Plan Cache
521742010-03-18
10:59
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5105 days)
S34.1, 5.0, 5.1AnyAnySometimes wrong plan when reading a MAX value from non-NULL index
370532008-05-29
4:11
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5672 days)
S34.1, 5.0, 5.1,6.0.5Any (Linux, Solaris)AnyOptimizer unnecessarily uses temporary and filesort with ORDER BY
340782008-01-26
14:19
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5879 days)
S34.1,5.0,5.1,6.0-BKAny (Linux)Anyref access is not used for varchar column
87492005-02-23
21:08
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5293 days)
S34.1.10, 5.0.67Any (*)AnyEXPLAIN report different "type" w and w/o USE INDEX(...) for the same used key
201112006-05-28
10:57
2014-01-24
13:26
MySQL Server: OptimizerVerified
(3716 days)
S54.1.19-logLinux (Linux)Anynamed columns used in subqueries hinder optimisation of LIKE, BETWEEN, range
262322007-02-09
17:28
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6251 days)
S34.1.22, 5.0.34, 5.0.36-BKLinux (Linux)Anyreview of bug #20944 / proof of concept attached
285542007-05-21
9:32
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5424 days)
S34.1.22, 5.0.42-BKAnyAnyOptimizer wrongly prefers index for (col = value) over (PK <= value)
363002008-04-23
17:49
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5189 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
808022016-03-21
9:22
2016-03-21
10:56
MySQL Server: OptimizerVerified
(2929 days)
S35..1/5.5/5.6/57AnyAny"ORDER BY expression" does not allow alias to aggregate
119482005-07-14
18:00
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6812 days)
S35.0AnyAnyMyISAM only, nested JOIN Views, dramatic performance loss
140842005-10-17
20:09
2014-01-23
9:50
MySQL Server: OptimizerVerified
(3717 days)
S35.0-bkAnyAnyindex_merge access method not used for federated engine
549212010-06-30
16:41
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5020 days)
S35.0-bzr, 5.1-bzrAnyAnyORDER BY doesn't use index if ref lookup on VARBINARY column used
142532005-10-24
9:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5201 days)
S35.0, 4.1, 6.0.14-bzrLinux (Linux)AnyOptimizer uses partial indexes for subqueries, where it should not
458802009-07-01
14:21
2022-09-04
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1AnyAnyOUTER JOINed tables with no condition in WHERE must be at the end of explain
462772009-07-17
21:33
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0AnyAnydiffering results for equivalent queries using VAR_POP() & AVG() with DISTINCT
  Showing 1-30 of 734 (Edit, Save, CSV, Feed) Show Next 30 Entries »