Showing 1-30 of 466 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
72294 | 2014-04-09 17:28 | 2014-04-10 6:24 | MySQL Server: Optimizer | Verified (2524 days) | S3 | 5.5-debug, 5.6-debug | Any | Any | Assertion `0' fails on killing INSERT .. SELECT into a FEDERATED table |
77340 | 2015-06-12 22:34 | 2015-12-18 10:58 | MySQL Server: Optimizer | Verified (1907 days) | S3 | 5.6.25, 5.7.7 | Any | Any | Optimizer chooses wrong index for LEFT JOIN query |
78612 | 2015-09-28 22:46 | 2018-10-21 9:21 | MySQL Server: Optimizer | Verified (1986 days) | S3 | 5.5.45, 5.6.26, 5.7.8,5.5.47, 5.6.28,5.7.10 | Any | Any | Optimizer chooses wrong index for ORDER BY |
53793 | 2010-05-19 9:52 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3946 days) | S3 | 6.0-codebase-bugfixing | Any | Any | "early NULL filtering" not done for outer join converted to inner join |
58928 | 2010-12-14 20:58 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3737 days) | S3 | 5.1-bugteam | Any | Any | "not exists" optimization not applied if relevant table is not single inner one |
45776 | 2009-06-26 7:17 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4273 days) | S5 | mysql-5.1.35 | Linux | Any | "OR" condition on SPATIAL index not optimized |
80802 | 2016-03-21 9:22 | 2016-03-21 10:56 | MySQL Server: Optimizer | Verified (1813 days) | S3 | 5..1/5.5/5.6/57 | Any | Any | "ORDER BY expression" does not allow alias to aggregate |
76501 | 2015-03-27 6:50 | 2015-03-27 15:11 | MySQL Server: Optimizer | Verified (2173 days) | S3 | 5.6.22 | Any | Any | "select + distinct + group by " works incorrectly |
94224 | 2019-02-06 16:45 | 2019-11-17 10:39 | MySQL Server: Optimizer | Verified (760 days) | S3 | 5.6, 5.6.43 | Any (any) | Any (any) | [5.6] Optimizer reconsiders index based on index definition order, not value |
66849 | 2012-09-17 18:49 | 2013-06-10 19:50 | MySQL Server: Optimizer | Verified (2828 days) | S1 | 5.5.16, 5.1.70, 5.5.32, 5.6.12 | Linux | Any | [REGRESSION] this query hangs the server (100% CPU for several minutes) |
66825 | 2012-09-14 22:38 | 2012-09-15 18:02 | MySQL Server: Optimizer | Verified (3096 days) | S3 | 5.5.27 | Any | Any | 5.5 ignores an index if BINARY is used |
58924 | 2010-12-14 18:38 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3736 days) | S3 | 5.1.44, 5.0, 5.1, 5.6.1 | Linux | Any | a LIMIT after a UNION doesn't propogate to all queries |
68044 | 2013-01-06 22:02 | 2013-01-07 1:30 | MySQL Server: Optimizer | Verified (2982 days) | S3 | 5.5.30 | Any | Any | A minor bug in check_simple_equality() |
72646 | 2014-05-14 9:40 | 2014-05-14 12:17 | MySQL Server: Optimizer | Verified (2490 days) | S3 | 5.5 5.6, 5.6.19 | Any | Any | A strange result from explain query |
95776 | 2019-06-13 2:34 | 2019-06-13 5:38 | MySQL Server: Optimizer | Verified (634 days) | S3 | 5.7.15-log MySQL Community Server (GPL), 5.6.44, 5.7.26, 8.0.16 | CentOS | Any | About FUNCTION STDDEV_SAMP:Data only in different order |
101838 | 2020-12-02 19:17 | 2020-12-11 14:39 | MySQL Server: Optimizer | Verified (87 days) | S2 | 8.0 | Any | Any | Adding GROUP BY slows down a query. |
64002 | 2012-01-11 20:01 | 2012-01-19 11:52 | MySQL Server: Optimizer | Verified (3343 days) | S1 | 5.5.19 | Any (Debian, Windows XP) | Any | Aggregate queries with multiple columns and no GROUP BY produce bogus results |
88671 | 2017-11-28 0:16 | 2017-12-04 15:41 | MySQL Server: Optimizer | Verified (1190 days) | S5 | 5.7.19 | Any | Any | ALL + BNL chosen over REF in query plan with a simple SELECT + JOIN |
70314 | 2013-09-12 12:28 | 2013-09-12 14:07 | MySQL Server: Optimizer | Verified (2734 days) | S3 | 5.6 | Any | Any | Ambiguous column updated with UPDATE ... JOIN ... USING |
65792 | 2012-07-03 2:19 | 2012-07-04 9:54 | MySQL Server: Optimizer | Verified (3170 days) | S5 | 5.1,5.5 | Any | Any | an unecessary Using temporary in distinct query |
102292 | 2021-01-19 9:54 | 2021-03-03 8:04 | MySQL Server: Optimizer | Verified (47 days) | S3 | 8.0.22, 8.0.23 | Any (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. |
88181 | 2017-10-23 5:30 | 2018-06-11 19:55 | MySQL Server: Optimizer | Verified (1232 days) | S3 | 5.7.20 | Any | Any | Another example of optimizer choosing ref over range when range is faster |
72814 | 2014-05-30 9:31 | 2014-07-18 18:56 | MySQL Server: Optimizer | Verified (2471 days) | S3 | 5.6.17 | Any | Any | Assertion `!(ordered_index_usage == ordered_index_void && ... fails |
76604 | 2015-04-07 4:29 | 2015-04-07 6:15 | MySQL Server: Optimizer | Verified (2162 days) | S3 | 5.6.23, 5.6.24, 5.6.25, 5.7.8 | Linux (CentOS 7) | Any | Assertion `length > 0 && keyparts != 0' failed in create_ref_for_key |
74490 | 2014-10-22 2:08 | 2014-10-22 6:57 | MySQL Server: Optimizer | Verified (2329 days) | S3 | 5.6.20-debug, 5.6.22 | Linux (CentOS 7) | Any | Assertion `table->key_read == 0' failed | sig 6 in close_open_tables |
69729 | 2013-07-12 2:18 | 2018-07-12 12:54 | MySQL Server: Optimizer | Verified (2796 days) | S2 | 5.5.31, 5.5.32 | Any | Any | Bad interaction between MIN/MAX and "NOT BETWEEN" leads to wrong results |
97742 | 2019-11-22 8:22 | 2020-01-20 12:53 | MySQL Server: Optimizer | Verified (461 days) | S2 | 5.7, 8.0 | Any | x86 | bad item ref from correlated subquery to outer distinct table |
56165 | 2010-08-21 8:12 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (3850 days) | S3 | 5.0.not_sure, 5.0, 5.1, 5.6.99 bzr | Any | Any | Bad Optimization |
8036 | 2005-01-20 10:12 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5882 days) | S3 | 4.0.18, 4.1.10, 5.1.52 | FreeBSD (Free BSD 4.5, Linux) | Any | Bad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB |
99244 | 2020-04-14 3:22 | 2020-04-22 12:45 | MySQL Server: Optimizer | Verified (321 days) | S1 | 8.0.19 | Any | Any | bad 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 » |