Showing 1-30 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
96137 | 2019-07-09 9:20 | 2019-07-09 16:25 | MySQL Server: Optimizer | Verified (1752 days) | S2 | 5.7.17 MySQL Community Server | Linux | Any | NOT(NOT( FIELD > ALL (SUBQUERY) )) 'S RESULT NOT EQUAL FIELD > ALL (SUBQUERY) |
37305 | 2008-06-10 9:53 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5733 days) | S3 | 5.0/5.1/6.0, 5.7.18 | Any | Any | select count(*); returns value |
70359 | 2013-09-16 23:02 | 2013-09-17 7:10 | MySQL Server: Optimizer | Verified (3873 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | Wrong result (missing rows) with group by, multi-part key, equality conditions |
72815 | 2014-05-30 11:06 | 2014-05-31 14:24 | MySQL Server: Optimizer | Verified (3618 days) | S5 | 5.1, 5.5, 5.6, 5.7 | Any | Any | UPDATE ... WHERE ... ORDER BY... always does a filesort even if not required |
73825 | 2014-09-06 16:45 | 2014-11-06 11:39 | MySQL Server: Optimizer | Verified (3519 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | Wrong result (extra row) with group by, multi-part key |
71140 | 2013-12-13 9:16 | 2015-07-31 8:59 | MySQL Server: Optimizer | Verified (3191 days) | S2 | 5.1, 5.5, 5.6.15, 5.7.7 | Any | Any | Optimizer does NOT use range checks in typical self-join for InnoDB tables |
48049 | 2009-10-14 16:46 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.1.37, 5.5.7 | Any | Any | SELECT MIN(1) reports differently for MERGE tables in 5.0 and 5.1 |
73094 | 2014-06-24 12:24 | 2014-06-25 8:26 | MySQL Server: Optimizer | Verified (3592 days) | S2 | 5.5, 5.6, 5.6.19, 5.7.5 | Linux | Any | MySQL uses all partitions instead necessary ones when using CASE THEN ELSE END |
78025 | 2015-08-11 17:43 | 2015-08-11 21:31 | MySQL Server: Optimizer | Verified (3180 days) | S3 | 5.5, 5.6, 5.7 | Any | Any | Special IS NULL logic for 0000-00-00 does not work with merge views and SQ |
71206 | 2013-12-22 17:13 | 2013-12-31 20:00 | MySQL Server: Optimizer | Verified (3776 days) | S1 | 5.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3 | Linux (ubuntu 12.04) | Any | GROUP_CONCAT changes GROUP BY behavior |
70598 | 2013-10-10 22:19 | 2013-10-13 11:23 | MySQL Server: Optimizer | Verified (3847 days) | S3 | 5.5.32,5.5.34, 5.6.14, 5.7.2 | Linux (.6.18-348.16.1.el5) | Any | Premature expression evaluation prevents short-circuited conditionals |
78651 | 2015-09-30 18:44 | 2016-10-20 12:35 | MySQL Server: Optimizer | Verified (3129 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 |
78612 | 2015-09-28 22:46 | 2022-11-12 22:13 | MySQL Server: Optimizer | Verified (3130 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 |
80224 | 2016-02-01 19:13 | 2016-02-15 9:00 | MySQL Server: Optimizer | Verified (2992 days) | S3 | 5.5.46, 5.6.28, 5.7.11 | Any | Any | CONCAT_WS duplication of arguments when used in conjunction with HAVING |
82074 | 2016-06-30 21:50 | 2016-07-01 5:04 | MySQL Server: Optimizer | Verified (2855 days) | S3 | 5.5.49, 5.6.30, 5.7.13 | Any | Any | Select_scan set even if table scan was not used |
58604 | 2010-11-30 21:28 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4893 days) | S1 | 5.5.7, 5.5.9, 5.6.1 | Any | Any | crash in cleanup code of explain partitions after killing connection |
73907 | 2014-09-12 18:27 | 2014-09-14 3:51 | MySQL Server: Optimizer | Verified (3511 days) | S2 | 5.5/5.6/5.7 | Windows (Server 2008) | Any | REGRESSION: Indexes miss on quoted large numeric bigints |
84416 | 2017-01-04 23:11 | 2017-01-05 11:26 | MySQL Server: Optimizer | Verified (2667 days) | S3 | 5.6 and 5.7 | Any | Any | MySQL updates 0000-00-00 00:00:00 for datetime type |
86973 | 2017-07-06 13:26 | 2017-07-07 7:19 | MySQL Server: Optimizer | Verified (2484 days) | S1 | 5.6, 5.5.56, 5.6.36, 5.7.18 | Any | Any | BIN() function error |
76679 | 2015-04-13 15:48 | 2017-02-01 14:28 | MySQL Server: Optimizer | Verified (3299 days) | S3 | 5.6, 5.6.24, 5.6.25, 5.7.8 | Any | Any | EXPLAIN incorrectly shows Distinct for tables using join buffer |
75447 | 2015-01-08 12:59 | 2015-01-08 13:27 | MySQL Server: Optimizer | Verified (3395 days) | S2 | 5.6, 5.6.24, 5.7.6 | Any | Any | INSERT into a view sometimes ignores default values |
73357 | 2014-07-22 14:42 | 2014-07-22 19:10 | MySQL Server: Optimizer | Verified (3565 days) | S3 | 5.6, 5.7 | Any | Any | Wrong result on query involving information_schema |
84638 | 2017-01-24 12:40 | 2017-01-30 6:47 | MySQL Server: Optimizer | Verified (2646 days) | S3 | 5.6, 5.7 | Any | Any | Missing FROM clause returns error when using INTO at the end of the statement |
90043 | 2018-03-13 8:53 | 2019-02-18 16:43 | MySQL Server: Optimizer | Verified (2234 days) | S3 | 5.6, 5.7 | Linux | Any | convert_tz doesn't handle offset more than 13 hours |
75967 | 2015-02-19 12:45 | 2015-02-20 8:06 | MySQL Server: Optimizer | Verified (3352 days) | S3 | 5.6, 5.7, 5.6.24 | Any | Any | Wrong result (extra rows) with SQ and comparison to NULL, materialization=off |
84858 | 2017-02-07 13:09 | 2017-02-09 6:34 | MySQL Server: Optimizer | Verified (2632 days) | S3 | 5.6, 5.7, 5.6.35 | Any | Any | Time is spent at "statistics" stage for primary key lookups |
99684 | 2020-05-25 12:19 | 2022-06-08 12:02 | MySQL Server: Optimizer | Verified (1428 days) | S3 | 5.6, 5.7, 8.0 | Any | Any | incorrect determination of big test |
88896 | 2017-12-13 12:12 | 2017-12-14 5:34 | MySQL Server: Optimizer | Verified (2324 days) | S3 | 5.6, 5.7.20, 8.0.3, 5.6.38 | Any | Any | Different query result, depending from data load pattern |
99459 | 2020-05-06 8:17 | 2020-05-08 13:41 | MySQL Server: Optimizer | Verified (1448 days) | S3 | 5.6,5.7,8.0 | Any | Any | SQL run with GROUP_MIN_MAX may infinite loop and never return |
93360 | 2018-11-27 9:41 | 2018-12-12 14:48 | MySQL Server: Optimizer | Verified (1961 days) | S5 | 5.6.16,5.7.23 | Linux | x86 | mysterious optimizer behavior |
Showing 1-30 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |