Showing 1-30 of 466 (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
(2524 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
(1907 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
(1986 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
(3946 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
(3737 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
(4273 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
(1813 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
(2173 days)
S35.6.22AnyAny"select + distinct + group by " works incorrectly
942242019-02-06
16:45
2019-11-17
10:39
MySQL Server: OptimizerVerified
(760 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
(2828 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
(3096 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
(3736 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
(2982 days)
S35.5.30AnyAnyA minor bug in check_simple_equality()
726462014-05-14
9:40
2014-05-14
12:17
MySQL Server: OptimizerVerified
(2490 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
(634 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
(87 days)
S28.0AnyAnyAdding GROUP BY slows down a query.
640022012-01-11
20:01
2012-01-19
11:52
MySQL Server: OptimizerVerified
(3343 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
(1190 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
(2734 days)
S35.6AnyAnyAmbiguous column updated with UPDATE ... JOIN ... USING
657922012-07-03
2:19
2012-07-04
9:54
MySQL Server: OptimizerVerified
(3170 days)
S55.1,5.5AnyAnyan unecessary Using temporary in distinct query
1022922021-01-19
9:54
2021-03-03
8:04
MySQL Server: OptimizerVerified
(47 days)
S38.0.22, 8.0.23Any (CentOS Linux release 8.0.1905 (Core))Any (4.18.0-80.el8.x86_64 )ANALYZE TABLE capitalized table name, statistics results are not updated.
881812017-10-23
5:30
2018-06-11
19:55
MySQL Server: OptimizerVerified
(1232 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
(2471 days)
S35.6.17AnyAnyAssertion `!(ordered_index_usage == ordered_index_void && ... fails
766042015-04-07
4:29
2015-04-07
6:15
MySQL Server: OptimizerVerified
(2162 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
(2329 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
(2796 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
(461 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
(3850 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
(5882 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
(321 days)
S18.0.19AnyAnybad performance in hash join because join with no join condition between tables
  Showing 1-30 of 466 (Edit, Save, CSV, Feed) Show Next 30 Entries »