Showing 1-30 of 408 (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
(3583 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
(2007 days)
S35.0.18Any (All)AnyInefficient optimizer for fulltext queries.  
294212007-06-28
13:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4408 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
(4169 days)
S34.1,5.0,5.1,6.0-BKAny (Linux)Anyref access is not used for varchar column Evgeny Potemkin
411092008-11-28
17:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3765 days)
S25.1.30, 5.0, 5.1, 6.0 bzrAnyAnyQuery takes >5 hrs and locks db, when optimised manually takes <1s  
442012009-04-10
3:04
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3325 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
(3659 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
(3620 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
(3388 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
(3332 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
(3210 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
(3130 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
(2958 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
(2748 days)
S35.5.19AnyAnyOptimizer doesn't seem to take into account enum definition  
685542013-03-03
16:16
2016-10-09
20:45
MySQL Server: OptimizerVerified
(2318 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
(2262 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
(2140 days)
S35.6AnyAnyAmbiguous column updated with UPDATE ... JOIN ... USING  
706842013-10-22
8:13
2013-10-22
11:35
MySQL Server: OptimizerVerified
(2100 days)
S35.5.33, 5.6.14AnyAnyHAVING referring to subquery results in WARNING 1292  
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
(1870 days)
S3AnyAnyPlease allow multiple ranges in the LIMIT clause  
738252014-09-06
16:45
2014-11-06
11:39
MySQL Server: OptimizerVerified
(1781 days)
S35.1, 5.5, 5.6, 5.7AnyAnyWrong result (extra row) with group by, multi-part key  
744622014-10-20
19:26
2014-11-01
0:57
MySQL Server: OptimizerVerified
(1725 days)
S35.6.21AnyAnyEXPLAIN FORMAT=JSON produces ordering_operation when no ordering takes place.  
752662014-12-18
16:36
2014-12-18
18:19
MySQL Server: OptimizerVerified
(1678 days)
S25.6.19AnyAnySetting sum of decimal field on user defined variable is not working as expected  
765012015-03-27
6:50
2015-03-27
15:11
MySQL Server: OptimizerVerified
(1579 days)
S35.6.22AnyAny"select + distinct + group by " works incorrectly  
773982015-06-18
8:01
2019-04-29
14:01
MySQL Server: OptimizerVerified
(1133 days)
S15.7.7AnyAnyrow size too large in mysql 5.7 query Shane Bester
796772015-12-16
17:49
2015-12-17
13:47
MySQL Server: OptimizerVerified
(1314 days)
S35.6.27, 5.6.28AnyAnyOptimizer performs a significantly wrong plan  
806552016-03-08
9:10
2016-03-08
9:45
MySQL Server: OptimizerVerified
(1232 days)
S35.6.31AnyAnyError message from UPDATE of non-updatable part of join view is inaccurate  
  Showing 1-30 of 408 (Edit, Save, CSV, Feed) Show Next 30 Entries »