Showing all 18 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
771912015-05-29
9:14
2015-05-29
11:30
MySQL Server: OptimizerVerified
(3226 days)
S25.6.21, 5.6.24, 5.7.8AnyAnySubquery on information_schema including an IN clause, does not return results
1135512024-01-04
10:04
2024-01-10
11:21
MySQL Server: OptimizerVerified
(78 days)
S38.2.0Linux (mysql docker image 8.2.0)AnyDiscrepancy in MySQL 8.2.0 Documentation Regarding Subquery Scoping Rules
1113582023-06-12
8:41
2023-06-14
11:35
MySQL Server: DMLVerified
(289 days)
S38.0AnyAnydelete handl error
1097362023-01-23
10:41
2023-01-25
7:41
MySQL Server: OptimizerVerified
(428 days)
S28.0.32Ubuntu (22.04)x86 (x86_64)ANY query with wrong result
1045622021-08-06
16:55
2021-08-06
17:55
MySQL Server: DMLVerified
(965 days)
S38.0.26Debian (10.9)x86UUID function not executed in implicit subquery, but execute in explicit subquer
914182018-06-26
7:08
2018-09-07
13:32
MySQL Server: OptimizerVerified
(2102 days)
S35.7,8.0.11, 5.7.22AnyAnyderived_merge causing inccorect results with distinct subquery and uuid()
902452018-03-28
15:23
2018-03-29
2:43
MySQL Server: DMLVerified
(2191 days)
S35.7/8.0MacOS (10.13.3)x86Wrong result when using GROUP BY and const value in a subquery
784972015-09-21
8:44
2015-09-21
9:11
MySQL Server: DMLVerified
(3111 days)
S35.6, 5.6.26, 5.6.28, 5.7.10UbuntuAnyLarge select with nested subqueries return 0 rows
799532016-01-13
13:31
2016-01-14
6:52
MySQL Server: FULLTEXT searchVerified
(2996 days)
S35.7.10Windows (Win 2012R2)AnyFulltext-index not found in MySQL 5.7.10 when use GROUP_CONCAT
274522007-03-26
17:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5610 days)
S35.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzrLinuxAnyCorrelated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA
706842013-10-22
8:13
2013-10-22
11:35
MySQL Server: OptimizerVerified
(3810 days)
S35.5.33, 5.6.14AnyAnyHAVING referring to subquery results in WARNING 1292
704662013-09-30
7:24
2013-09-30
8:45
MySQL Server: OptimizerVerified
(3832 days)
S25.5,5.6AnyAnyNo results when filesorting with a correlation in subquery's HAVING clause
669322012-09-23
13:32
2012-09-23
23:56
MySQL Server: CharsetsVerified
(4204 days)
S35.5.25aLinuxAnyGREATEST produces invalid result if in subquery with utf8_hungarian_ci collation
481902009-10-20
14:59
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1,6.0AnyAnyError processing ALL subqueries on empty sets - different than JavaDB/Postgres
492002009-11-30
10:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5232 days)
S36.0AnyAnySelect_type in explain output incorrect for semijoin queries
462882009-07-18
19:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5367 days)
S35.1.35-community, 5.1.36WindowsAnyIndex is not used for equality condition on single-row, multiple column subquery
364222008-04-30
2:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5811 days)
S36.0.xAnyAnyEXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins
323412007-11-13
19:29
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5642 days)
S35.0.41, 5.0.52LinuxAnySubquery does not use index with session variable, works with string literal
Showing all 18 (Edit, Save, CSV, Feed)