Showing 1-30 of 347 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version Target OS Summary Assigned
70802004-12-07
15:23
2011-02-16
23:43
MySQL Server: OptimizerVerified
(4584 days)
S34.0Linux (Linux)Optimizer choose incorrect index  
76042004-12-31
20:13
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2804 days)
S35.0.21-BK, 6.0.14Linux (Linux)Row subqueries don't work with ALL Evgeny Potemkin
80362005-01-20
10:12
2011-02-16
23:43
MySQL Server: OptimizerVerified
(4584 days)
S34.0.18, 4.1.10, 5.1.52FreeBSD (Free BSD 4.5, Linux)Bad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB  
81132005-01-24
15:43
2014-05-30
15:28
MySQL Server: OptimizerVerified
(2922 days)
S55.0, 5.1, azalea bzrAnySelect with between optimization  
81682005-01-27
18:09
2014-01-24
12:29
MySQL Server: OptimizerVerified
(1302 days)
S35.0-bkAnyHELP commands processing different from regular with --ps-protocol  
86622005-02-21
21:31
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2818 days)
S56.0.14, 5.1.12-BK, 4.1.10Anyoptimizer, query takes 3 to 10 times as long when using index  
87492005-02-23
21:08
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2879 days)
S34.1.10, 5.0.67Any (*)EXPLAIN report different "type" w and w/o USE INDEX(...) for the same used key  
119482005-07-14
18:00
2011-02-16
23:43
MySQL Server: OptimizerVerified
(4398 days)
S35.0AnyMyISAM only, nested JOIN Views, dramatic performance loss  
121132005-07-22
14:23
2014-01-24
12:43
MySQL Server: OptimizerVerified
(1302 days)
S15.0.28-BK, 4.0,5.0AnyComposite index chosen partially for ORDER BY ... LIMIT query. Assigned Account
127992005-08-25
9:46
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2879 days)
S35.0.10-log, 4.1.13a-log on win, 4.1 on RHES3.05.5+Microsoft Windows (windows xp)one 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
(1303 days)
S35.0-bkAnyindex_merge access method not used for federated engine Assigned Account
142202005-10-21
21:00
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2762 days)
S34.0, 4.1, 5.0, 5.1AnyOptimizer does not use index when using numeric lookup on varchar field (MyISAM)  
142532005-10-24
9:26
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2787 days)
S35.0, 4.1, 6.0.14-bzrLinux (Linux)Optimizer uses partial indexes for subqueries, where it should not  
159072005-12-21
15:23
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2803 days)
S55.0.19-BK, 5.0.13, 6.0.14-bzrLinux (Linux)Binary comparison ignores indexes  
172592006-02-09
2:23
2015-06-22
18:36
MySQL Server: OptimizerVerified
(3210 days)
S55.0.15, 6.0.7Linux (Linux)Query optimizer chooses wrong index  
172992006-02-10
12:35
2014-01-23
9:53
MySQL Server: OptimizerVerified
(1303 days)
S35.0.18Any (All)Inefficient optimizer for fulltext queries.  
177652006-02-28
11:12
2012-05-18
20:19
MySQL Server: OptimizerVerified
(4188 days)
S3AnyBug in libMySQL.dll with EXPLAIN Evgeny Potemkin
184652006-03-23
17:43
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2884 days)
S25.0.20-BK, 5.0.19, 5.0.85Any (any)Optimizer/execution plan bug with dependent subqueries in ON clauses of JOINs  
186882006-03-31
14:07
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3633 days)
S34.0, 4.1, 5.0Linux (linux)non-optimal plan for SELECT  
191952006-04-19
12:09
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2884 days)
S35.0.27-BK, 5.0.21-BK, 5.0.19Linux (Linux)Optimizer does not use proper index for join  
201112006-05-28
10:57
2014-01-24
13:26
MySQL Server: OptimizerVerified
(1302 days)
S54.1.19-logLinux (Linux)named columns used in subqueries hinder optimisation of LIKE, BETWEEN, range  
246972006-11-29
15:13
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2421 days)
S35.0.24a-community-nt-log/4.1BK/5.0BK/5.1BKMicrosoft Windows (Windows 2000 and Linux)insert .. select ....ON DUPLICATE KEY UPDATE fails with ambiguous column name  
247542006-12-01
13:34
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2808 days)
S35.1.14, 5.1.43-bzrLinux (Linux)Index is not used when joining two tables  
250682006-12-14
11:56
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3228 days)
S34.0.27, 5.0.19, 5.0.36-BKLinux (Linux)MyISAM-Optimizer prefers full table scan than index for IN with >15 elements  
257642007-01-22
20:59
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3127 days)
S35.0.36-BK, 6.0.8-bzrLinux (Linux, Mac OS X)Query Cost Estimate seems to only cover a part of subqueries, not full query.  
262322007-02-09
17:28
2012-05-18
20:19
MySQL Server: OptimizerVerified
(3837 days)
S34.1.22, 5.0.34, 5.0.36-BKLinux (Linux)review of bug #20944 / proof of concept attached  
262842007-02-12
12:32
2012-05-18
20:19
MySQL Server: OptimizerVerified
(3568 days)
S35.0.bkLinux (Linux)bug #26273 / optimize, not executed for index, if datafile is gap-free  
266302007-02-26
11:21
2017-02-17
0:09
MySQL Server: OptimizerVerified
(3228 days)
S55.1.18-BK, 5.1.14-betaLinux (linux)Partition pruning not working against joins  
268322007-03-04
18:17
2011-04-05
14:46
MySQL Server: OptimizerVerified
(2327 days)
S55.5AnyENUM types not optimized  
274522007-03-26
17:35
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3196 days)
S35.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzrLinuxCorrelated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA  
  Showing 1-30 of 347 (Edit, Save, CSV, Feed) Show Next 30 Entries »