Showing 1-30 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
70359 | 2013-09-16 23:02 | 2013-09-17 7:10 | MySQL Server: Optimizer | Verified (3845 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 (3819 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 |
71206 | 2013-12-22 17:13 | 2013-12-31 20:00 | MySQL Server: Optimizer | Verified (3748 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 |
72815 | 2014-05-30 11:06 | 2014-05-31 14:24 | MySQL Server: Optimizer | Verified (3590 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 (3564 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 (3537 days) | S3 | 5.6, 5.7 | Any | Any | Wrong result on query involving information_schema |
73907 | 2014-09-12 18:27 | 2014-09-14 3:51 | MySQL Server: Optimizer | Verified (3483 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 (3451 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 (3443 days) | S3 | 5.6/5.7 | Any | Any | FLUSH TABLES WITH READ LOCK blocks EXPLAIN UPDATE/DELETE/INSERT |
73825 | 2014-09-06 16:45 | 2014-11-06 11:39 | MySQL Server: Optimizer | Verified (3491 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | Wrong result (extra row) with group by, multi-part key |
75447 | 2015-01-08 12:59 | 2015-01-08 13:27 | MySQL Server: Optimizer | Verified (3367 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 (3347 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 (3324 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 (3278 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 |
77191 | 2015-05-29 9:14 | 2015-05-29 11:30 | MySQL Server: Optimizer | Verified (3226 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 |
71140 | 2013-12-13 9:16 | 2015-07-31 8:59 | MySQL Server: Optimizer | Verified (3163 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 |
78025 | 2015-08-11 17:43 | 2015-08-11 21:31 | MySQL Server: Optimizer | Verified (3152 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 |
79480 | 2015-12-01 10:59 | 2015-12-03 10:42 | MySQL Server: Optimizer | Verified (3038 days) | S3 | 5.7.9 | Any | Any | Suboptimal query plan in simple join compared to MariaDB 10.1 |
77340 | 2015-06-12 22:34 | 2015-12-18 10:58 | MySQL Server: Optimizer | Verified (3023 days) | S3 | 5.6.25, 5.7.7 | Any | Any | Optimizer chooses wrong index for LEFT JOIN query |
79681 | 2015-12-16 21:53 | 2016-01-13 10:41 | MySQL Server: Optimizer | Verified (3024 days) | S5 | 5.7, 5.7.10 | Red Hat (Redhat 6 update 5) | Any | Queries running much slower in version 5.7 versus 5.6 |
80206 | 2016-01-30 6:13 | 2016-01-30 6:13 | MySQL Server: Optimizer | Verified | S3 | 5.7.10 | Any | Any | EQ_REF extension should be skipped for the last joined table |
80224 | 2016-02-01 19:13 | 2016-02-15 9:00 | MySQL Server: Optimizer | Verified (2964 days) | S3 | 5.5.46, 5.6.28, 5.7.11 | Any | Any | CONCAT_WS duplication of arguments when used in conjunction with HAVING |
81469 | 2016-05-17 21:51 | 2016-05-18 6:54 | MySQL Server: Optimizer | Verified (2871 days) | S3 | 5.6.30, 5.7.12 | Any | Any | Slow performance for IN subquery and UNION |
74661 | 2014-11-02 20:20 | 2016-06-16 20:44 | MySQL Server: Optimizer | Verified (2842 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 (2842 days) | S3 | 5.6.21, 5.6.22, 5.7.6 | Any | Any | EXPLAIN FORMAT=JSON produces duplicates_removal where there is none |
77103 | 2015-05-20 12:31 | 2016-06-18 21:26 | MySQL Server: Optimizer | Verified (3234 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 |
82021 | 2016-06-27 17:46 | 2016-06-28 6:11 | MySQL Server: Optimizer | Verified (2830 days) | S3 | 5.6.31, 5.7.13 | Any | Any | Difference in range behaviour between range analyzer and query execution engine |
82074 | 2016-06-30 21:50 | 2016-07-01 5:04 | MySQL Server: Optimizer | Verified (2827 days) | S3 | 5.5.49, 5.6.30, 5.7.13 | Any | Any | Select_scan set even if table scan was not used |
82363 | 2016-07-27 19:28 | 2016-07-28 8:11 | MySQL Server: Optimizer | Verified (2800 days) | S3 | 5.7 and every other | Any | Any | impossible const condition still followed in a JOIN |
82805 | 2016-08-31 2:20 | 2016-08-31 9:47 | MySQL Server: Optimizer | Verified (2766 days) | S2 | 5.7.10, 5.7.14 | Any | Any | Having clause condition fails on join table with TEXT field |
Showing 1-30 of 235 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |