Showing 1-30 of 458 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
722942014-04-09
17:28
2014-04-10
6:24
MySQL Server: OptimizerVerified
(2477 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
(1860 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
(1939 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
(3899 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
(3690 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
(4226 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
(1766 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
(2126 days)
S35.6.22AnyAny"select + distinct + group by " works incorrectly
942242019-02-06
16:45
2019-11-17
10:39
MySQL Server: OptimizerVerified
(713 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
(2781 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
(3049 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
(3689 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
(2935 days)
S35.5.30AnyAnyA minor bug in check_simple_equality()
726462014-05-14
9:40
2014-05-14
12:17
MySQL Server: OptimizerVerified
(2443 days)
S35.5 5.6, 5.6.19AnyAnyA strange result from explain query
957762019-06-13
2:34
2019-06-13
5:38
MySQL Server: OptimizerVerified
(587 days)
S35.7.15-log MySQL Community Server (GPL), 5.6.44, 5.7.26, 8.0.16CentOSAnyAbout FUNCTION STDDEV_SAMP:Data only in different order
1018382020-12-02
19:17
2020-12-11
14:39
MySQL Server: OptimizerVerified
(40 days)
S28.0AnyAnyAdding GROUP BY slows down a query.
640022012-01-11
20:01
2012-01-19
11:52
MySQL Server: OptimizerVerified
(3296 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
(1143 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
(2687 days)
S35.6AnyAnyAmbiguous column updated with UPDATE ... JOIN ... USING
657922012-07-03
2:19
2012-07-04
9:54
MySQL Server: OptimizerVerified
(3123 days)
S55.1,5.5AnyAnyan unecessary Using temporary in distinct query
881812017-10-23
5:30
2018-06-11
19:55
MySQL Server: OptimizerVerified
(1185 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
(2424 days)
S35.6.17AnyAnyAssertion `!(ordered_index_usage == ordered_index_void && ... fails
766042015-04-07
4:29
2015-04-07
6:15
MySQL Server: OptimizerVerified
(2115 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
(2282 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
(2749 days)
S25.5.31, 5.5.32AnyAnyBad interaction between MIN/MAX and "NOT BETWEEN" leads to wrong results
977422019-11-22
8:22
2020-01-20
12:53
MySQL Server: OptimizerVerified
(414 days)
S25.7, 8.0Anyx86bad item ref from correlated subquery to outer distinct table
561652010-08-21
8:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3803 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
(5835 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
992442020-04-14
3:22
2020-04-22
12:45
MySQL Server: OptimizerVerified
(274 days)
S18.0.19AnyAnybad performance in hash join because join with no join condition between tables
928502018-10-19
0:46
2018-10-22
5:31
MySQL Server: OptimizerVerified
(821 days)
S35.7.23AnyAnyBad select+order by+limit performance in 5.7
  Showing 1-30 of 458 (Edit, Save, CSV, Feed) Show Next 30 Entries »