| Showing 1-30 of 88 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 48073 | 2009-10-15 10:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5348 days) | S2 | 6.0.11, 6.0.14 | MacOS | Any | Subquery on char columns from view crashes Mysql |
| 48763 | 2009-11-13 14:46 | 2011-03-21 4:17 | MySQL Server: Optimizer | Closed (5229 days) | S3 | 5.0.45 | Linux | Any | Slow Query, sub query + query returning in 88 seconds |
| 45219 | 2009-05-31 17:51 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5722 days) | S3 | 6.0 | Any | Any | Crash on SELECT DISTINCT query containing a LEFT JOIN in subquery |
| 45933 | 2009-07-03 8:57 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5722 days) | S2 | 6.0 | Any | Any | Crash in optimize_semijoin_nests on JOIN in subquery + AND in outer query |
| 46072 | 2009-07-09 2:32 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5772 days) | S3 | 5.4.4-alpha-debug-log | Any | Any | Wrong result and nonviable execution time for subquery with semijoin |
| 46550 | 2009-08-04 16:54 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5347 days) | S3 | 6.0 | Any | Any | Azalea returning duplicate results for some IN subqueries w/ semijoin=on |
| 46556 | 2009-08-04 20:59 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5347 days) | S3 | 6.0 | Any | Any | Returning incorrect, empty results for some IN subqueries w/ semijoin=on |
| 46733 | 2009-08-14 17:02 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5347 days) | S3 | 5.4 / 6.0 | Any | Any | NULL value not returned for aggregate on empty result set w/ semijoin on |
| 42742 | 2009-02-10 22:00 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5354 days) | S1 | 6.0.10-debug | Any | Any | crash in setup_sj_materialization, Copy_field::set |
| 42353 | 2009-01-26 19:30 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5722 days) | S3 | 6.0-bk | Any | Any | SELECT ... WHERE oe IN (SELECT w/ LEFT JOIN) query causes crash |
| 31480 | 2007-10-09 13:29 | 2011-03-02 3:28 | MySQL Server: Optimizer | Closed (5248 days) | S2 | 6.0-{main, opt} | Any | Any | Incorrect result for nested subquery when executed via semi join |
| 45174 | 2009-05-28 22:51 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5348 days) | S3 | 6.0 | Any | Any | XOR in subqueries produces differing results in 5.1 and 5.4 |
| 46797 | 2009-08-18 22:04 | 2011-02-16 23:44 | MySQL Server: Optimizer | Can't repeat (5718 days) | S3 | 6.0 | Any | Any | Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on |
| 38201 | 2008-07-17 15:36 | 2011-02-16 23:43 | MySQL Server: Optimizer | Can't repeat (5697 days) | S2 | 6.0 | Any | Any | Wrong result when left join + subquery + semijoin |
| 43977 | 2009-03-31 8:44 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5722 days) | S2 | 6.0.10,6.0-bzr | Any (FreeBSD, Linux) | Any | Nested queries / Subqueries with outer joins produce errors |
| 44303 | 2009-04-16 1:55 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5350 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 |
| 46305 | 2009-07-20 12:01 | 2011-02-16 23:44 | MySQL Server: Optimizer | Can't repeat (5662 days) | S2 | 6.0 | Any | Any | Wrong and variable result on simple JOIN + XOR + subquery optimizations |
| 46551 | 2009-08-04 17:29 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5765 days) | S3 | 6.0 | Any | Any | '= ANY' subqueries are not processed properly - returning 0 rows |
| 47052 | 2009-09-01 19:22 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (5698 days) | S3 | 6.0 | Any | Any | wrong result, Subquery with VIEW containing BETWEEN |
| 37893 | 2008-07-05 20:00 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5676 days) | S1 | 6.0 | Any | Any | Crash in select_describe line 19251 on a FirstMatch query with OUTER JOIN |
| 38075 | 2008-07-12 18:40 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5348 days) | S2 | 6.0.6-bzr | Any | Any | Wrong result: rows matching a subquery with outer join not returned |
| 47367 | 2009-09-16 12:00 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5347 days) | S3 | 6.0 | Any | Any | Crash in Name_resolution_context::process_error |
| 45191 | 2009-05-29 12:00 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5350 days) | S2 | 6.0 | Any | Any | Nested subqueries, wrong result - duplicate rows |
| 49097 | 2009-11-25 12:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5347 days) | S3 | 6.0.14 | Any | Any | subquery with view generates wrong result with non-prepared statement |
| 49129 | 2009-11-26 10:06 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5347 days) | S3 | 6.0.14-bzr | Any | Any | Wrong result with IN-subquery with join_cache_level=6 and firstmatch=off |
| 49200 | 2009-11-30 10:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5705 days) | S3 | 6.0 | Any | Any | Select_type in explain output incorrect for semijoin queries |
| 48623 | 2009-11-09 7:59 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5348 days) | S2 | 6.0 | Any | Any | Multiple subqueries are optimized incorrectly |
| 49198 | 2009-11-30 8:55 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5347 days) | S3 | 6.0 | Any | Any | Wrong result for second call of procedure with view in subselect |
| 48834 | 2009-11-17 11:37 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5348 days) | S3 | 6.0 | Any | Any | Procedure with view + subquery + semijoin=on crashes on second call. |
| 49845 | 2009-12-21 10:46 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5348 days) | S2 | 6.0 | Any | Any | Loosescan reports different result than other semijoin methods |
| Showing 1-30 of 88 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
