Showing 1-30 of 87 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
57479 | 2010-10-15 10:38 | 2010-10-15 10:56 | MySQL Server: Optimizer | Not a Bug (4913 days) | S2 | mysql-next-mr-opt-backporting | Linux (Red Hat) | Any | subquery with LIMIT returns results incorrect, when optimizer_join_cache_level=4 |
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 |
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 |
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 |
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 |
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 |
51018 | 2010-02-09 9:19 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Batched key access gives wrong results for SELECT with semijoin and NULL |
48868 | 2009-11-18 15:42 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 days) | S3 | 6.0 | Any | Any | Left outer join in subquery causes segmentation fault in make_join_select |
54641 | 2010-06-20 7:48 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4856 days) | S3 | next-mr-opt-backporting | Any | Any | semijoin loosescan gives duplicate rows |
49952 | 2009-12-28 8:44 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0 | Any | Any | Inner tables in subquery outer join is not detected as constant tables |
49453 | 2009-12-04 10:31 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0 | Any | Any | re-execution of prepared statement with view and semijoin crashes |
49630 | 2009-12-11 16:30 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0 | Any | Any | Segfault in select_describe() with double nested subquery and materialization |
54437 | 2010-06-11 16:55 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | next-mr-opt-backporting | Any | Any | Extra rows with LEFT JOIN + semijoin (firstmatch and duplicates weedout) |
53970 | 2010-05-25 11:55 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5054 days) | S3 | next-mr-opt-backporting | Any | Any | join cache unduly disabled for incremental buffers with semijoin |
50089 | 2010-01-05 14:57 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 days) | S2 | 6.0 | Any | Any | Second call of procedure with view in subselect crashes server |
53305 | 2010-04-30 9:23 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Duplicate weedout + join buffer (join cache level=7,8) loses rows |
50489 | 2010-01-20 21:42 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0-codebase-bugfixing | Linux (64) | Any | another segfault in fix_semijoin_strategies_for_picked_join_order |
50361 | 2010-01-15 11:35 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0 | Any | Any | Doublenested noncorrelated subquery with FirstMatch and join cache wrong result |
50358 | 2010-01-15 10:01 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0-codebase | Any | Any | semijoin execution of subquery with outerjoin yields wrong result |
51084 | 2010-02-11 10:26 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0-codebase-bugfixing | Linux | Any | Batched key access crashes for SELECT with derived table and LEFT JOIN |
51110 | 2010-02-11 15:52 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Wrong result with COUNT(*) and semijoin |
53298 | 2010-04-29 21:15 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0-codebase-bugfixing | Any | Any | wrong result with semijoin (no semijoin strategy chosen) |
46744 | 2009-08-16 2:26 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 days) | S2 | 6.0 | Any (Windows 2003, Linux) | Any | Crash in optimize_semijoin_nests on empty view with limit and procedure |
52068 | 2010-03-15 15:49 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 days) | S2 | 6.0 | Any | Any | Optimizer generates invalid semijoin materialization plan |
51487 | 2010-02-25 8:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0 | Any | Any | Assertion failure when semi-join flattening occurs for a subquery in HAVING |
52092 | 2010-03-16 13:10 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 days) | S1 | mysql-6.0-codebase | Any | Any | Bad result in 6.0-codebase after setting correct block_size in bug#48229 |
51457 | 2010-02-24 14:24 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0-codebase-bugfixing | Linux | Any | Firstmatch semijoin strategy gives wrong results for certain query plans |
53060 | 2010-04-22 13:28 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4874 days) | S3 | 6.0 | Any | Any | LooseScan semijoin strategy does not return all rows |
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 |
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 |
Showing 1-30 of 87 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |