Showing 1-30 of 87 (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 (4875 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 (4756 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 (5249 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 (5249 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 (5299 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 (4874 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 (4874 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 (4874 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 (4881 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 (5249 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 (4775 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 (4875 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 (5245 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 (5224 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 (5249 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 (4877 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 (5189 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 (5292 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 (5225 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 (5203 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 (4875 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 (4874 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 (4877 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 (4874 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 (4874 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 (5232 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 (4875 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 (4874 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 (4875 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 (4875 days) | S2 | 6.0 | Any | Any | Loosescan reports different result than other semijoin methods |
Showing 1-30 of 87 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |