Showing 1-30 of 87 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
10815 | 2005-05-24 7:36 | 2012-03-26 19:34 | MySQL Server: Optimizer | Closed (4386 days) | S2 | 4.1.12 | Linux (Linux) | Any | Sub-queries failure when using GROUP BY |
17952 | 2006-03-06 5:22 | 2012-10-15 13:48 | MySQL Server: Optimizer | Closed (4183 days) | S5 | 4.1.18 | Linux (Linux) | Any | nested query super slow..should not be |
24770 | 2006-12-02 0:37 | 2018-09-09 20:45 | MySQL Server: Optimizer | In progress (4757 days) | S5 | 5.1 | Any (all) | Any | update with subquery slow |
31480 | 2007-10-09 13:29 | 2011-03-02 3:28 | MySQL Server: Optimizer | Closed (4776 days) | S2 | 6.0-{main, opt} | Any | Any | Incorrect result for nested subquery when executed via semi join |
37893 | 2008-07-05 20:00 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5204 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 (4876 days) | S2 | 6.0.6-bzr | Any | Any | Wrong result: rows matching a subquery with outer join not returned |
38201 | 2008-07-17 15:36 | 2011-02-16 23:43 | MySQL Server: Optimizer | Can't repeat (5225 days) | S2 | 6.0 | Any | Any | Wrong result when left join + subquery + semijoin |
42353 | 2009-01-26 19:30 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5250 days) | S3 | 6.0-bk | Any | Any | SELECT ... WHERE oe IN (SELECT w/ LEFT JOIN) query causes crash |
42620 | 2009-02-05 12:36 | 2014-09-17 4:41 | MySQL Server: Optimizer | Closed (3481 days) | S3 | 6.0.10-pre | Any | Any | Wrong semi-join execution strategy for subquery |
42742 | 2009-02-10 22:00 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (4882 days) | S1 | 6.0.10-debug | Any | Any | crash in setup_sj_materialization, Copy_field::set |
43768 | 2009-03-20 13:58 | 2011-07-07 14:29 | MySQL Server: Optimizer | Closed (4649 days) | S2 | 6.0 | Any | Any | Prepared query with nested subqueries core dumps on second execution |
43977 | 2009-03-31 8:44 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5250 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 (4878 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 |
45174 | 2009-05-28 22:51 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4876 days) | S3 | 6.0 | Any | Any | XOR in subqueries produces differing results in 5.1 and 5.4 |
45191 | 2009-05-29 12:00 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4878 days) | S2 | 6.0 | Any | Any | Nested subqueries, wrong result - duplicate rows |
45219 | 2009-05-31 17:51 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5250 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 (5250 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 (5300 days) | S3 | 5.4.4-alpha-debug-log | Any | Any | Wrong result and nonviable execution time for subquery with semijoin |
46305 | 2009-07-20 12:01 | 2011-02-16 23:44 | MySQL Server: Optimizer | Can't repeat (5190 days) | S2 | 6.0 | Any | Any | Wrong and variable result on simple JOIN + XOR + subquery optimizations |
46550 | 2009-08-04 16:54 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 days) | S3 | 6.0 | Any | Any | Azalea returning duplicate results for some IN subqueries w/ semijoin=on |
46551 | 2009-08-04 17:29 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (5293 days) | S3 | 6.0 | Any | Any | '= ANY' subqueries are not processed properly - returning 0 rows |
46556 | 2009-08-04 20:59 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 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 (4875 days) | S3 | 5.4 / 6.0 | Any | Any | NULL value not returned for aggregate on empty result set w/ semijoin on |
46744 | 2009-08-16 2:26 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4876 days) | S2 | 6.0 | Any (Windows 2003, Linux) | Any | Crash in optimize_semijoin_nests on empty view with limit and procedure |
46797 | 2009-08-18 22:04 | 2011-02-16 23:44 | MySQL Server: Optimizer | Can't repeat (5246 days) | S3 | 6.0 | Any | Any | Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on |
47052 | 2009-09-01 19:22 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (5226 days) | S3 | 6.0 | Any | Any | wrong result, Subquery with VIEW containing BETWEEN |
47367 | 2009-09-16 12:00 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 days) | S3 | 6.0 | Any | Any | Crash in Name_resolution_context::process_error |
48073 | 2009-10-15 10:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4876 days) | S2 | 6.0.11, 6.0.14 | MacOS | Any | Subquery on char columns from view crashes Mysql |
48623 | 2009-11-09 7:59 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4876 days) | S2 | 6.0 | Any | Any | Multiple subqueries are optimized incorrectly |
48763 | 2009-11-13 14:46 | 2011-03-21 4:17 | MySQL Server: Optimizer | Closed (4757 days) | S3 | 5.0.45 | Linux | Any | Slow Query, sub query + query returning in 88 seconds |
Showing 1-30 of 87 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |