Showing 1-30 of 235 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
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
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
936062018-12-14
7:53
2021-11-23
15:30
MySQL Server: OptimizerVerified
(1904 days)
S25.6.40,5.7.24CentOS (6.9)x86 when use Connector/J preparestatement mysql returns the wrong result
957762019-06-13
2:34
2019-06-13
5:38
MySQL Server: OptimizerVerified
(1750 days)
S35.7.15-log MySQL Community Server (GPL), 5.6.44, 5.7.26, 8.0.16CentOSAnyAbout FUNCTION STDDEV_SAMP:Data only in different order
1049782021-09-17
19:57
2021-09-20
9:02
MySQL Server: OptimizerVerified
(920 days)
S58.0.26, 5.7.35WindowsAnyAdding Join Index forces query optimizer to use inefficient execution plan
1032962021-04-13
5:35
2021-04-13
6:01
MySQL Server: OptimizerVerified
(1080 days)
S38.0.22, 5.7.33, 8.0.23AnyAnyAggregate function group by primary key/non-primary key has differnet result
1082332022-08-23
6:43
2022-08-23
7:53
MySQL Server: OptimizerVerified
(583 days)
S35.7.39, 8.0.30AnyAnyAlias displayed incorrectly with "Use temporary"
886712017-11-28
0:16
2017-12-04
15:41
MySQL Server: OptimizerVerified
(2306 days)
S55.7.19AnyAnyALL + BNL chosen over REF in query plan with a simple SELECT + JOIN
881812017-10-23
5:30
2018-06-11
19:55
MySQL Server: OptimizerVerified
(2348 days)
S35.7.20AnyAnyAnother example of optimizer choosing ref over range when range is faster
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
1119182023-07-30
6:12
2023-07-31
6:33
MySQL Server: OptimizerVerified
(241 days)
S38.1.0, 8.0.34, 5.7.43Ubuntu (22.04)x86 (x86_64)Auto increment column query wrong result
1044212021-07-26
19:58
2021-07-29
7:07
MySQL Server: OptimizerVerified
(973 days)
S28.0.26, 5.7.35AnyAnyBad plan for WHERE customer_id = @cid ORDER BY id LIMIT 10 with compound PK.
928502018-10-19
0:46
2018-10-22
5:31
MySQL Server: OptimizerVerified
(1984 days)
S35.7.23AnyAnyBad select+order by+limit performance in 5.7
986472020-02-18
13:06
2020-02-18
14:03
MySQL Server: OptimizerVerified
(1500 days)
S35.7.29Windowsx86Bad SUM result with GROUP BY
991302020-03-31
12:18
2020-04-01
13:10
MySQL Server: OptimizerVerified
(1458 days)
S38.0.19,5.6.47, 5.7.29AnyAnyBETWEEN malfunctions when comparing a string containing a newline
991352020-03-31
16:54
2020-04-01
5:11
MySQL Server: OptimizerVerified
(1457 days)
S38.0.19, 5.6.47, 5.7.29AnyAnyBETWEEN malfunctions when comparing large numbers
1029112021-03-10
23:49
2021-03-12
6:09
MySQL Server: OptimizerVerified
(1113 days)
S25.7, 8.0, 5.7.33, 8.0.23AnyAnyBETWEEN SQL-query on auto-incremented primary key field gives the incorrect resu
869732017-07-06
13:26
2017-07-07
7:19
MySQL Server: OptimizerVerified
(2456 days)
S15.6, 5.5.56, 5.6.36, 5.7.18AnyAnyBIN() function error
973392019-10-23
8:06
2021-07-23
13:05
MySQL Server: OptimizerVerified
(1612 days)
S25.7.18, 5.7.28, 5.6.46AnyAnybin() function return Incorrect result set
1105872023-04-03
7:51
2023-04-03
9:37
MySQL Server: OptimizerVerified
(360 days)
S18.0.27, 8.0.32, 5.7.41AnyAnyBit with index range query may produce different results
976482019-11-14
20:25
2019-11-19
14:48
MySQL Server: OptimizerVerified
(1592 days)
S35.7, 8.0AnyAnyBug in order by clause in union clause
1036322021-05-08
12:23
2022-08-13
16:23
MySQL Server: OptimizerVerified
(593 days)
S28.0.23, 8.0.24, 5.7.34Any (Windows, Ubuntu)AnyCan't write; duplicate key in table
924662018-09-17
16:05
2018-09-18
9:14
MySQL Server: OptimizerVerified
(2018 days)
S35.7.22, 5.7.23, 8.0.12AnyAnyCase function error on randomly generated values
991462020-04-01
9:49
2020-04-01
10:42
MySQL Server: OptimizerVerified
(1457 days)
S38.0.19, 5.7.29AnyAnyComparison on FLOAT column and large value malfunctions
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
879152017-09-29
13:47
2018-04-27
14:20
MySQL Server: OptimizerVerified
(2162 days)
S35.7.18/trunkAnyAnyConstant in multi-byte character fails to propagate to dependent subquery
1062642022-01-24
16:33
2022-01-25
15:07
MySQL Server: OptimizerVerified
(793 days)
S25.7AnyAnyContribution by Tencent: Prevent badly stale rec_per_key for query optimization
1114662023-06-16
19:18
2023-06-17
7:45
MySQL Server: OptimizerVerified
(285 days)
S35.7AnyAnyContribution: Disable index hints on spatial indices
1051432021-10-05
22:01
2021-10-06
6:16
MySQL Server: OptimizerVerified
(904 days)
S38.0, 5.7AnyAnyContribution: Fixed scientific notation bug
900432018-03-13
8:53
2019-02-18
16:43
MySQL Server: OptimizerVerified
(2206 days)
S35.6, 5.7LinuxAnyconvert_tz doesn't handle offset more than 13 hours
  Showing 1-30 of 235 (Edit, Save, CSV, Feed) Show Next 30 Entries »