Showing 1-30 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
37305 | 2008-06-10 9:53 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5726 days) | S3 | 5.0/5.1/6.0, 5.7.18 | Any | Any | select count(*); returns value |
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 |
58604 | 2010-11-30 21:28 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4886 days) | S1 | 5.5.7, 5.5.9, 5.6.1 | Any | Any | crash in cleanup code of explain partitions after killing connection |
69203 | 2013-05-11 17:35 | 2020-12-06 20:45 | MySQL Server: Optimizer | Verified (3814 days) | S3 | 5.7 | Linux (Ubuntu 12.04 64-bit) | Any | Valgrind warnings and crash on select from an InnoDB table |
70359 | 2013-09-16 23:02 | 2013-09-17 7:10 | MySQL Server: Optimizer | Verified (3866 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | Wrong result (missing rows) with group by, multi-part key, equality conditions |
70598 | 2013-10-10 22:19 | 2013-10-13 11:23 | MySQL Server: Optimizer | Verified (3840 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 |
71140 | 2013-12-13 9:16 | 2015-07-31 8:59 | MySQL Server: Optimizer | Verified (3184 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 |
71206 | 2013-12-22 17:13 | 2013-12-31 20:00 | MySQL Server: Optimizer | Verified (3769 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 |
71330 | 2014-01-09 15:30 | 2018-01-26 5:20 | MySQL Server: Optimizer | Verified (3752 days) | S3 | 5.7.3, 5.6.15 | Any | Any | Item_insert_value type should be ITEM_INSERT_VALUE |
72815 | 2014-05-30 11:06 | 2014-05-31 14:24 | MySQL Server: Optimizer | Verified (3611 days) | S5 | 5.1, 5.5, 5.6, 5.7 | Any | Any | UPDATE ... WHERE ... ORDER BY... always does a filesort even if not required |
73094 | 2014-06-24 12:24 | 2014-06-25 8:26 | MySQL Server: Optimizer | Verified (3585 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 |
73357 | 2014-07-22 14:42 | 2014-07-22 19:10 | MySQL Server: Optimizer | Verified (3558 days) | S3 | 5.6, 5.7 | Any | Any | Wrong result on query involving information_schema |
73825 | 2014-09-06 16:45 | 2014-11-06 11:39 | MySQL Server: Optimizer | Verified (3512 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | Wrong result (extra row) with group by, multi-part key |
73907 | 2014-09-12 18:27 | 2014-09-14 3:51 | MySQL Server: Optimizer | Verified (3504 days) | S2 | 5.5/5.6/5.7 | Windows (Server 2008) | Any | REGRESSION: Indexes miss on quoted large numeric bigints |
74078 | 2014-09-25 16:15 | 2014-10-16 19:49 | MySQL Server: Optimizer | Verified (3472 days) | S5 | 5.6.19/5.5/5.7 | Linux (Ubuntu 14) | Any | join of large table to small table is slow if small table has less than 7 rows |
74542 | 2014-10-24 10:05 | 2014-10-24 10:51 | MySQL Server: Optimizer | Verified (3464 days) | S3 | 5.6/5.7 | Any | Any | FLUSH TABLES WITH READ LOCK blocks EXPLAIN UPDATE/DELETE/INSERT |
74543 | 2014-10-24 10:11 | 2017-06-29 5:47 | MySQL Server: Optimizer | Verified (3464 days) | S3 | 5.6/5.7, 5.7.18 | Any | Any | read_only=1 prevents EXPLAIN UPDATE/DELETE/INSERT |
74661 | 2014-11-02 20:20 | 2016-06-16 20:44 | MySQL Server: Optimizer | Verified (2863 days) | S3 | 5.6.21, 5.6.22, 5.7.6 | Any | Any | EXPLAIN FORMAT=JSON says two temptables are used, execution shows just one |
74744 | 2014-11-07 22:45 | 2016-06-16 20:45 | MySQL Server: Optimizer | Verified (2863 days) | S3 | 5.6.21, 5.6.22, 5.7.6 | Any | Any | EXPLAIN FORMAT=JSON produces duplicates_removal where there is none |
75447 | 2015-01-08 12:59 | 2015-01-08 13:27 | MySQL Server: Optimizer | Verified (3388 days) | S2 | 5.6, 5.6.24, 5.7.6 | Any | Any | INSERT into a view sometimes ignores default values |
75668 | 2015-01-28 16:21 | 2015-01-28 20:10 | MySQL Server: Optimizer | Verified (3368 days) | S2 | 5.6.22/5.7 | FreeBSD (FreeBSD 8.4) | Any | Use of Distinct, Group_concat, and Group by together produces 1 NULL row result. |
75967 | 2015-02-19 12:45 | 2015-02-20 8:06 | MySQL Server: Optimizer | Verified (3345 days) | S3 | 5.6, 5.7, 5.6.24 | Any | Any | Wrong result (extra rows) with SQ and comparison to NULL, materialization=off |
76604 | 2015-04-07 4:29 | 2015-04-07 6:15 | MySQL Server: Optimizer | Verified (3299 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 |
76679 | 2015-04-13 15:48 | 2017-02-01 14:28 | MySQL Server: Optimizer | Verified (3292 days) | S3 | 5.6, 5.6.24, 5.6.25, 5.7.8 | Any | Any | EXPLAIN incorrectly shows Distinct for tables using join buffer |
77103 | 2015-05-20 12:31 | 2016-06-18 21:26 | MySQL Server: Optimizer | Verified (3255 days) | S2 | 5.6.24 and 5.1.73, 5.1.75, 5.5.45, 5.6.26, 5.7.8, 8.0.0 | Any | Any | DATE and IFNULL result is returned different |
77191 | 2015-05-29 9:14 | 2015-05-29 11:30 | MySQL Server: Optimizer | Verified (3247 days) | S2 | 5.6.21, 5.6.24, 5.7.8 | Any | Any | Subquery on information_schema including an IN clause, does not return results |
77340 | 2015-06-12 22:34 | 2015-12-18 10:58 | MySQL Server: Optimizer | Verified (3044 days) | S3 | 5.6.25, 5.7.7 | Any | Any | Optimizer chooses wrong index for LEFT JOIN query |
78025 | 2015-08-11 17:43 | 2015-08-11 21:31 | MySQL Server: Optimizer | Verified (3173 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 |
78407 | 2015-09-11 12:45 | 2022-04-29 5:41 | MySQL Server: Optimizer | Verified (720 days) | S5 | 7.4.6/5.6.24, 5.7, 8.0 | Linux | Any | wrong index being used in subqueries? |
78612 | 2015-09-28 22:46 | 2022-11-12 22:13 | MySQL Server: Optimizer | Verified (3123 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 |
Showing 1-30 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |