Showing 1-30 of 235 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
373052008-06-10
9:53
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5705 days)
S35.0/5.1/6.0, 5.7.18AnyAnyselect count(*); returns value
480492009-10-14
16:46
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1.37, 5.5.7AnyAnySELECT MIN(1) reports differently for MERGE tables in 5.0 and 5.1
586042010-11-30
21:28
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4865 days)
S15.5.7, 5.5.9, 5.6.1AnyAnycrash in cleanup code of explain partitions after killing connection
692032013-05-11
17:35
2020-12-06
20:45
MySQL Server: OptimizerVerified
(3793 days)
S35.7Linux (Ubuntu 12.04 64-bit)AnyValgrind warnings and crash on select from an InnoDB table
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
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
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
713302014-01-09
15:30
2018-01-26
5:20
MySQL Server: OptimizerVerified
(3731 days)
S35.7.3, 5.6.15AnyAnyItem_insert_value type should be ITEM_INSERT_VALUE
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
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
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
745432014-10-24
10:11
2017-06-29
5:47
MySQL Server: OptimizerVerified
(3443 days)
S35.6/5.7, 5.7.18AnyAnyread_only=1 prevents EXPLAIN UPDATE/DELETE/INSERT
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
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
766792015-04-13
15:48
2017-02-01
14:28
MySQL Server: OptimizerVerified
(3271 days)
S35.6, 5.6.24, 5.6.25, 5.7.8AnyAnyEXPLAIN incorrectly shows Distinct for tables using join buffer
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
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
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
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
784072015-09-11
12:45
2022-04-29
5:41
MySQL Server: OptimizerVerified
(699 days)
S57.4.6/5.6.24, 5.7, 8.0LinuxAnywrong index being used in subqueries?
786122015-09-28
22:46
2022-11-12
22:13
MySQL Server: OptimizerVerified
(3102 days)
S35.5.45, 5.6.26, 5.7.8,5.5.47, 5.6.28,5.7.10AnyAny Optimizer chooses wrong index for ORDER BY
  Showing 1-30 of 235 (Edit, Save, CSV, Feed) Show Next 30 Entries »