| Showing 1-30 of 34 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Type | Status | Sev | Version | Target | OS | Summary | Assigned |
|---|---|---|---|---|---|---|---|---|---|
| 27199 | 2007-03-16 6:03 | Server: Optimizer | Verified (404 days) | S2 | 5.0.22, 5.0.37, 4.1 BK, 5.1 BK | Linux (linux) | Performance problem when query contains a left join against a subquery | Ramil Kalimullin | |
| 27452 | 2007-03-26 19:35 | Server: Optimizer | Verified (372 days) | S3 | 5.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzr | Linux | Correlated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA | Gleb Shchepa | |
| 31480 | 2007-10-09 15:29 | Server: Optimizer | In progress (57 days) | S2 | 6.0-{main, opt} | Any | Incorrect result for nested subquery when executed via semi join | ||
| 32341 | 2007-11-13 20:29 | Server: Optimizer | Verified (404 days) | S3 | 5.0.41, 5.0.52 | Linux | Subquery does not use index with session variable, works with string literal | Timour Katchaounov | |
| 33647 | 2008-01-03 11:16 | Server: DML | Verified (690 days) | S3 | 5.1.22 | Any | WITH ROLLUP fails when using subqueries | Evgeny Potemkin | |
| 35794 | 2008-04-03 14:06 | Server: Optimizer | Verified (526 days) | S3 | 5.0.45, 5.0, 5.1, 6.0 BK | Any | Very bad query optimization on DELETE with subquery | Sergey Petrunya | |
| 36422 | 2008-04-30 4:19 | Server: Optimizer | Verified (573 days) | S3 | 6.0.x | Any | EXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins | Sergey Petrunya | |
| 37893 | 2008-07-05 22:00 | Server: Optimizer | Patch pending (132 days) | S1 | 6.0 | Any | Crash in select_describe line 19251 on a FirstMatch query with OUTER JOIN | ||
| 38075 | 2008-07-12 20:40 | Server: Optimizer | In progress (19 days) | S2 | 6.0.6-bzr | Any | Wrong result: rows matching a subquery with outer join not returned | Roy Lyseng | |
| 38201 | 2008-07-17 17:36 | Server: Optimizer | Verified (495 days) | S2 | 6.0 | Any | Wrong result when left join + subquery + semijoin | ||
| 40037 | 2008-10-15 11:34 | Server: Optimizer | Verified | S3 | 5.x, 6.x | Any | Incorrect result from MIN/MAX when no GROUP, and independent subquery predicate | Georgi Kodinov | |
| 44215 | 2009-04-11 14:57 | Server | Verified (129 days) | S3 | 5.0.67,5.0.77,5.1.33,6.0 | Microsoft Windows (Windows XP SP3) | Cannot run 32+ union of two levels nested subquery | ||
| 45174 | 2009-05-29 0:51 | Server: Optimizer | In progress (31 days) | S3 | 6.0 | Any | XOR in subqueries produces differing results in 5.1 and 5.4 | Evgeny Potemkin | |
| 45221 | 2009-05-31 21:22 | Server: Optimizer | Patch pending | S3 | 6.0 | Any | Query "SELECT pk FROM C WHERE pk IN (SELECT int_key)" failing | Jorgen Loland | |
| 45227 | 2009-06-01 0:48 | Server: Optimizer | Need Doc Info (11 days) | S3 | 5.4 | 5.4+ | Any | Queries with IN + condition, HAVING, ORDER BY 'pk' and LIMIT produce bad results | Evgeny Potemkin |
| 45365 | 2009-06-08 10:40 | Server: Cluster | Verified (169 days) | S3 | mysql-5.1-telco-7.0 | Any | Subquery keeps the mysqld server in preparing phase | ||
| 45863 | 2009-06-30 21:20 | Server: Optimizer | Patch pending (19 days) | S3 | 6.0 | Any | Assertion failed: (fixed == 0), function fix_fields, file item.cc, line 4448 | Roy Lyseng | |
| 46288 | 2009-07-18 21:12 | Server: Optimizer | Verified (129 days) | S3 | 5.1.35-community, 5.1.36 | Microsoft Windows | Index is not used for equality condition on single-row, multiple column subquery | ||
| 46305 | 2009-07-20 14:01 | Server: Optimizer | Verified | S2 | 6.0 | Any | Wrong and variable result on simple JOIN + XOR + subquery optimizations | ||
| 46548 | 2009-08-04 18:42 | Server: Optimizer | Patch queued (1 day) | S3 | 6.0 | Any | IN-subqueries return 0 rows with materialization=on | Oystein Grovlen | |
| 46555 | 2009-08-04 22:42 | Server: Optimizer | Verified | S3 | 5.0, 5.1, 5.4/6.0 | 5.4+ | Any | MySQL processing LEFT JOIN in subqueries incorrectly with materialization = off | |
| 46556 | 2009-08-04 22:59 | Server: Optimizer | In progress | S3 | 6.0 | Any | Returning incorrect, empty results for some IN subqueries w/ semijoin=on | Oystein Grovlen | |
| 46692 | 2009-08-13 13:45 | Server: Optimizer | Patch pending (7 days) | S3 | 6.0 | Any | Crash occurring on queries with nested FROM subqueries using materialization | Oystein Grovlen | |
| 46744 | 2009-08-16 4:26 | Server: Optimizer | Patch queued (1 day) | S2 | 6.0 | Any (Windows 2003, Linux) | Crash in optimize_semijoin_nests on empty view with limit and procedure | Tor Didriksen | |
| 46759 | 2009-08-17 16:45 | Server: Locking | Open (41 days) | S2 | 5.1.35 | Any | Dependent subquery locks in 5.1 when it did not lock in 5.0 | ||
| 46860 | 2009-08-21 21:25 | Server: Optimizer | Need Doc Info (47 days) | S3 | 5.4/6.0 | 5.4+ | Any | Crash / segfault using EXPLAIN EXTENDED on query using UNION in subquery | Tor Didriksen |
| 47052 | 2009-09-01 21:22 | Server: Optimizer | Verified (83 days) | S3 | 6.0 | Any | wrong result, Subquery with VIEW containing BETWEEN | ||
| 47367 | 2009-09-16 14:00 | Server: Optimizer | Verified (69 days) | S3 | 6.0 | Any | Crash in Name_resolution_context::process_error | ||
| 47930 | 2009-10-09 9:50 | Server: FTS | Patch queued (14 days) | S3 | 5.0.77, 5.1.31, 5.1.41, 6.0.14 | 5.1+ | Linux | MATCH IN BOOLEAN MODE returns too many results inside subquery | Georgi Kodinov |
| 48073 | 2009-10-15 12:14 | Server: Optimizer | Patch pending (1 day) | S2 | 6.0.11, 6.0.14 | Mac OS X | Subquery on char columns from view crashes Mysql | Tor Didriksen |
| Showing 1-30 of 34 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
