Showing all 25 (Edit, Save, CSV, Feed) |
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 (4385 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 (4182 days) | S5 | 4.1.18 | Linux (Linux) | Any | nested query super slow..should not be |
54518 | 2010-06-15 14:25 | 2012-10-15 13:31 | MySQL Server | Closed (4182 days) | S5 | 5.0.22 | Windows (Vista) | Any | Very bad performance with subselect |
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 |
59833 | 2011-01-31 8:06 | 2011-02-27 2:43 | MySQL Server: Optimizer | Closed (4778 days) | S1 | 5.6.2-m5 | Any | Any | materialization=on/off leads to different result set when using IN |
57431 | 2010-10-13 13:57 | 2011-03-03 2:13 | MySQL Server: Optimizer | Closed (4774 days) | S2 | 5.6.99 | Linux (Red Hat) | Any | subquery returns wrong results (semijoin=on) with predicate AND |
56080 | 2010-08-18 1:49 | 2011-05-03 1:01 | MySQL Server: Optimizer | Closed (4713 days) | S3 | 5.6.99-m5-debug | Any | Any | Assertion `inited==INDEX' in sql/handler.h:1534 on SELECT MAX(..) |
69138 | 2013-05-03 16:10 | 2013-07-01 16:39 | MySQL Server: DML | Closed (3923 days) | S5 | 5.7, 5.6 | Any | Any | Wasted work in method Item_in_subselect::single_value_transformer |
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 |
40667 | 2008-11-12 13:37 | 2018-09-25 21:49 | Tests: Server | Closed (4881 days) | S7 | 6.0 | Any | Any | subselect.test switches connection at line 1464, forgets optimization settings |
43768 | 2009-03-20 13:58 | 2011-07-07 14:29 | MySQL Server: Optimizer | Closed (4648 days) | S2 | 6.0 | Any | Any | Prepared query with nested subqueries core dumps on second execution |
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 |
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 |
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 |
45863 | 2009-06-30 19:20 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 days) | S3 | 6.0 | Any | Any | Assertion failed: (fixed == 0), function fix_fields, file item.cc, line 4448 |
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 |
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 |
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 |
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 |
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 |
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 |
55955 | 2010-08-12 17:54 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4875 days) | S3 | mysql-next-mr-opt-backporting | Linux | Any | crash in MEMORY engine with IN(LEFT JOIN (JOIN)) |
57623 | 2010-10-21 10:43 | 2011-03-02 3:16 | MySQL Server: Optimizer | Closed (4775 days) | S1 | mysql-next-mr-opt-backporting | Any | Any | subquery within before insert trigger causes crash (semijoin=on) |
58561 | 2010-11-29 14:22 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4816 days) | S1 | mysql-next-mr-opt-backporting | Linux (Rqd Hat x86) | Any | Server Crash with correlated subquery and MyISAM tables when semijoin=on |
57525 | 2010-10-18 13:35 | 2011-03-03 1:25 | MySQL Server: Optimizer | Closed (4774 days) | S3 | next-mr-opt-backporting | Any | Any | Semijoin transformed subquery with inner grouped subquery gives empty result |
Showing all 25 (Edit, Save, CSV, Feed) |