| Showing 1-30 of 199 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 44962 | 2009-05-19 19:34 | 2012-10-22 8:10 | MySQL Server: Optimizer | Can't repeat (4196 days) | S5 | 5.1.34, 5.1.36-bzr, 5.1.40-bzr | Linux | Any | DEPENDENT SUBQUERY not using a range index, resulting in slow performance |
| 54281 | 2010-06-07 9:49 | 2012-10-15 14:40 | MySQL Server: Optimizer | Can't repeat (4203 days) | S3 | mysql-next-mr-opt-backporting | Any | Any | Procedure fails on second call with subquery materialization and views |
| 45365 | 2009-06-08 8:40 | 2011-11-24 13:20 | MySQL Cluster: Cluster (NDB) storage engine | Can't repeat (4529 days) | S3 | mysql-5.1-telco-7.0 | Any | Any | Subquery keeps the mysqld server in preparing phase |
| 46305 | 2009-07-20 12:01 | 2011-02-16 23:44 | MySQL Server: Optimizer | Can't repeat (5210 days) | S2 | 6.0 | Any | Any | Wrong and variable result on simple JOIN + XOR + subquery optimizations |
| 38201 | 2008-07-17 15:36 | 2011-02-16 23:43 | MySQL Server: Optimizer | Can't repeat (5245 days) | S2 | 6.0 | Any | Any | Wrong result when left join + subquery + semijoin |
| 37115 | 2008-05-31 2:16 | 2011-02-16 23:43 | MySQL Server: Optimizer | Can't repeat (5260 days) | S3 | 6.0-bk | Any | Any | Subquery result differs between materialization and in->exists strategies |
| 46797 | 2009-08-18 22:04 | 2011-02-16 23:44 | MySQL Server: Optimizer | Can't repeat (5266 days) | S3 | 6.0 | Any | Any | Crash in fix_semijoin_strategies_for_picked_join_order with semijoin=on |
| 38015 | 2008-07-10 13:11 | 2011-02-16 23:43 | MySQL Server: Optimizer | Can't repeat (5330 days) | S2 | 6.0,5.4 | Any | Any | Bad result: inconsistent treatment of comparisons between data types in subquery |
| 35042 | 2008-03-04 16:57 | 2008-04-21 21:25 | MySQL Server: Optimizer | Can't repeat (5841 days) | S2 | Server version: 5.0.45-community-log | Linux | Any | Subquery using IN causes MySQL to hang |
| 27986 | 2007-04-20 15:20 | 2008-04-07 8:36 | MySQL Server: DML | Can't repeat (5855 days) | S3 | 5.0.27, 5.1 | Linux | Any | Long Decimals from sub-queries used in updates give wrong results |
| 34029 | 2008-01-24 5:39 | 2008-01-24 7:15 | MySQL Server: Data Types | Can't repeat (5929 days) | S3 | 5.0.x | Linux (Fedora Core 5 + 6) | Any | Time data types are not reported as correct type when used in a sub query |
| 32933 | 2007-12-03 15:13 | 2008-01-11 17:04 | MySQL Server: Optimizer | Can't repeat (5942 days) | S2 | 5.0.52, 5.1.22-rc-community | Windows | Any | missing results with order by and limit in subquery in combination with indexes |
| 30659 | 2007-08-28 1:03 | 2007-08-31 9:59 | MySQL Server: Optimizer | Can't repeat (6075 days) | S3 | 5.2.6 | Linux (2.6.20) | Any | 300% Performance Regression 5.0.45 -> 5.2.6 on Correlated Subquery |
| 27369 | 2007-03-22 9:14 | 2007-03-26 9:03 | MySQL Server: General | Can't repeat (6233 days) | S3 | 5.0.33 and 4.1.29 | Linux (Linux and Windows XP) | Any | Incorrect Query Result when using Subqueries and User Defined Varaibles |
| 21418 | 2006-08-02 15:04 | 2006-08-23 14:36 | MySQL Server: Optimizer | Can't repeat (6448 days) | S2 | 5.0.22/4.1;5.0;5.1BK | Linux (Linux (FC3)) | Any | Correlated subqueries with UNIQUE columns used in WHERE clause are incorrect |
| 21608 | 2006-08-13 5:49 | 2006-08-13 17:09 | MySQL Query Browser | Can't repeat (6458 days) | S1 | 1.2.1 beta | Windows (Windows XP SP2) | Any | MySQL Query Browser causes error in valid query with subquery |
| 69721 | 2013-07-11 4:55 | 2021-04-08 16:54 | MySQL Server: Documentation | Closed (1466 days) | S3 | 5.6, 5.6.39, 5.7.21 | Any | Any | Block Nested Loop making things slower |
| 72098 | 2014-03-21 20:47 | 2019-11-18 22:37 | MySQL Server: DML | Closed (1613 days) | S3 | 5.5, 5.5.38 | Any | Any | select * from (subquery) get different result with subquery. |
| 97063 | 2019-09-30 10:26 | 2019-11-18 13:18 | MySQL Server: Optimizer | Closed (1613 days) | S3 | 8.0.14+ | Any | Any | Wrong behavior of '=' condition when working with complex subqueries |
| 35794 | 2008-04-03 12:06 | 2020-05-25 8:42 | MySQL Server: Optimizer | Closed (1689 days) | S3 | 5.0.45, 5.0, 5.1, 6.0 BK | Any | Any | Very bad query optimization on DELETE with subquery |
| 75462 | 2015-01-09 10:15 | 2015-12-09 21:37 | MySQL Workbench: SQL Editor | Closed (3053 days) | S3 | 6.2.4.12437 | Windows (windows 7 and 8.1) | Any | False syntax error when enclosing subquery in two parentheses |
| 63701 | 2011-12-09 18:42 | 2014-01-23 8:27 | MySQL Server: Optimizer | Closed (3738 days) | S3 | 5.1.48.4 x86_64 | Linux (RHEL 4U8) | Any | MySQL Chooses unnecessarily to run subquery as dependent |
| 27199 | 2007-03-16 5:03 | 2013-09-09 9:28 | MySQL Server: Optimizer | Closed (3874 days) | S2 | 5.0.22, 5.0.37, 4.1 BK, 5.1 BK | Linux (linux) | Any | Performance problem when query contains a left join against a subquery |
| 46223 | 2009-07-16 14:01 | 2012-10-15 14:08 | MySQL Server: Optimizer | Closed (4203 days) | S3 | 5.0,5.1,.5.4 | Any | Any | JOIN + SUBQUERY with DISTINCT + XOR causes wrong result |
| 64557 | 2012-03-06 0:12 | 2012-10-08 18:33 | MySQL Server: Optimizer | Closed (4210 days) | S2 | 5.1.56, 5.5.20, 5.6.4 | Windows (XP Pro SP3) | Any | Correlated subquery performance is degraded in releases alfter 5.0 |
| 59943 | 2011-02-04 11:12 | 2012-07-29 22:37 | MySQL Server: Optimizer | Closed (4281 days) | S1 | 5.6.2-m5 | Any | Any | materialization=on/off leads to different result set when using IN & VAR_POP |
| 47914 | 2009-10-08 9:10 | 2012-03-26 19:30 | MySQL Server: Optimizer | Closed (4406 days) | S2 | 4.1 and 5.1 | Windows (Windows Server 2003) | Any | Performance Issue with Subquery |
| 40037 | 2008-10-15 9:34 | 2011-10-20 3:46 | MySQL Server: Optimizer | Closed (4564 days) | S3 | 5.x, 6.x | Any | Any | Incorrect result from MIN/MAX when no GROUP, and independent subquery predicate |
| 43768 | 2009-03-20 13:58 | 2011-07-07 14:29 | MySQL Server: Optimizer | Closed (4669 days) | S2 | 6.0 | Any | Any | Prepared query with nested subqueries core dumps on second execution |
| 59919 | 2011-02-03 10:49 | 2011-04-21 1:00 | MySQL Server: Optimizer | Closed (4746 days) | S1 | 5.6.2-m5 (mysql-next-mr-opt-backpointing) | Any | Any | Crash in TMP_TABLE_PARAM::init() with semijoin=on |
| Showing 1-30 of 199 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
