Showing 1-30 of 235 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
703592013-09-16
23:02
2013-09-17
7:10
MySQL Server: OptimizerVerified
(3845 days)
S35.1, 5.5, 5.6, 5.7AnyAnyWrong result (missing rows) with group by, multi-part key, equality conditions
705982013-10-10
22:19
2013-10-13
11:23
MySQL Server: OptimizerVerified
(3819 days)
S35.5.32,5.5.34, 5.6.14, 5.7.2Linux (.6.18-348.16.1.el5)AnyPremature expression evaluation prevents short-circuited conditionals
712062013-12-22
17:13
2013-12-31
20:00
MySQL Server: OptimizerVerified
(3748 days)
S15.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3Linux (ubuntu 12.04)AnyGROUP_CONCAT changes GROUP BY behavior
728152014-05-30
11:06
2014-05-31
14:24
MySQL Server: OptimizerVerified
(3590 days)
S55.1, 5.5, 5.6, 5.7AnyAnyUPDATE ... WHERE ... ORDER BY... always does a filesort even if not required
730942014-06-24
12:24
2014-06-25
8:26
MySQL Server: OptimizerVerified
(3564 days)
S25.5, 5.6, 5.6.19, 5.7.5LinuxAnyMySQL uses all partitions instead necessary ones when using CASE THEN ELSE END
733572014-07-22
14:42
2014-07-22
19:10
MySQL Server: OptimizerVerified
(3537 days)
S35.6, 5.7AnyAnyWrong result on query involving information_schema
739072014-09-12
18:27
2014-09-14
3:51
MySQL Server: OptimizerVerified
(3483 days)
S25.5/5.6/5.7Windows (Server 2008)AnyREGRESSION: Indexes miss on quoted large numeric bigints
740782014-09-25
16:15
2014-10-16
19:49
MySQL Server: OptimizerVerified
(3451 days)
S55.6.19/5.5/5.7Linux (Ubuntu 14)Anyjoin of large table to small table is slow if small table has less than 7 rows
745422014-10-24
10:05
2014-10-24
10:51
MySQL Server: OptimizerVerified
(3443 days)
S35.6/5.7AnyAnyFLUSH TABLES WITH READ LOCK blocks EXPLAIN UPDATE/DELETE/INSERT
738252014-09-06
16:45
2014-11-06
11:39
MySQL Server: OptimizerVerified
(3491 days)
S35.1, 5.5, 5.6, 5.7AnyAnyWrong result (extra row) with group by, multi-part key
754472015-01-08
12:59
2015-01-08
13:27
MySQL Server: OptimizerVerified
(3367 days)
S25.6, 5.6.24, 5.7.6AnyAnyINSERT into a view sometimes ignores default values
756682015-01-28
16:21
2015-01-28
20:10
MySQL Server: OptimizerVerified
(3347 days)
S25.6.22/5.7FreeBSD (FreeBSD 8.4)AnyUse of Distinct, Group_concat, and Group by together produces 1 NULL row result.
759672015-02-19
12:45
2015-02-20
8:06
MySQL Server: OptimizerVerified
(3324 days)
S35.6, 5.7, 5.6.24AnyAnyWrong result (extra rows) with SQ and comparison to NULL, materialization=off
766042015-04-07
4:29
2015-04-07
6:15
MySQL Server: OptimizerVerified
(3278 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
771912015-05-29
9:14
2015-05-29
11:30
MySQL Server: OptimizerVerified
(3226 days)
S25.6.21, 5.6.24, 5.7.8AnyAnySubquery on information_schema including an IN clause, does not return results
711402013-12-13
9:16
2015-07-31
8:59
MySQL Server: OptimizerVerified
(3163 days)
S25.1, 5.5, 5.6.15, 5.7.7AnyAnyOptimizer does NOT use range checks in typical self-join for InnoDB tables
780252015-08-11
17:43
2015-08-11
21:31
MySQL Server: OptimizerVerified
(3152 days)
S35.5, 5.6, 5.7AnyAnySpecial IS NULL logic for 0000-00-00 does not work with merge views and SQ
794802015-12-01
10:59
2015-12-03
10:42
MySQL Server: OptimizerVerified
(3038 days)
S35.7.9AnyAnySuboptimal query plan in simple join compared to MariaDB 10.1
773402015-06-12
22:34
2015-12-18
10:58
MySQL Server: OptimizerVerified
(3023 days)
S35.6.25, 5.7.7AnyAny Optimizer chooses wrong index for LEFT JOIN query
796812015-12-16
21:53
2016-01-13
10:41
MySQL Server: OptimizerVerified
(3024 days)
S55.7, 5.7.10Red Hat (Redhat 6 update 5)AnyQueries running much slower in version 5.7 versus 5.6
802062016-01-30
6:13
2016-01-30
6:13
MySQL Server: OptimizerVerifiedS35.7.10AnyAnyEQ_REF extension should be skipped for the last joined table
802242016-02-01
19:13
2016-02-15
9:00
MySQL Server: OptimizerVerified
(2964 days)
S35.5.46, 5.6.28, 5.7.11AnyAnyCONCAT_WS duplication of arguments when used in conjunction with HAVING
814692016-05-17
21:51
2016-05-18
6:54
MySQL Server: OptimizerVerified
(2871 days)
S35.6.30, 5.7.12AnyAnySlow performance for IN subquery and UNION
746612014-11-02
20:20
2016-06-16
20:44
MySQL Server: OptimizerVerified
(2842 days)
S35.6.21, 5.6.22, 5.7.6AnyAnyEXPLAIN FORMAT=JSON says two temptables are used, execution shows just one
747442014-11-07
22:45
2016-06-16
20:45
MySQL Server: OptimizerVerified
(2842 days)
S35.6.21, 5.6.22, 5.7.6AnyAnyEXPLAIN FORMAT=JSON produces duplicates_removal where there is none
771032015-05-20
12:31
2016-06-18
21:26
MySQL Server: OptimizerVerified
(3234 days)
S25.6.24 and 5.1.73, 5.1.75, 5.5.45, 5.6.26, 5.7.8, 8.0.0AnyAnyDATE and IFNULL result is returned different
820212016-06-27
17:46
2016-06-28
6:11
MySQL Server: OptimizerVerified
(2830 days)
S35.6.31, 5.7.13AnyAnyDifference in range behaviour between range analyzer and query execution engine
820742016-06-30
21:50
2016-07-01
5:04
MySQL Server: OptimizerVerified
(2827 days)
S35.5.49, 5.6.30, 5.7.13AnyAnySelect_scan set even if table scan was not used
823632016-07-27
19:28
2016-07-28
8:11
MySQL Server: OptimizerVerified
(2800 days)
S35.7 and every otherAnyAnyimpossible const condition still followed in a JOIN
828052016-08-31
2:20
2016-08-31
9:47
MySQL Server: OptimizerVerified
(2766 days)
S25.7.10, 5.7.14AnyAnyHaving clause condition fails on join table with TEXT field
  Showing 1-30 of 235 (Edit, Save, CSV, Feed) Show Next 30 Entries »