« Show Previous 30 Entries Showing 31-60 of 415 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
668492012-09-17
18:49
2013-06-10
19:50
MySQL Server: OptimizerVerified
(2352 days)
S15.5.16, 5.1.70, 5.5.32, 5.6.12LinuxAny[REGRESSION] this query hangs the server (100% CPU for several minutes)  
703142013-09-12
12:28
2013-09-12
14:07
MySQL Server: OptimizerVerified
(2258 days)
S35.6AnyAnyAmbiguous column updated with UPDATE ... JOIN ... USING  
703592013-09-16
23:02
2013-09-17
7:10
MySQL Server: OptimizerVerified
(2253 days)
S35.1, 5.5, 5.6, 5.7AnyAnyWrong result (missing rows) with group by, multi-part key, equality conditions  
704662013-09-30
7:24
2013-09-30
8:45
MySQL Server: OptimizerVerified
(2240 days)
S25.5,5.6AnyAnyNo results when filesorting with a correlation in subquery's HAVING clause  
704912013-10-02
19:04
2013-10-02
20:35
MySQL Server: OptimizerVerified
(2238 days)
S25.6.13AnyAnySELECT DISTINCT may return a wrong result if a join buffer is involved  
705552013-10-08
17:29
2013-10-09
8:03
MySQL Server: OptimizerVerified
(2231 days)
S35.6.14AnyAnyEXPLAIN for INSERT ... SELECT waits for table lock  
705982013-10-10
22:19
2013-10-13
11:23
MySQL Server: OptimizerVerified
(2227 days)
S35.5.32,5.5.34, 5.6.14, 5.7.2Linux (.6.18-348.16.1.el5)AnyPremature expression evaluation prevents short-circuited conditionals  
706842013-10-22
8:13
2013-10-22
11:35
MySQL Server: OptimizerVerified
(2218 days)
S35.5.33, 5.6.14AnyAnyHAVING referring to subquery results in WARNING 1292  
708862013-11-12
10:42
2013-11-12
11:02
MySQL Server: OptimizerVerified
(2197 days)
S35.5.32, 5.6AnyAnyMIN/MAX optimizer doesn't take into account type conversions  
709012013-11-13
20:18
2013-11-14
18:02
MySQL Server: OptimizerVerified
(2195 days)
S35.5.31, 5.5.35, 5.1.71, 5.0.97, 5.6.15AnyAnyORDER BY of a TEXT column doesn't use the same ordering as the < > = operators  
703572013-09-16
17:35
2013-11-21
14:09
MySQL Server: OptimizerVerified
(2188 days)
S25.6.13AnyAnyUse of group_concat causes having conditions to be ignored  
710272013-11-27
19:50
2013-11-28
13:31
MySQL Server: OptimizerVerified
(2181 days)
S35.6.11, 5.6.14AnyAnyFull-scan UPDATE is EXPLAINED confusingly  
711912013-12-20
15:30
2013-12-20
20:20
MySQL Server: OptimizerVerified
(2159 days)
S35.5.33AnyAnyLoose index scan is used even though full table scan/tight index scan is faster  
712062013-12-22
17:13
2013-12-31
20:00
MySQL Server: OptimizerVerified
(2156 days)
S15.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3Linux (ubuntu 12.04)AnyGROUP_CONCAT changes GROUP BY behavior  
712862014-01-03
17:46
2014-01-07
10:46
MySQL Server: OptimizerVerified
(2141 days)
S35.6.15AnyAnyGet DEFAULT values ​​of columns in a SELECT with Subquery  
713802014-01-14
19:35
2014-01-15
7:20
MySQL Server: OptimizerVerified
(2133 days)
S25.5.31, 5.5.35, 5.6.15AnyAnyFORMAT(x,y) is incorrectly truncated when used with a sorted JOIN  
140842005-10-17
20:09
2014-01-23
9:50
MySQL Server: OptimizerVerified
(2125 days)
S35.0-bkAnyAnyindex_merge access method not used for federated engine Assigned Account
172992006-02-10
12:35
2014-01-23
9:53
MySQL Server: OptimizerVerified
(2125 days)
S35.0.18Any (All)AnyInefficient optimizer for fulltext queries.  
121132005-07-22
14:23
2014-01-24
12:43
MySQL Server: OptimizerVerified
(2124 days)
S15.0.28-BK, 4.0,5.0AnyAnyComposite index chosen partially for ORDER BY ... LIMIT query. Assigned Account
201112006-05-28
10:57
2014-01-24
13:26
MySQL Server: OptimizerVerified
(2124 days)
S54.1.19-logLinux (Linux)Anynamed columns used in subqueries hinder optimisation of LIKE, BETWEEN, range  
711992013-12-21
18:16
2014-01-28
17:45
MySQL Server: OptimizerVerified
(2156 days)
S35.6.14, 5.6.15, 5.5.35AnyAnyOptimizer's estimated number of rows is 2 times wrong for (loose?) index scans  
711712013-12-18
10:40
2014-02-04
14:40
MySQL Server: OptimizerVerified
(2113 days)
S25.6.14Linux (Debian 7.1)AnyOptimizer executes inperformant subquery first  
693502013-05-30
5:44
2014-02-20
5:48
MySQL Server: OptimizerVerifiedS55.6AnyAnyperformance regression between 5.5 and 5.6 for simple statement in routine loop  
717772014-02-20
9:39
2014-02-20
10:54
MySQL Server: OptimizerVerified
(2097 days)
S25.5.35-0ubuntu0.13.10.1Linux (ubuntu0.13.10.1)AnyIncorrect results are returned with NULLIF()  
720312014-03-13
8:22
2014-03-13
11:14
MySQL Server: OptimizerVerified
(2076 days)
S35.6.16AnyAnyStrange explain behaviour  
599522011-02-04
17:20
2014-03-16
11:44
MySQL Server: OptimizerVerified
(3174 days)
S35.1.55-community, 5.6.3AnyAnydistinct ,distinct_key,group_key  
722942014-04-09
17:28
2014-04-10
6:24
MySQL Server: OptimizerVerified
(2048 days)
S35.5-debug, 5.6-debugAnyAny Assertion `0' fails on killing INSERT .. SELECT into a FEDERATED table  
725012014-05-01
17:31
2014-05-01
18:12
MySQL Server: OptimizerVerifiedS35.6.17AnyAnyjoining NULLs + different collation is not efficient  
725322014-05-04
19:26
2014-05-05
8:42
MySQL Server: OptimizerVerified
(2023 days)
S35.6.12, 5.6.19AnyAnyDESCRIBE with FULLTEXT does Key=MUL incorrectly  
726462014-05-14
9:40
2014-05-14
12:17
MySQL Server: OptimizerVerified
(2014 days)
S35.5 5.6, 5.6.19AnyAnyA strange result from explain query  
« Show Previous 30 Entries Showing 31-60 of 415 (Edit, Save, CSV, Feed) Show Next 30 Entries »