| Showing all 19 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 24127 | 2006-11-09 7:53 | 2007-02-03 2:25 | MySQL Server: Optimizer | Closed (6284 days) | S3 | Any | (a,b) IN (SELECT c,d ...) can produce wrong results if a and/or b are NULLs. | ||
| 24665 | 2006-11-28 18:13 | 2006-12-29 1:42 | MySQL Server | No Feedback (6320 days) | S2 | 4.1.11-Debian_4sarge7-log | Linux (linux debian 3.1) | Any | update+subselect+left join does not replicate correctly |
| 23478 | 2006-10-19 19:55 | 2006-11-28 19:59 | MySQL Server: Optimizer | Closed (6351 days) | S2 | 4.1/5.0/5.1BK | Linux (Linux) | Any | Incorrect query result for index_subquery-based IN subquery |
| 21184 | 2006-07-20 15:25 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6421 days) | S2 | 5.0 | Any (all) | Any | Bug with a Query with "NOT IN" |
| 22997 | 2006-10-05 1:38 | 2006-10-05 6:46 | MySQL Server | Not a Bug (6405 days) | S3 | 5.0.18-nt | Windows (windows) | Any | subselects with distincts take long time to process |
| 54518 | 2010-06-15 14:25 | 2012-10-15 13:31 | MySQL Server | Closed (4203 days) | S5 | 5.0.22 | Windows (Vista) | Any | Very bad performance with subselect |
| 28036 | 2007-04-23 19:16 | 2007-04-23 20:53 | MySQL Server: General | Closed (6205 days) | S3 | 5.0.27, 5.0.33, 5.0.37, 5.2.3-falcon-alpha-community-nt | Any | Any | Server crash when subselect on a union ordering on a field that does not exist. |
| 30175 | 2007-08-01 9:39 | 2007-08-01 13:43 | MySQL Server | Can't repeat (6105 days) | S2 | 5.0.40 | Linux | Any | GROUP BY returns wrong records with subquery condition NOT EXISTS |
| 27870 | 2007-04-17 3:44 | 2007-04-24 1:05 | MySQL Server: Optimizer | Closed (6204 days) | S1 | 5.0.40, 5.1.18 | Any | Any | join and subselect crash server |
| 29630 | 2007-07-08 19:27 | 2007-07-09 13:07 | MySQL Server | Closed (6128 days) | S2 | 5.0.41-community-nt | Windows | Any | "group by" doesnt work with subselects |
| 32858 | 2007-11-29 20:48 | 2011-02-16 23:43 | MySQL Server: Parser | Closed (5674 days) | S2 | 5.0.45, 5.1.x, 6.0.3 | Linux (Debian) | Any | Error: "Incorrect usage of UNION and INTO" does not take subselects into account |
| 37002 | 2008-05-27 11:27 | 2008-05-31 19:15 | MySQL Server | Can't repeat (5801 days) | S2 | 5.0.51b-community-nt | Any | Any | DESCRIBE returns error 1064 |
| 49009 | 2009-11-23 23:43 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | No Feedback (5229 days) | S3 | 5.0.77 | Any | Any | Subselect seems to implicitly do LOCK IN SHARE MODE? |
| 22930 | 2006-10-03 12:41 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6294 days) | S3 | 5.1-bk | Any | Wrong EXPLAIN output for query with subquery | |
| 22765 | 2006-09-27 23:01 | 2014-08-27 15:05 | MySQL Server: Partitions | Closed (5931 days) | S5 | 5.1.11-beta-log | Linux (Linux, Fedora core 5) | Any | subselect uses all partitions instead of the actual needed ones. |
| 33060 | 2007-12-07 12:18 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (5628 days) | S1 | 5.1.22-rc | Linux (Debian 4.0, mysql from src) | Any | Crash on subselect with MAX() |
| 69969 | 2013-08-09 5:47 | 2014-03-27 13:43 | MySQL Server: Optimizer | Closed (3723 days) | S2 | 5.5.33 | Any | Any | Failing assertion: prebuilt->trx->conc_state == 1 from subselect |
| 69648 | 2013-07-02 16:04 | 2013-07-15 7:37 | MySQL Server: DML | Verified (3930 days) | S3 | 5.6.12 | Any | Any | Subselect of literals in FROM throws "Duplicate column name" error |
| 22015 | 2006-09-05 12:24 | 2006-10-04 19:27 | MySQL Server | Closed (6406 days) | S1 | mysql-debug-5.0.24a-linux-i686-icc-glibc | Linux (Debian-GNU/Linux 2.6.16-2-k7) | Any | nested group_concat in subselect results in server crash |
| Showing all 19 (Edit, Save, CSV, Feed) |
