Showing 1-30 of 738 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
70802004-12-07
15:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6998 days)
S34.0Linux (Linux)AnyOptimizer choose incorrect index
76042004-12-31
20:13
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5218 days)
S35.0.21-BK, 6.0.14Linux (Linux)AnyRow subqueries don't work with ALL
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
81132005-01-24
15:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5336 days)
S55.0, 5.1, azalea bzrAnyAnySelect with between optimization
86622005-02-21
21:31
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5232 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
(5293 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
(6812 days)
S35.0AnyAnyMyISAM only, nested JOIN Views, dramatic performance loss
121132005-07-22
14:23
2014-01-24
12:43
MySQL Server: OptimizerVerified
(3716 days)
S15.0.28-BK, 4.0,5.0AnyAnyComposite index chosen partially for ORDER BY ... LIMIT query.
127992005-08-25
9:46
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5293 days)
S35.0.10-log, 4.1.13a-log on win, 4.1 on RHES3.0Windows (windows xp)Anyone result returned when change from summer time causes dup unique key recs
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
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
159072005-12-21
15:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5217 days)
S55.0.19-BK, 5.0.13, 6.0.14-bzrLinux (Linux)AnyBinary comparison ignores indexes
172592006-02-09
2:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5624 days)
S55.0.15, 6.0.7Linux (Linux)AnyQuery optimizer chooses wrong index
172992006-02-10
12:35
2014-01-23
9:53
MySQL Server: OptimizerVerified
(3717 days)
S35.0.18Any (All)AnyInefficient optimizer for fulltext queries.
184652006-03-23
17:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5298 days)
S25.0.20-BK, 5.0.19, 5.0.85Any (any)AnyOptimizer/execution plan bug with dependent subqueries in ON clauses of JOINs
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
191952006-04-19
12:09
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5298 days)
S35.0.27-BK, 5.0.21-BK, 5.0.19Linux (Linux)AnyOptimizer does not use proper index for join
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
242512006-11-13
10:58
2018-09-09
20:45
MySQL Server: OptimizerIn progress
(5239 days)
S55.0.30-BK, 5.1.12Linux (Linux, Win XP SP2)AnyNon-optimal choice of indexes for queries
246972006-11-29
15:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4835 days)
S35.0.24a-community-nt-log/4.1BK/5.0BK/5.1BKWindows (Windows 2000 and Linux)Anyinsert .. select ....ON DUPLICATE KEY UPDATE fails with ambiguous column name
247542006-12-01
13:34
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5222 days)
S35.1.14, 5.1.43-bzrLinux (Linux)AnyIndex is not used when joining two tables
247702006-12-02
0:37
2018-09-09
20:45
MySQL Server: OptimizerIn progress
(4756 days)
S55.1Any (all)Anyupdate with subquery slow
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
257642007-01-22
20:59
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5541 days)
S35.0.36-BK, 6.0.8-bzrLinux (Linux, Mac OS X)AnyQuery Cost Estimate seems to only cover a part of subqueries, not full query.
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
262842007-02-12
12:32
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5982 days)
S35.0.bkLinux (Linux)Anybug #26273 / optimize, not executed for index, if datafile is gap-free
268322007-03-04
18:17
2011-04-05
14:46
MySQL Server: OptimizerVerified
(4741 days)
S55.5AnyAnyENUM types not optimized
274522007-03-26
17:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5610 days)
S35.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzrLinuxAnyCorrelated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA
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
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)
  Showing 1-30 of 738 (Edit, Save, CSV, Feed) Show Next 30 Entries »