Showing 1-30 of 393 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
87492005-02-23
21:08
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3547 days)
S34.1.10, 5.0.67Any (*)AnyEXPLAIN report different "type" w and w/o USE INDEX(...) for the same used key  
172992006-02-10
12:35
2014-01-23
9:53
MySQL Server: OptimizerVerified
(1971 days)
S35.0.18Any (All)AnyInefficient optimizer for fulltext queries.  
250682006-12-14
11:56
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3896 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  
294212007-06-28
13:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4372 days)
S25.1.14-beta/5.0AnyAnyMySQL allows mixing of GROUP columns with no GROUP columns in complex terms  
340782008-01-26
14:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4133 days)
S34.1,5.0,5.1,6.0-BKAny (Linux)Anyref access is not used for varchar column Evgeny Potemkin
363002008-04-23
17:49
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3443 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  
379022008-07-06
15:14
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3977 days)
S35.0.45, 5.0.68Mac OS XAnyBug (2) in the query optimizer (explain)  
411092008-11-28
17:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3729 days)
S25.1.30, 5.0, 5.1, 6.0 bzrAnyAnyQuery takes >5 hrs and locks db, when optimised manually takes <1s  
429482009-02-17
23:02
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3758 days)
S55.0.67-0ubuntu6, 6.0.11Linux (Ubuntu 8.10)AnyMySQL Optimizer does not properly use Indexes on Views with "Group By"  
442012009-04-10
3:04
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3289 days)
S35.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99AnyAnyPerformance problem with View  
456802009-06-23
14:15
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0.54, 5.0.82, 5.1.35, 6.0.12AnyAnywrong results when using index for lookup with implicitly casted values  
462272009-07-16
14:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3623 days)
S35.0,5.1,5.4AnyAnyWrong result on DISTINCT + aggregate + JOIN + InnoDB  
467172009-08-14
11:14
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3584 days)
S55.1.32AnyAnyUnnecessary joins are not optimized away  
481902009-10-20
14:59
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1,6.0AnyAnyError processing ALL subqueries on empty sets - different than JavaDB/Postgres  
503882010-01-16
4:13
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS55.1.41,5.1.42, 5.1.43-bzrAnyAnypartition pruning not working with some right joins  
527622010-04-12
10:49
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3352 days)
S55.3AnyAnylike should be index optimised if starts with _ rather than %  
543122010-06-07
22:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3296 days)
S35.1.47, 5.1.48-bzrAnyAnyinsert ... select .. order by rand(): difference depending on indexes.  
572162010-10-04
12:59
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3174 days)
S35.1, 5.6.99 bzrAnyAnyInnoDB column prefix index not treated as a covering one  
591872010-12-27
15:31
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3094 days)
S25.1.55, 5.6.2-m5AnyAnyWrong result with NULL NOT IN subquery Roy Lyseng
615512011-06-17
12:26
2011-06-18
8:34
MySQL Server: OptimizerVerified
(2922 days)
S35.1.56AnyAnyLoose index scan is not used for select COUNT(distinct a)  
640162012-01-12
19:38
2012-01-19
11:48
MySQL Server: OptimizerVerified
(2712 days)
S35.5.19AnyAnyOptimizer doesn't seem to take into account enum definition  
668492012-09-17
18:49
2013-06-10
19:50
MySQL Server: OptimizerVerified
(2198 days)
S15.5.16, 5.1.70, 5.5.32, 5.6.12LinuxAny[REGRESSION] this query hangs the server (100% CPU for several minutes)  
685542013-03-03
16:16
2016-10-09
20:45
MySQL Server: OptimizerVerified
(2282 days)
S55.6.10AnyAnyOptimizer wrongly choses covering index over ICP Assigned Account
692192013-05-13
20:14
2013-05-13
20:32
MySQL Server: OptimizerVerified
(2226 days)
S55.6.12AnyAnyCREATE TEMPORARY TABLE ... SELECT is slower on 5.6 than on 5.1  
703142013-09-12
12:28
2013-09-12
14:07
MySQL Server: OptimizerVerified
(2104 days)
S35.6AnyAnyAmbiguous column updated with UPDATE ... JOIN ... USING  
706842013-10-22
8:13
2013-10-22
11:35
MySQL Server: OptimizerVerified
(2064 days)
S35.5.33, 5.6.14AnyAnyHAVING referring to subquery results in WARNING 1292  
712062013-12-22
17:13
2013-12-31
20:00
MySQL Server: OptimizerVerified
(2002 days)
S15.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3Linux (ubuntu 12.04)AnyGROUP_CONCAT changes GROUP BY behavior  
725012014-05-01
17:31
2014-05-01
18:12
MySQL Server: OptimizerVerifiedS35.6.17AnyAnyjoining NULLs + different collation is not efficient  
728922014-06-05
16:27
2014-06-09
9:39
MySQL Server: OptimizerVerified
(1834 days)
S3AnyAnyPlease allow multiple ranges in the LIMIT clause  
738252014-09-06
16:45
2014-11-06
11:39
MySQL Server: OptimizerVerified
(1745 days)
S35.1, 5.5, 5.6, 5.7AnyAnyWrong result (extra row) with group by, multi-part key  
  Showing 1-30 of 393 (Edit, Save, CSV, Feed) Show Next 30 Entries »