Showing all 11 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
453732009-06-08
13:14
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4179 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
(3779 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
(4120 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
(3971 days)
S35.0,5.1AnyAnyThe value of 'rows' in EXPLAIN output is not accurate for LIMIT
526132010-04-06
9:04
2014-10-09
13:44
MySQL Cluster: Cluster (NDB) storage engineVerified
(3888 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
(3790 days)
S25.1+AnyAnyINSERT...SELECT...LIMIT...UNION should be marked unsafe
343102008-02-05
14:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(2536 days)
S55.0.51a-log, 5.0.54, 5.6.14LinuxAnyOptimizer is inefficient by using ORDER BY function() and LIMIT
825602016-08-12
3:32
2016-08-16
10:10
MySQL Server: DMLVerified
(1568 days)
S35.5.51, 5.6.32, 5.7.14LinuxAnynested limit produces counter intuitive result
876442017-09-01
22:19
2018-04-25
13:37
MySQL Server: OptimizerVerified
(947 days)
S25.7.18CentOS (6 (x86_64))AnyOrder by on 'datetime' column not working with LIMIT <row_count>
763982015-03-19
20:27
2020-04-11
2:21
MySQL Server: InnoDB storage engineVerified
(230 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
Showing all 11 (Edit, Save, CSV, Feed)