Showing all 13 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS Summary Assigned
343102008-02-05
14:51
2013-12-18
14:03
MySQL Server: OptimizerVerified
(1313 days)
S55.0.51a-log, 5.0.54, 5.6.14LinuxOptimizer is inefficient by using ORDER BY function() and LIMIT  
420942009-01-13
23:01
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3044 days)
S35.15.6+AnyOptimizer chooses a wrong index when group by, order by and limit is present  
453732009-06-08
13:14
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2956 days)
S35.1.35-community, 5.1.36-bzrAnyINDEX FOR GROUP BY is not used if there is a LIMIT clause in the query Gleb Shchepa
461352009-07-12
19:03
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2556 days)
S25.0, 5.1, next, 6.0.0, 6.0.2, 5.1.36AnyLIMIT + JOIN problem  
462822009-07-18
15:12
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2927 days)
S35.4, 6.0AnyVAR and STD_DEV functions returning inconsistent results with addition of LIMIT  
462832009-07-18
15:22
2011-02-16
23:44
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0AnyCOUNT() returning bad values when LIMIT 1 clause added to query  
466482009-08-11
11:41
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2897 days)
S35.1.32, 4.1, 5.0, 5.1, azalea bzrLinux (2.6.28.7)SQL_CALC_FOUND_ROWS kills performance with ORDER BY and LIMIT  
501682010-01-08
2:16
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2748 days)
S35.0,5.1AnyThe 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
(2665 days)
S2mysql-5.1-telco-7.0AnyInconsistent and permanent error when attribute name is to long for PK  
552112010-07-13
13:50
2017-05-21
20:45
MySQL Server: ReplicationVerified
(2567 days)
S25.1+AnyINSERT...SELECT...LIMIT...UNION should be marked unsafe Assigned Account
675802012-11-13
21:57
2012-11-30
16:21
MySQL Server: DMLVerified
(1696 days)
S35.5.28, 5.5.30, 5.1.67, 5.0.97Linux (sles11)group_concat() limited to 64kb on compress()'ed fields when order by is used  
763982015-03-19
20:27
2016-12-01
7:04
MySQL Server: InnoDB storage engineVerified
(852 days)
S35.6.23, 5.6.25, 5.5.44Any (CentOS, Mac OS X)MySQL doing full scan depending on limit value with ORDER BY query  
825602016-08-12
3:32
2016-08-16
10:10
MySQL Server: DMLVerified
(345 days)
S35.5.51, 5.6.32, 5.7.14Linuxnested limit produces counter intuitive result  
Showing all 13 (Edit, Save, CSV, Feed)