Showing all 17 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS Summary Assigned
706842013-10-22
8:13
2013-10-22
11:35
MySQL Server: OptimizerVerified
(1461 days)
S35.5.33, 5.6.14AnyHAVING referring to subquery results in WARNING 1292  
492002009-11-30
10:19
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2883 days)
S36.0AnySelect_type in explain output incorrect for semijoin queries  
274522007-03-26
17:35
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3261 days)
S35.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzrLinuxCorrelated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA  
481902009-10-20
14:59
2011-02-16
23:44
MySQL Server: OptimizerVerifiedS35.1,6.0AnyError processing ALL subqueries on empty sets - different than JavaDB/Postgres  
704662013-09-30
7:24
2013-09-30
8:45
MySQL Server: OptimizerVerified
(1483 days)
S25.5,5.6AnyNo results when filesorting with a correlation in subquery's HAVING clause  
364222008-04-30
2:19
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3462 days)
S36.0.xAnyEXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins  
799532016-01-13
13:31
2016-01-14
6:52
MySQL Server: FULLTEXT searchVerified
(647 days)
S35.7.10Microsoft Windows (Win 2012R2)Fulltext-index not found in MySQL 5.7.10 when use GROUP_CONCAT  
323412007-11-13
19:29
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3293 days)
S35.0.41, 5.0.52LinuxSubquery does not use index with session variable, works with string literal  
697212013-07-11
4:55
2016-12-06
9:16
MySQL Server: OptimizerVerified
(1564 days)
S35.6AnyBlock Nested Loop making things slower  
669322012-09-23
13:32
2012-09-23
23:56
MySQL Server: CharsetsVerified
(1855 days)
S35.5.25aLinuxGREATEST produces invalid result if in subquery with utf8_hungarian_ci collation  
771912015-05-29
9:14
2015-05-29
11:30
MySQL Server: OptimizerVerified
(877 days)
S25.6.21, 5.6.24, 5.7.8AnySubquery on information_schema including an IN clause, does not return results  
784972015-09-21
8:44
2015-09-21
9:11
MySQL Server: DMLVerified
(762 days)
S35.6, 5.6.26, 5.6.28, 5.7.10UbuntuLarge select with nested subqueries return 0 rows  
720982014-03-21
20:47
2014-03-22
6:48
MySQL Server: DMLVerified
(1310 days)
S35.5, 5.5.38Anyselect * from (subquery) get different result with subquery.  
462882009-07-18
19:12
2011-02-16
23:44
MySQL Server: OptimizerVerified
(3018 days)
S35.1.35-community, 5.1.36Microsoft WindowsIndex is not used for equality condition on single-row, multiple column subquery  
357942008-04-03
12:06
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3415 days)
S35.0.45, 5.0, 5.1, 6.0 BKAnyVery bad query optimization on DELETE with subquery  
696022013-06-27
13:05
2013-06-27
13:05
MySQL Server: DMLOpenS35.6.12-communityAny (Ubuntu 12.04 x86_64)Poor index optimization/selection using LEFT JOIN ( SELECT ) subquery  
647652012-03-26
13:38
2012-03-27
7:16
MySQL Server: DMLVerified
(2036 days)
S35.1.62, 5.5.20 AnyStrange behavior of GREATEST, when use it in subquery with variables  
Showing all 17 (Edit, Save, CSV, Feed)