Showing 1-30 of 388 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
722942014-04-09
17:28
2014-04-10
6:24
MySQL Server: OptimizerVerified
(1842 days)
S35.5-debug, 5.6-debugAnyAny Assertion `0' fails on killing INSERT .. SELECT into a FEDERATED table  
773402015-06-12
22:34
2015-12-18
10:58
MySQL Server: OptimizerVerified
(1225 days)
S35.6.25, 5.7.7AnyAny Optimizer chooses wrong index for LEFT JOIN query  
786122015-09-28
22:46
2018-10-21
9:21
MySQL Server: OptimizerVerified
(1304 days)
S35.5.45, 5.6.26, 5.7.8,5.5.47, 5.6.28,5.7.10AnyAny Optimizer chooses wrong index for ORDER BY  
537932010-05-19
9:52
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3264 days)
S36.0-codebase-bugfixingAnyAny"early NULL filtering" not done for outer join converted to inner join  
589282010-12-14
20:58
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3055 days)
S35.1-bugteamAnyAny"not exists" optimization not applied if relevant table is not single inner one  
457762009-06-26
7:17
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3591 days)
S5mysql-5.1.35LinuxAny"OR" condition on SPATIAL index not optimized  
808022016-03-21
9:22
2016-03-21
10:56
MySQL Server: OptimizerVerified
(1131 days)
S35..1/5.5/5.6/57AnyAny"ORDER BY expression" does not allow alias to aggregate  
765012015-03-27
6:50
2015-03-27
15:11
MySQL Server: OptimizerVerified
(1491 days)
S35.6.22AnyAny"select + distinct + group by " works incorrectly  
942242019-02-06
16:45
2019-02-07
8:56
MySQL Server: OptimizerVerified
(78 days)
S35.6, 5.6.43Any (any)Any (any)[5.6] Optimizer reconsiders index based on index definition order, not value  
668492012-09-17
18:49
2013-06-10
19:50
MySQL Server: OptimizerVerified
(2146 days)
S15.5.16, 5.1.70, 5.5.32, 5.6.12LinuxAny[REGRESSION] this query hangs the server (100% CPU for several minutes)  
668252012-09-14
22:38
2012-09-15
18:02
MySQL Server: OptimizerVerified
(2414 days)
S35.5.27AnyAny5.5 ignores an index if BINARY is used  
589242010-12-14
18:38
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3054 days)
S35.1.44, 5.0, 5.1, 5.6.1LinuxAnya LIMIT after a UNION doesn't propogate to all queries  
680442013-01-06
22:02
2013-01-07
1:30
MySQL Server: OptimizerVerified
(2300 days)
S35.5.30AnyAnyA minor bug in check_simple_equality()  
726462014-05-14
9:40
2014-05-14
12:17
MySQL Server: OptimizerVerified
(1808 days)
S35.5 5.6, 5.6.19AnyAnyA strange result from explain query  
640022012-01-11
20:01
2012-01-19
11:52
MySQL Server: OptimizerVerified
(2661 days)
S15.5.19Any (Debian, Windows XP)AnyAggregate queries with multiple columns and no GROUP BY produce bogus results  
886712017-11-28
0:16
2017-12-04
15:41
MySQL Server: OptimizerVerified
(508 days)
S55.7.19AnyAnyALL + BNL chosen over REF in query plan with a simple SELECT + JOIN  
703142013-09-12
12:28
2013-09-12
14:07
MySQL Server: OptimizerVerified
(2052 days)
S35.6AnyAnyAmbiguous column updated with UPDATE ... JOIN ... USING  
657922012-07-03
2:19
2012-07-04
9:54
MySQL Server: OptimizerVerified
(2488 days)
S55.1,5.5AnyAnyan unecessary Using temporary in distinct query  
881812017-10-23
5:30
2018-06-11
19:55
MySQL Server: OptimizerVerified
(550 days)
S35.7.20AnyAnyAnother example of optimizer choosing ref over range when range is faster  
728142014-05-30
9:31
2014-07-18
18:56
MySQL Server: OptimizerVerified
(1789 days)
S35.6.17AnyAnyAssertion `!(ordered_index_usage == ordered_index_void && ... fails  
766042015-04-07
4:29
2015-04-07
6:15
MySQL Server: OptimizerVerified
(1480 days)
S35.6.23, 5.6.24, 5.6.25, 5.7.8Linux (CentOS 7)AnyAssertion `length > 0 && keyparts != 0' failed in create_ref_for_key  
744902014-10-22
2:08
2014-10-22
6:57
MySQL Server: OptimizerVerified
(1647 days)
S35.6.20-debug, 5.6.22Linux (CentOS 7)AnyAssertion `table->key_read == 0' failed | sig 6 in close_open_tables  
697292013-07-12
2:18
2018-07-12
12:54
MySQL Server: OptimizerVerified
(2114 days)
S25.5.31, 5.5.32AnyAnyBad interaction between MIN/MAX and "NOT BETWEEN" leads to wrong results  
561652010-08-21
8:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3168 days)
S35.0.not_sure, 5.0, 5.1, 5.6.99 bzrAnyAnyBad Optimization  
80362005-01-20
10:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5200 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  
928502018-10-19
0:46
2018-10-22
5:31
MySQL Server: OptimizerVerified
(186 days)
S35.7.23AnyAnyBad select+order by+limit performance in 5.7  
869732017-07-06
13:26
2017-07-07
7:19
MySQL Server: OptimizerVerified
(658 days)
S15.6, 5.5.56, 5.6.36, 5.7.18AnyAnyBIN() function error  
159072005-12-21
15:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3419 days)
S55.0.19-BK, 5.0.13, 6.0.14-bzrLinux (Linux)AnyBinary comparison ignores indexes  
635632011-12-03
14:09
2011-12-05
7:50
MySQL Server: OptimizerVerified
(2700 days)
S25.5.17AnyAnyBinary operator now causes a full scan  
697212013-07-11
4:55
2018-12-17
15:08
MySQL Server: OptimizerVerified
(2115 days)
S35.6, 5.6.39, 5.7.21AnyAnyBlock Nested Loop making things slower  
  Showing 1-30 of 388 (Edit, Save, CSV, Feed) Show Next 30 Entries »