MySQL Bugs MySQL AB Bugs Database http://bugs.mysql.com/ MySQL Bugs http://bugs.mysql.com/images/mysql_100x52-64.gif http://bugs.mysql.com/ http://bugs.mysql.com/19195 #19195: Optimizer does not use proper index for join http://bugs.mysql.com/bug.php?id=19195 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.27-BK, 5.0.21-BK, 5.0.19
]]> Wed, 19 Apr 2006 12:09:46 +0000 Server: Optimizer http://bugs.mysql.com/25571 #25571: EXPLAIN returns incorrect estimation of rows for federated table http://bugs.mysql.com/bug.php?id=25571 Submitted by: Valeriy Kravchuk
Category: Server: Federated
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.34-BK, 5.0.27
]]> Fri, 12 Jan 2007 07:27:04 +0000 Server: Federated http://bugs.mysql.com/25572 #25572: SHOW INDEX does not report cardinality (always NULL) for FEDERATED table http://bugs.mysql.com/bug.php?id=25572 Submitted by: Valeriy Kravchuk
Category: Server: Federated
Status: Verified
Severity: 2
OS: Linux (Linux)
Version: 5.0.34-BK, 5.0.27
]]> Fri, 12 Jan 2007 10:04:59 +0000 Server: Federated http://bugs.mysql.com/28404 #28404: Optimizer does not consider index that can be used for ORDER BY http://bugs.mysql.com/bug.php?id=28404 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux
Version: 4.0.31, 4.1.25, 4.1.26, 5.0.42-BK, 5.0.46, 5.1.33
]]> Sun, 13 May 2007 18:33:11 +0000 Server: Optimizer http://bugs.mysql.com/28554 #28554: Optimizer wrongly prefers index for (col = value) over (PK <= value) http://bugs.mysql.com/bug.php?id=28554 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 4.1.22, 5.0.42-BK
]]> Mon, 21 May 2007 09:32:16 +0000 Server: Optimizer http://bugs.mysql.com/59187 #59187: Wrong result with NULL NOT IN subquery http://bugs.mysql.com/bug.php?id=59187 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1.55, 5.6.2-m5
]]> Mon, 27 Dec 2010 15:31:49 +0000 Server: Optimizer http://bugs.mysql.com/61551 #61551: Loose index scan is not used for select COUNT(distinct a) http://bugs.mysql.com/bug.php?id=61551 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.56
]]> Fri, 17 Jun 2011 12:26:11 +0000 Server: Optimizer http://bugs.mysql.com/64036 #64036: Use non-materializing loose-scan-merge for certain subqueries in FROM with LIMIT http://bugs.mysql.com/bug.php?id=64036 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
]]> Sun, 15 Jan 2012 15:51:19 +0000 Server: Optimizer http://bugs.mysql.com/70164 #70164: Misleading comment for the recv_parse_or_apply_log_rec_body() function http://bugs.mysql.com/bug.php?id=70164 Submitted by: Valeriy Kravchuk
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any
Version: 5.1, 5.5, 5.6
]]> Tue, 27 Aug 2013 13:57:46 +0000 Server: InnoDB http://bugs.mysql.com/70555 #70555: EXPLAIN for INSERT ... SELECT waits for table lock http://bugs.mysql.com/bug.php?id=70555 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6.14
]]> Tue, 08 Oct 2013 17:29:55 +0000 Server: Optimizer http://bugs.mysql.com/70629 #70629: InnoDB updated rec_per_key[] statis not published to the optimizer enough often http://bugs.mysql.com/bug.php?id=70629 Submitted by: Valeriy Kravchuk
Category: Server: InnoDB
Status: Verified
Severity: 2
OS: Any
Version: 5.6.14
]]> Wed, 16 Oct 2013 08:27:45 +0000 Server: InnoDB http://bugs.mysql.com/70630 #70630: Why one can access persistent statistics data while they are changing? http://bugs.mysql.com/bug.php?id=70630 Submitted by: Valeriy Kravchuk
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any
Version: 5.6.14
]]> Wed, 16 Oct 2013 08:46:19 +0000 Server: InnoDB http://bugs.mysql.com/70684 #70684: HAVING referring to subquery results in WARNING 1292 http://bugs.mysql.com/bug.php?id=70684 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.5.33, 5.6.14
]]> Tue, 22 Oct 2013 08:13:59 +0000 Server: Optimizer http://bugs.mysql.com/71091 #71091: CSV engine does not properly process "", in quotes http://bugs.mysql.com/bug.php?id=71091 Submitted by: Valeriy Kravchuk
Category: Server: CSV
Status: Verified
Severity: 3
OS: Any
Version: 5.5.33, any, 5.6.15, 5.5.35
]]> Thu, 05 Dec 2013 12:52:38 +0000 Server: CSV http://bugs.mysql.com/71140 #71140: Optimizer does NOT use range checks in typical self-join for InnoDB tables http://bugs.mysql.com/bug.php?id=71140 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1, 5.5, 5.6.15, 5.7.7
]]> Fri, 13 Dec 2013 09:16:24 +0000 Server: Optimizer http://bugs.mysql.com/71146 #71146: Manual does not explain when REPAIR or OPTIMIZE TABLE uses repair by sorting http://bugs.mysql.com/bug.php?id=71146 Submitted by: Valeriy Kravchuk
Category: Server: Docs
Status: Verified
Severity: 3
OS: Any
Version: any
]]> Sat, 14 Dec 2013 11:34:16 +0000 Server: Docs http://bugs.mysql.com/71189 #71189: Manual does not provide enough details on how loose index scan really works http://bugs.mysql.com/bug.php?id=71189 Submitted by: Valeriy Kravchuk
Category: Server: Docs
Status: Verified
Severity: 3
OS: Any
Version: 5.5, any
]]> Fri, 20 Dec 2013 14:56:53 +0000 Server: Docs http://bugs.mysql.com/71191 #71191: Loose index scan is used even though full table scan/tight index scan is faster http://bugs.mysql.com/bug.php?id=71191 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.5.33
]]> Fri, 20 Dec 2013 15:30:25 +0000 Server: Optimizer http://bugs.mysql.com/71199 #71199: Optimizer's estimated number of rows is 2 times wrong for (loose?) index scans http://bugs.mysql.com/bug.php?id=71199 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.6.14, 5.6.15, 5.5.35
]]> Sat, 21 Dec 2013 18:16:34 +0000 Server: Optimizer http://bugs.mysql.com/71204 #71204: Timing for stages in P_S is different from what SHOW PROFILE reports http://bugs.mysql.com/bug.php?id=71204 Submitted by: Valeriy Kravchuk
Category: Server: Performance Schema
Status: Verified
Severity: 3
OS: Any
Version: 5.6.14, 5.6.16
]]> Sun, 22 Dec 2013 15:42:09 +0000 Server: Performance Schema http://bugs.mysql.com/71232 #71232: Wrong behaviour for auto_increment unsigned bigint column approaching max value http://bugs.mysql.com/bug.php?id=71232 Submitted by: Valeriy Kravchuk
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any
Version: 5.6.15
]]> Thu, 26 Dec 2013 11:34:57 +0000 Server: InnoDB http://bugs.mysql.com/71279 #71279: Misleading error message for ANALYZE against PERFORMANCE_SCHEMA tables http://bugs.mysql.com/bug.php?id=71279 Submitted by: Valeriy Kravchuk
Category: Server: Privileges
Status: Verified
Severity: 3
OS: Any
Version: 5.6
]]> Thu, 02 Jan 2014 17:29:28 +0000 Server: Privileges http://bugs.mysql.com/71280 #71280: Misleading error message for ANALYZE against INFORMATION_SCHEMA tables http://bugs.mysql.com/bug.php?id=71280 Submitted by: Valeriy Kravchuk
Category: Server: I_S
Status: Verified
Severity: 3
OS: Any
Version: 5.6.14, 5.6.15, 5.6.16
]]> Thu, 02 Jan 2014 18:21:01 +0000 Server: I_S http://bugs.mysql.com/71293 #71293: Manual page for P_S.FILE_INSTANCES table does not explain EVENT_NAME values http://bugs.mysql.com/bug.php?id=71293 Submitted by: Valeriy Kravchuk
Category: Server: Performance Schema
Status: Verified
Severity: 3
OS: Any
Version: 5.6
]]> Sat, 04 Jan 2014 18:35:27 +0000 Server: Performance Schema http://bugs.mysql.com/71294 #71294: Manual page for P_S.FILE_INSTANCES table does not explain '~' in FILE_NAME http://bugs.mysql.com/bug.php?id=71294 Submitted by: Valeriy Kravchuk
Category: Server: General
Status: Verified
Severity: 3
OS: Any
Version: 5.6
]]> Sat, 04 Jan 2014 19:24:56 +0000 Server: General http://bugs.mysql.com/71312 #71312: Weird warning for MERGE table while accessing I_S.REFERENTIAL_CONSTRAINTS http://bugs.mysql.com/bug.php?id=71312 Submitted by: Valeriy Kravchuk
Category: Server: I_S
Status: Verified
Severity: 3
OS: Any
Version: 5.6.15
]]> Tue, 07 Jan 2014 13:21:27 +0000 Server: I_S http://bugs.mysql.com/71355 #71355: Strange data type is used for name-related columns in some I_S.INNODB_* tables http://bugs.mysql.com/bug.php?id=71355 Submitted by: Valeriy Kravchuk
Category: Server: I_S
Status: Verified
Severity: 3
OS: Any
Version: 5.6
]]> Sun, 12 Jan 2014 17:22:29 +0000 Server: I_S http://bugs.mysql.com/71477 #71477: transaction_allow_batching is available in non-Cluster MySQL Server 5.6 http://bugs.mysql.com/bug.php?id=71477 Submitted by: Valeriy Kravchuk
Category: Server: Options
Status: Verified
Severity: 3
OS: Any
Version: 5.6.15
]]> Sat, 25 Jan 2014 12:10:37 +0000 Server: Options http://bugs.mysql.com/71479 #71479: sort_buffer_size is limited to 4GB-1 on 64-bit Windows http://bugs.mysql.com/bug.php?id=71479 Submitted by: Valeriy Kravchuk
Category: Server: Options
Status: Verified
Severity: 3
OS: Windows (Win64)
Version: 5.6
]]> Sat, 25 Jan 2014 15:32:08 +0000 Server: Options http://bugs.mysql.com/71513 #71513: mysqld --help --verbose doesn't produce error for wrong innodb_flush_method http://bugs.mysql.com/bug.php?id=71513 Submitted by: Valeriy Kravchuk
Category: Server: Errors
Status: Verified
Severity: 3
OS: Any
Version: 5.6.15, 5.5.35
]]> Wed, 29 Jan 2014 16:08:06 +0000 Server: Errors