Showing 1-30 of 366 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
70802004-12-07
15:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4985 days)
S34.0Linux (Linux)AnyOptimizer choose incorrect index  
76042004-12-31
20:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3205 days)
S35.0.21-BK, 6.0.14Linux (Linux)AnyRow subqueries don't work with ALL Evgeny Potemkin
80362005-01-20
10:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4985 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
(3323 days)
S55.0, 5.1, azalea bzrAnyAnySelect with between optimization  
81682005-01-27
18:09
2018-09-09
20:45
MySQL Server: OptimizerVerified
(1703 days)
S35.0-bkAnyAnyHELP commands processing different from regular with --ps-protocol  
86622005-02-21
21:31
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3219 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
(3280 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
(4799 days)
S35.0AnyAnyMyISAM only, nested JOIN Views, dramatic performance loss  
121132005-07-22
14:23
2014-01-24
12:43
MySQL Server: OptimizerVerified
(1703 days)
S15.0.28-BK, 4.0,5.0AnyAnyComposite index chosen partially for ORDER BY ... LIMIT query. Assigned Account
127992005-08-25
9:46
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3280 days)
S35.0.10-log, 4.1.13a-log on win, 4.1 on RHES3.05.5+Microsoft Windows (windows xp)Anyone result returned when change from summer time causes dup unique key recs Evgeny Potemkin
140842005-10-17
20:09
2014-01-23
9:50
MySQL Server: OptimizerVerified
(1704 days)
S35.0-bkAnyAnyindex_merge access method not used for federated engine Assigned Account
142532005-10-24
9:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3188 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
(3204 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
(3611 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
(1704 days)
S35.0.18Any (All)AnyInefficient optimizer for fulltext queries.  
177652006-02-28
11:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4589 days)
S3AnyAnyBug in libMySQL.dll with EXPLAIN Evgeny Potemkin
184652006-03-23
17:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3285 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
(4034 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
(3285 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
(1703 days)
S54.1.19-logLinux (Linux)Anynamed columns used in subqueries hinder optimisation of LIKE, BETWEEN, range  
246972006-11-29
15:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(2822 days)
S35.0.24a-community-nt-log/4.1BK/5.0BK/5.1BKMicrosoft Windows (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
(3209 days)
S35.1.14, 5.1.43-bzrLinux (Linux)AnyIndex is not used when joining two tables  
250682006-12-14
11:56
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3629 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
(3528 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
(4238 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
(3969 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
(2728 days)
S55.5AnyAnyENUM types not optimized  
274522007-03-26
17:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3597 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-09-09
20:45
MySQL Server: OptimizerVerified
(3498 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
(3411 days)
S34.1.22, 5.0.42-BKAnyAnyOptimizer wrongly prefers index for (col = value) over (PK <= value)  
  Showing 1-30 of 366 (Edit, Save, CSV, Feed) Show Next 30 Entries »