Showing all 18 (Edit, Save, CSV, Feed) |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
66932 | 2012-09-23 13:32 | 2012-09-23 23:56 | MySQL Server: Charsets | Verified (4226 days) | S3 | 5.5.25a | Linux | Any | GREATEST produces invalid result if in subquery with utf8_hungarian_ci collation |
70466 | 2013-09-30 7:24 | 2013-09-30 8:45 | MySQL Server: Optimizer | Verified (3854 days) | S2 | 5.5,5.6 | Any | Any | No results when filesorting with a correlation in subquery's HAVING clause |
70684 | 2013-10-22 8:13 | 2013-10-22 11:35 | MySQL Server: Optimizer | Verified (3832 days) | S3 | 5.5.33, 5.6.14 | Any | Any | HAVING referring to subquery results in WARNING 1292 |
77191 | 2015-05-29 9:14 | 2015-05-29 11:30 | MySQL Server: Optimizer | Verified (3248 days) | S2 | 5.6.21, 5.6.24, 5.7.8 | Any | Any | Subquery on information_schema including an IN clause, does not return results |
78497 | 2015-09-21 8:44 | 2015-09-21 9:11 | MySQL Server: DML | Verified (3133 days) | S3 | 5.6, 5.6.26, 5.6.28, 5.7.10 | Ubuntu | Any | Large select with nested subqueries return 0 rows |
79953 | 2016-01-13 13:31 | 2016-01-14 6:52 | MySQL Server: FULLTEXT search | Verified (3018 days) | S3 | 5.7.10 | Windows (Win 2012R2) | Any | Fulltext-index not found in MySQL 5.7.10 when use GROUP_CONCAT |
90245 | 2018-03-28 15:23 | 2018-03-29 2:43 | MySQL Server: DML | Verified (2213 days) | S3 | 5.7/8.0 | MacOS (10.13.3) | x86 | Wrong result when using GROUP BY and const value in a subquery |
91418 | 2018-06-26 7:08 | 2018-09-07 13:32 | MySQL Server: Optimizer | Verified (2124 days) | S3 | 5.7,8.0.11, 5.7.22 | Any | Any | derived_merge causing inccorect results with distinct subquery and uuid() |
32341 | 2007-11-13 19:29 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5664 days) | S3 | 5.0.41, 5.0.52 | Linux | Any | Subquery does not use index with session variable, works with string literal |
48190 | 2009-10-20 14:59 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S3 | 5.1,6.0 | Any | Any | Error processing ALL subqueries on empty sets - different than JavaDB/Postgres |
49200 | 2009-11-30 10:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5254 days) | S3 | 6.0 | Any | Any | Select_type in explain output incorrect for semijoin queries |
46288 | 2009-07-18 19:12 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5389 days) | S3 | 5.1.35-community, 5.1.36 | Windows | Any | Index is not used for equality condition on single-row, multiple column subquery |
36422 | 2008-04-30 2:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5833 days) | S3 | 6.0.x | Any | Any | EXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins |
27452 | 2007-03-26 17:35 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5632 days) | S3 | 5.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzr | Linux | Any | Correlated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA |
104562 | 2021-08-06 16:55 | 2021-08-06 17:55 | MySQL Server: DML | Verified (987 days) | S3 | 8.0.26 | Debian (10.9) | x86 | UUID function not executed in implicit subquery, but execute in explicit subquer |
109736 | 2023-01-23 10:41 | 2023-01-25 7:41 | MySQL Server: Optimizer | Verified (450 days) | S2 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | ANY query with wrong result |
111358 | 2023-06-12 8:41 | 2023-06-14 11:35 | MySQL Server: DML | Verified (311 days) | S3 | 8.0 | Any | Any | delete handl error |
113551 | 2024-01-04 10:04 | 2024-01-10 11:21 | MySQL Server: Optimizer | Verified (100 days) | S3 | 8.2.0 | Linux (mysql docker image 8.2.0) | Any | Discrepancy in MySQL 8.2.0 Documentation Regarding Subquery Scoping Rules |
Showing all 18 (Edit, Save, CSV, Feed) |