Showing all 12 (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
(4425 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
(4025 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
(4366 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
(4217 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
(4134 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
(4036 days)
S25.1+AnyAnyINSERT...SELECT...LIMIT...UNION should be marked unsafe
343102008-02-05
14:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(2782 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
(1814 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
(1193 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
(476 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
1041272021-06-28
7:00
2021-06-28
7:19
MySQL Server: OptimizerVerified
(33 days)
S28.0, 8.0.25AnyAnyoutput count is unexpected when limit clause is used in CTE
Showing all 12 (Edit, Save, CSV, Feed)