Showing 1-30 of 376 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
87492005-02-23
21:08
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3400 days)
S34.1.10, 5.0.67Any (*)AnyEXPLAIN report different "type" w and w/o USE INDEX(...) for the same used key  
172992006-02-10
12:35
2014-01-23
9:53
MySQL Server: OptimizerVerified
(1824 days)
S35.0.18Any (All)AnyInefficient optimizer for fulltext queries.  
250682006-12-14
11:56
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3749 days)
S34.0.27, 5.0.19, 5.0.36-BKLinux (Linux)AnyMyISAM-Optimizer prefers full table scan than index for IN with >15 elements  
294212007-06-28
13:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4225 days)
S25.1.14-beta/5.0AnyAnyMySQL allows mixing of GROUP columns with no GROUP columns in complex terms  
323412007-11-13
19:29
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3749 days)
S35.0.41, 5.0.52LinuxAnySubquery does not use index with session variable, works with string literal  
361952008-04-18
2:29
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3920 days)
S35.1-bkAnyAnymysqld calls handler->cond_push twice  
373052008-06-10
9:53
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3812 days)
S35.0/5.1/6.0, 5.7.18AnyAnyselect count(*); returns value  
410642008-11-27
2:25
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3707 days)
S3MySQL 5.0.27-standard, 5.0.70, 6.0.7LinuxAnyenum query never use index and it should Assigned Account
428082009-02-12
22:17
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3629 days)
S54.1, 5.0, 5.1AnyAnyExecution Plan Cache  
437202009-03-18
6:00
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3596 days)
S36.0.11, 5.0, 5.1 bzrAnyAnyMyISAM & Maria gives wrong results with range access on bit type Assigned Account
454242009-06-10
6:58
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3512 days)
S25.0.51a, 5.0.77 and 5.1.34, 5.1, 6.0 bzrLinuxAnyUPDATE statement cause full table scan ?  
462172009-07-16
11:16
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0,5.1,5.4AnyAnyWrong result on aggregate + JOIN + ORDER BY + LIMIT  
466482009-08-11
11:41
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3444 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  
481032009-10-16
0:32
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1, 6.0AnyAnyUsing STRAIGHT_JOIN with Innodb tables can produce duplicate results  
501682010-01-08
2:16
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3295 days)
S35.0,5.1AnyAnyThe value of 'rows' in EXPLAIN output is not accurate for LIMIT  
522832010-03-22
19:10
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3226 days)
S35.1.46AnyAnyInnodb reports extra warnings when SELECT/WHERE is performed using invalid value  
542252010-06-04
8:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3144 days)
S55.1.37, 5.1.49, 5.5.5-m3Linux (5.1.37-1ubuntu5.1)AnyOptimizer prefers table scan and filesort instead of index scan  
570242010-09-26
4:44
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3036 days)
S25.1AnyAnySerious performance issue with an outer join  
591192010-12-23
0:01
2018-09-09
20:45
MySQL Server: OptimizerVerified
(2951 days)
S25.1.50AnyAnyIncorrect table order chosen for three table join with an ORDER BY  
607022011-03-30
23:25
2011-04-05
14:55
MySQL Server: OptimizerVerified
(2853 days)
S55.1.57AnyAnyGROUP BY orders when used inside a UNION query, though it should not  
640022012-01-11
20:01
2012-01-19
11:52
MySQL Server: OptimizerVerified
(2566 days)
S15.5.19Any (Debian, Windows XP)AnyAggregate queries with multiple columns and no GROUP BY produce bogus results  
668252012-09-14
22:38
2012-09-15
18:02
MySQL Server: OptimizerVerified
(2319 days)
S35.5.27AnyAny5.5 ignores an index if BINARY is used  
681542013-01-23
13:07
2016-10-09
20:45
MySQL Server: OptimizerVerified
(2188 days)
S35.6.*AnyAnyexplain output 'Using index condition' not proper Assigned Account
692032013-05-11
17:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(1900 days)
S35.7Linux (Ubuntu 12.04 64-bit)AnyValgrind warnings and crash on select from an InnoDB table Martin Hansson
698912013-08-01
6:33
2014-09-18
21:25
MySQL Server: OptimizerVerifiedS35.1.31AnyAnysince 5.1.31 REPLACE() function concats it's results under certain conditions  
706262013-10-15
22:08
2017-07-17
13:18
MySQL Server: OptimizerVerified
(1923 days)
S35.1+Linux (Ubuntu 12.04)Anyselect * from t where exists (select * from t limit 0); returns rows  
711992013-12-21
18:16
2014-01-28
17:45
MySQL Server: OptimizerVerified
(1855 days)
S35.6.14, 5.6.15, 5.5.35AnyAnyOptimizer's estimated number of rows is 2 times wrong for (loose?) index scans  
722942014-04-09
17:28
2014-04-10
6:24
MySQL Server: OptimizerVerified
(1747 days)
S35.5-debug, 5.6-debugAnyAny Assertion `0' fails on killing INSERT .. SELECT into a FEDERATED table  
728402014-06-02
19:33
2014-06-03
8:02
MySQL Server: OptimizerVerified
(1693 days)
S35.1, 5.5AnyAnyWrong result (extra rows) with subquery in HAVING clause  
736032014-08-15
14:28
2015-05-04
13:17
MySQL Server: OptimizerVerified
(1468 days)
S55.6.20, 5.6.24Microsoft Windows (Server 2012 R2)AnyMySQL 5.6.20 Not Using Index  
  Showing 1-30 of 376 (Edit, Save, CSV, Feed) Show Next 30 Entries »