| Showing 1-30 of 87 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 46551 | 2009-08-04 17:29 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5314 days) | S3 | 6.0 | Any | Any | '= ANY' subqueries are not processed properly - returning 0 rows |
| 50489 | 2010-01-20 21:42 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | 6.0-codebase-bugfixing | Linux (64) | Any | another segfault in fix_semijoin_strategies_for_picked_join_order |
| 51487 | 2010-02-25 8:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | 6.0 | Any | Any | Assertion failure when semi-join flattening occurs for a subquery in HAVING |
| 44303 | 2009-04-16 1:55 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (4899 days) | S1 | 6.0.10-debug, 6.0.12-debug, 5.4.4-alpha-debug | Any | Any | Assertion failures in Field_xxx::store_xxx for materialized InsideOut semijoins |
| 46550 | 2009-08-04 16:54 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | 6.0 | Any | Any | Azalea returning duplicate results for some IN subqueries w/ semijoin=on |
| 52092 | 2010-03-16 13:10 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4897 days) | S1 | mysql-6.0-codebase | Any | Any | Bad result in 6.0-codebase after setting correct block_size in bug#48229 |
| 51084 | 2010-02-11 10:26 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | 6.0-codebase-bugfixing | Linux | Any | Batched key access crashes for SELECT with derived table and LEFT JOIN |
| 51018 | 2010-02-09 9:19 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Batched key access gives wrong results for SELECT with semijoin and NULL |
| 51016 | 2010-02-09 8:57 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (5181 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Batched key access gives wrong results for T0 semijoin (T1 join T2) |
| 57954 | 2010-11-03 13:43 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4852 days) | S3 | mysql-next-mr-opt-backporting,5.5 | Linux (Rqd Hat x86) | Any | BIT_AND function returns incorrect results when semijoin=on |
| 58050 | 2010-11-08 12:33 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (4888 days) | S2 | mysql-next-mr-opt-backporting,5.5 | Linux (RedHat x64) | Any | BIT_OR and BIT_XOR return incorrect results when semijoin=on |
| 46797 | 2009-08-18 22:04 | 2011-02-16 23:44 | MySQL Server: Optimizer | Can't repeat (5267 days) | S3 | 6.0 | Any | Any | Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on |
| 49632 | 2009-12-11 20:47 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (5208 days) | S3 | 6.0 | Any | Any | Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on (return) |
| 55955 | 2010-08-12 17:54 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4897 days) | S3 | mysql-next-mr-opt-backporting | Linux | Any | crash in MEMORY engine with IN(LEFT JOIN (JOIN)) |
| 47367 | 2009-09-16 12:00 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | 6.0 | Any | Any | Crash in Name_resolution_context::process_error |
| 46744 | 2009-08-16 2:26 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4897 days) | S2 | 6.0 | Any (Windows 2003, Linux) | Any | Crash in optimize_semijoin_nests on empty view with limit and procedure |
| 45933 | 2009-07-03 8:57 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5271 days) | S2 | 6.0 | Any | Any | Crash in optimize_semijoin_nests on JOIN in subquery + AND in outer query |
| 37893 | 2008-07-05 20:00 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5225 days) | S1 | 6.0 | Any | Any | Crash in select_describe line 19251 on a FirstMatch query with OUTER JOIN |
| 42742 | 2009-02-10 22:00 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (4903 days) | S1 | 6.0.10-debug | Any | Any | crash in setup_sj_materialization, Copy_field::set |
| 59919 | 2011-02-03 10:49 | 2011-04-21 1:00 | MySQL Server: Optimizer | Closed (4747 days) | S1 | 5.6.2-m5 (mysql-next-mr-opt-backpointing) | Any | Any | Crash in TMP_TABLE_PARAM::init() with semijoin=on |
| 45219 | 2009-05-31 17:51 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5271 days) | S3 | 6.0 | Any | Any | Crash on SELECT DISTINCT query containing a LEFT JOIN in subquery |
| 50361 | 2010-01-15 11:35 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | 6.0 | Any | Any | Doublenested noncorrelated subquery with FirstMatch and join cache wrong result |
| 53305 | 2010-04-30 9:23 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Duplicate weedout + join buffer (join cache level=7,8) loses rows |
| 54437 | 2010-06-11 16:55 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | next-mr-opt-backporting | Any | Any | Extra rows with LEFT JOIN + semijoin (firstmatch and duplicates weedout) |
| 51457 | 2010-02-24 14:24 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4896 days) | S3 | 6.0-codebase-bugfixing | Linux | Any | Firstmatch semijoin strategy gives wrong results for certain query plans |
| 106718 | 2022-03-13 4:27 | 2022-03-24 22:23 | MySQL Server: Optimizer | Closed (757 days) | S2 | 8.0.28 | Any | Any | Incorrect inner hash join when using materialization strategy |
| 106717 | 2022-03-13 3:54 | 2022-03-14 10:36 | MySQL Server: Optimizer | Verified (767 days) | S2 | 8.0.28, 8.0.27 | Any | Any | Incorrect nested loop antijoin when using materialization strategy |
| 31480 | 2007-10-09 13:29 | 2011-03-02 3:28 | MySQL Server: Optimizer | Closed (4797 days) | S2 | 6.0-{main, opt} | Any | Any | Incorrect result for nested subquery when executed via semi join |
| 107585 | 2022-06-17 10:29 | 2022-06-17 11:18 | MySQL Server: Optimizer | Verified (672 days) | S3 | 8.0.29 | Ubuntu (ubuntu 20.04) | x86 | Incorrect result in semi-join and left-join |
| 51283 | 2010-02-18 14:06 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (5153 days) | S3 | 6.0-codebase-bugfixing | Linux | Any | incremental join buffering + dup weedout + 2 semijoins = missing row |
| Showing 1-30 of 87 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
