Showing all 12 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
420942009-01-13
23:01
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3773 days)
S35.15.6+AnyAnyOptimizer chooses a wrong index when group by, order by and limit is present  
453732009-06-08
13:14
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3685 days)
S35.1.35-community, 5.1.36-bzrAnyAnyINDEX FOR GROUP BY is not used if there is a LIMIT clause in the query Gleb Shchepa
461352009-07-12
19:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3285 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
(3626 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
(3477 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
(3394 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
(3296 days)
S25.1+AnyAnyINSERT...SELECT...LIMIT...UNION should be marked unsafe Assigned Account
343102008-02-05
14:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(2042 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
(1074 days)
S35.5.51, 5.6.32, 5.7.14LinuxAnynested limit produces counter intuitive result  
763982015-03-19
20:27
2016-12-01
7:04
MySQL Server: InnoDB storage engineVerified
(1581 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  
876442017-09-01
22:19
2018-04-25
13:37
MySQL Server: OptimizerVerified
(453 days)
S25.7.18CentOS (6 (x86_64))AnyOrder by on 'datetime' column not working with LIMIT <row_count>  
Showing all 12 (Edit, Save, CSV, Feed)