Showing all 17 (Edit, Save, CSV, Feed) |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
8804 | 2005-02-25 10:47 | 2006-12-11 8:34 | MySQL Server: Optimizer | Closed (6318 days) | S2 | Server version: 4.1.9-Max/4.1.15 BK source | Linux (Linux) | Any | wrong result for [null_expr] IN (SELECT ...) |
27452 | 2007-03-26 17:35 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5611 days) | S3 | 5.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzr | Linux | Any | Correlated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA |
27430 | 2007-03-26 0:45 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Closed (5251 days) | S3 | 5.1.18-debug, 5.0.42 | Any | Any | Crash in subquery code when in PS and table DDL changed after PREPARE |
30993 | 2007-09-13 8:34 | 2011-02-16 23:43 | MySQL Server | Closed (4878 days) | S3 | 5.2-bk | Any | Any | Subqueries: LooseScan strategy produces wrong query results, with duplicates |
31080 | 2007-09-18 14:12 | 2007-09-18 15:24 | MySQL Server: Locking | Not a Bug (6037 days) | S3 | 5.0.45 | Windows (2000 Server) | Any | LOCK TABLES + subqueries: Table 'test' was not locked with LOCK TABLES |
31563 | 2007-10-12 12:08 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (4878 days) | S3 | 5.2 | Any | Any | Semi-joins: pullout of functionally-dependent tables is not transitive |
35458 | 2008-03-20 12:36 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5781 days) | S3 | 6.0.4 | Any | Any | Wrong execution strategy for uncorrelated subquery |
35468 | 2008-03-20 20:01 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (4876 days) | S3 | 6.0.4 | Any | Any | Slowdown and wrong result for uncorrelated subquery w/o where |
31468 | 2007-10-08 21:05 | 2008-04-08 15:51 | MySQL Server: Documentation | Closed (5834 days) | S3 | 4.1+ | Any | Any | EXPLAIN executes data-modification statements when building plan |
36422 | 2008-04-30 2:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5812 days) | S3 | 6.0.x | Any | Any | EXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins |
42174 | 2009-01-16 22:46 | 2011-02-16 23:43 | MySQL Server: General | Duplicate (5548 days) | S2 | 5.0.67 & 4.1.22 | Linux | Any | Select count(*) with subquery consuming multi-gigs of memory, 5.0.67 & 4.1.22 |
43160 | 2009-02-24 21:45 | 2012-05-18 20:19 | MySQL Server: Locking | Duplicate (5450 days) | S3 | 5.0.72, 5.1.31 | Any | Any | InnoDB uses X locks when S locks would work in DML subqueries |
46791 | 2009-08-18 17:40 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5215 days) | S3 | 5.0.82, 5.1, 5.4/6.0 | Any | Any | Assertion failed:(table->key_read==0),function unknown function,file sql_base.cc |
53706 | 2010-05-17 14:27 | 2018-09-23 20:45 | MySQL Server: InnoDB storage engine | Duplicate (5050 days) | S2 | 5.1.42, 5.1.47, 5.1.48-bzr, 5.6.99 | Linux | Any | transaction isolation does not work on subqueries |
63701 | 2011-12-09 18:42 | 2014-01-23 8:27 | MySQL Server: Optimizer | Closed (3718 days) | S3 | 5.1.48.4 x86_64 | Linux (RHEL 4U8) | Any | MySQL Chooses unnecessarily to run subquery as dependent |
77351 | 2015-06-15 1:23 | 2015-12-15 14:17 | MySQL Server: Documentation | Closed (3027 days) | S3 | 5.6 | Linux | Any | Result of "Optimizing Subqueries with EXISTS Strategy" is not same as document |
106006 | 2021-12-30 3:10 | 2022-01-11 14:44 | MySQL Server: Optimizer | Closed (808 days) | S5 | 8.0.25, 8.0.27, 5.7.36 | Any (rhel-7.4) | Any (x86-64) | conditions are not pushed down into subqueries with union all: performance issue |
Showing all 17 (Edit, Save, CSV, Feed) |