Showing all 17 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
88042005-02-25
10:47
2006-12-11
8:34
MySQL Server: OptimizerClosed
(6318 days)
S2Server version: 4.1.9-Max/4.1.15 BK sourceLinux (Linux)Anywrong result for [null_expr] IN (SELECT ...)
274522007-03-26
17:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5611 days)
S35.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzrLinuxAnyCorrelated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA
274302007-03-26
0:45
2011-02-16
23:43
MySQL Server: Prepared statementsClosed
(5251 days)
S35.1.18-debug, 5.0.42AnyAnyCrash in subquery code when in PS and table DDL changed after PREPARE
309932007-09-13
8:34
2011-02-16
23:43
MySQL ServerClosed
(4878 days)
S35.2-bkAnyAnySubqueries: LooseScan strategy produces wrong query results, with duplicates
310802007-09-18
14:12
2007-09-18
15:24
MySQL Server: LockingNot a Bug
(6037 days)
S35.0.45Windows (2000 Server)AnyLOCK TABLES + subqueries: Table 'test' was not locked with LOCK TABLES
315632007-10-12
12:08
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4878 days)
S35.2AnyAnySemi-joins: pullout of functionally-dependent tables is not transitive
354582008-03-20
12:36
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(5781 days)
S36.0.4AnyAnyWrong execution strategy for uncorrelated subquery
354682008-03-20
20:01
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4876 days)
S36.0.4AnyAnySlowdown and wrong result for uncorrelated subquery w/o where
314682007-10-08
21:05
2008-04-08
15:51
MySQL Server: DocumentationClosed
(5834 days)
S34.1+AnyAnyEXPLAIN executes data-modification statements when building plan
364222008-04-30
2:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5812 days)
S36.0.xAnyAnyEXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins
421742009-01-16
22:46
2011-02-16
23:43
MySQL Server: GeneralDuplicate
(5548 days)
S25.0.67 & 4.1.22LinuxAnySelect count(*) with subquery consuming multi-gigs of memory, 5.0.67 & 4.1.22
431602009-02-24
21:45
2012-05-18
20:19
MySQL Server: LockingDuplicate
(5450 days)
S35.0.72, 5.1.31AnyAnyInnoDB uses X locks when S locks would work in DML subqueries
467912009-08-18
17:40
2011-02-16
23:44
MySQL Server: OptimizerClosed
(5215 days)
S35.0.82, 5.1, 5.4/6.0AnyAnyAssertion failed:(table->key_read==0),function unknown function,file sql_base.cc
537062010-05-17
14:27
2018-09-23
20:45
MySQL Server: InnoDB storage engineDuplicate
(5050 days)
S25.1.42, 5.1.47, 5.1.48-bzr, 5.6.99LinuxAnytransaction isolation does not work on subqueries
637012011-12-09
18:42
2014-01-23
8:27
MySQL Server: OptimizerClosed
(3718 days)
S35.1.48.4 x86_64Linux (RHEL 4U8)AnyMySQL Chooses unnecessarily to run subquery as dependent
773512015-06-15
1:23
2015-12-15
14:17
MySQL Server: DocumentationClosed
(3027 days)
S35.6LinuxAnyResult of "Optimizing Subqueries with EXISTS Strategy" is not same as document
1060062021-12-30
3:10
2022-01-11
14:44
MySQL Server: OptimizerClosed
(808 days)
S58.0.25, 8.0.27, 5.7.36Any (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)