Showing 1-30 of 82 (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 (3715 days) | S2 | 6.0.11, 6.0.14 | Mac OS X | Any | Subquery on char columns from view crashes Mysql |
48763 | 2009-11-13 14:46 | 2011-03-21 4:17 | MySQL Server: Optimizer | Closed (3596 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 (4089 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 (4089 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 (4139 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 (3714 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 (3714 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 (3714 days) | S3 | 5.4 / 6.0 | Any | Any | NULL value not returned for aggregate on empty result set w/ semijoin on |
46797 | 2009-08-18 22:04 | 2011-02-16 23:44 | MySQL Server: Optimizer | Can't repeat (4085 days) | S3 | 6.0 | Any | Any | Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on |
42742 | 2009-02-10 22:00 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (3721 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 (4089 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 (3615 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 (3715 days) | S3 | 6.0 | Any | Any | XOR in subqueries produces differing results in 5.1 and 5.4 |
47052 | 2009-09-01 19:22 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (4065 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 (4043 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 (3715 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 (3714 days) | S3 | 6.0 | Any | Any | Crash in Name_resolution_context::process_error |
38201 | 2008-07-17 15:36 | 2011-02-16 23:43 | MySQL Server: Optimizer | Can't repeat (4064 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 (4089 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 (3717 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 (4029 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 (4132 days) | S3 | 6.0 | Any | Any | '= ANY' subqueries are not processed properly - returning 0 rows |
46744 | 2009-08-16 2:26 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (3715 days) | S2 | 6.0 | Any (Windows 2003, Linux) | Any | Crash in optimize_semijoin_nests on empty view with limit and procedure |
45191 | 2009-05-29 12:00 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (3717 days) | S2 | 6.0 | Any | Any | Nested subqueries, wrong result - duplicate rows |
48623 | 2009-11-09 7:59 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (3715 days) | S2 | 6.0 | Any | Any | Multiple subqueries are optimized incorrectly |
48834 | 2009-11-17 11:37 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (3715 days) | S3 | 6.0 | Any | Any | Procedure with view + subquery + semijoin=on crashes on second call. |
48868 | 2009-11-18 15:42 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (3715 days) | S3 | 6.0 | Any | Any | Left outer join in subquery causes segmentation fault in make_join_select |
49097 | 2009-11-25 12:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (3714 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 (3714 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 (4072 days) | S3 | 6.0 | Any | Any | Select_type in explain output incorrect for semijoin queries |
Showing 1-30 of 82 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |