Showing all 13 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
343102008-02-05
14:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3753 days)
S55.0.51a-log, 5.0.54, 5.6.14LinuxAnyOptimizer is inefficient by using ORDER BY function() and LIMIT
453732009-06-08
13:14
2022-09-04
20:45
MySQL Server: OptimizerVerified
(5396 days)
S35.1.35-community, 5.1.36-bzrAnyAnyINDEX FOR GROUP BY is not used if there is a LIMIT clause in the query
461352009-07-12
19:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4996 days)
S25.0, 5.1, next, 6.0.0, 6.0.2, 5.1.36AnyAnyLIMIT + JOIN problem
462832009-07-18
15:22
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0AnyAnyCOUNT() returning bad values when LIMIT 1 clause added to query
466482009-08-11
11:41
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5337 days)
S35.1.32, 4.1, 5.0, 5.1, azalea bzrLinux (2.6.28.7)AnySQL_CALC_FOUND_ROWS kills performance with ORDER BY and LIMIT
501682010-01-08
2:16
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5188 days)
S35.0,5.1AnyAnyThe value of 'rows' in EXPLAIN output is not accurate for LIMIT
526132010-04-06
9:04
2021-05-02
20:45
MySQL Cluster: Cluster (NDB) storage engineVerified
(5105 days)
S2mysql-5.1-telco-7.0AnyAnyInconsistent and permanent error when attribute name is to long for PK
552112010-07-13
13:50
2017-05-21
20:45
MySQL Server: ReplicationVerified
(5007 days)
S25.1+AnyAnyINSERT...SELECT...LIMIT...UNION should be marked unsafe
763982015-03-19
20:27
2020-04-11
2:21
MySQL Server: InnoDB storage engineVerified
(1447 days)
S35.6.23, 5.6.25, 5.5.44Any (CentOS, Mac OS X)AnyMySQL doing full scan depending on limit value with ORDER BY query
825602016-08-12
3:32
2016-08-16
10:10
MySQL Server: DMLVerified
(2785 days)
S35.5.51, 5.6.32, 5.7.14LinuxAnynested limit produces counter intuitive result
876442017-09-01
22:19
2022-09-06
8:01
MySQL Server: OptimizerVerified
(2164 days)
S25.7.18CentOS (6 (x86_64))AnyOrder by on 'datetime' column not working with LIMIT <row_count>
1041272021-06-28
7:00
2021-06-28
7:19
MySQL Server: OptimizerVerified
(1004 days)
S28.0, 8.0.25AnyAnyoutput count is unexpected when limit clause is used in CTE
1108482023-04-27
15:04
2023-05-03
9:59
MySQL Server: OptimizerVerified
(330 days)
S58.0.28, 8.0.33AnyAnymissing considering on order by and limit clause in cost calculation
Showing all 13 (Edit, Save, CSV, Feed)