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/8652 #8652: group by part of rand() returns duplicate key error http://bugs.mysql.com/bug.php?id=8652 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 4.1.10
]]> Mon, 21 Feb 2005 16:28:32 +0000 Server: Optimizer http://bugs.mysql.com/8810 #8810: user variables' behaviour depends on using DISTINCT http://bugs.mysql.com/bug.php?id=8810 Submitted by: Przemyslaw Popielarski
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Linux (Linux kernel 2.4.26)
Version: 4.1.10
]]> Fri, 25 Feb 2005 16:15:22 +0000 Server: Optimizer http://bugs.mysql.com/8821 #8821: join to subquery without distinct causes bad COUNT http://bugs.mysql.com/bug.php?id=8821 Submitted by: Are you mortal Then prepare to die.
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: alphaev67
Version: Ver 14.7 Distrib 4.1.9, for dec-osf5.1b
]]> Sat, 26 Feb 2005 12:00:54 +0000 Server: Optimizer http://bugs.mysql.com/9228 #9228: optimizer on alternating function with no ref to columns http://bugs.mysql.com/bug.php?id=9228 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any (*)
Version: 4.1.10
]]> Wed, 16 Mar 2005 18:37:46 +0000 Server: Optimizer http://bugs.mysql.com/9451 #9451: Selecting rows with null primary key does not always return the empty set http://bugs.mysql.com/bug.php?id=9451 Submitted by: David Clements
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Windows (Windows XP)
Version: 4.1.10-nt-log
]]> Tue, 29 Mar 2005 12:58:37 +0000 Server: Optimizer http://bugs.mysql.com/9689 #9689: wrong result for subselect in on duplicate key update (query cache) http://bugs.mysql.com/bug.php?id=9689 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any (*)
Version: 4.1.11
]]> Wed, 06 Apr 2005 17:37:37 +0000 Server: Optimizer http://bugs.mysql.com/9693 #9693: bug in trying to join a value on a range (using indexes) http://bugs.mysql.com/bug.php?id=9693 Submitted by: mysql prutser
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Linux (linux)
Version: 3.23.41, 4.0.24, 4.1
]]> Wed, 06 Apr 2005 19:29:09 +0000 Server: Optimizer http://bugs.mysql.com/10266 #10266: Order of multiple left joins matters? http://bugs.mysql.com/bug.php?id=10266 Submitted by: Ronnie Paskin
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Windows (Windows 2000)
Version: 4.1
]]> Fri, 29 Apr 2005 15:47:46 +0000 Server: Optimizer http://bugs.mysql.com/10512 #10512: Optimizer selecting wrong index with composite indexes http://bugs.mysql.com/bug.php?id=10512 Submitted by: Dean Ellis
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
Version: 4.0.25 forward
]]> Tue, 10 May 2005 14:21:56 +0000 Server: Optimizer http://bugs.mysql.com/10557 #10557: Too few results when "Using index for group-by" http://bugs.mysql.com/bug.php?id=10557 Submitted by: Ulf Wendel
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Linux (linux 2.6.8-24.14 smp)
Version: 5.0.4-beta-debug
]]> Wed, 11 May 2005 14:44:03 +0000 Server: Optimizer http://bugs.mysql.com/10792 #10792: unexpected result of IF declaredVar IS NULL http://bugs.mysql.com/bug.php?id=10792 Submitted by: Mark Johnson
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Linux (linux)
Version: 5.0.4-beta-standard-log
]]> Sun, 22 May 2005 23:02:52 +0000 Server: Optimizer http://bugs.mysql.com/11071 #11071: SELECT crashes MySQL server http://bugs.mysql.com/bug.php?id=11071 Submitted by: Victoria Reznichenko
Category: Server: Optimizer
Status: Not a Bug
Severity: 1
OS: Linux (linux)
Version: 4.1 bk tree
]]> Fri, 03 Jun 2005 12:59:54 +0000 Server: Optimizer http://bugs.mysql.com/11303 #11303: sql bug http://bugs.mysql.com/bug.php?id=11303 Submitted by: liang zhao
Category: Server: Optimizer
Status: Not a Bug
Severity: 1
OS: Windows (windows)
Version: 4.1
]]> Tue, 14 Jun 2005 01:40:01 +0000 Server: Optimizer http://bugs.mysql.com/11346 #11346: slow query due to datatype cast? http://bugs.mysql.com/bug.php?id=11346 Submitted by: Pascal Sonon
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Linux (Linux Fedora Core 2)
Version: 4.1.12
]]> Wed, 15 Jun 2005 09:48:05 +0000 Server: Optimizer http://bugs.mysql.com/11713 #11713: OUTER JOIN incorrectly converted to INNER for complex WHERE clause http://bugs.mysql.com/bug.php?id=11713 Submitted by: Sergey Petrunya
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
Version: 4.1-bk
]]> Sun, 03 Jul 2005 20:36:35 +0000 Server: Optimizer http://bugs.mysql.com/11716 #11716: Extremely poor performance when joining tables and views http://bugs.mysql.com/bug.php?id=11716 Submitted by:
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Linux (Linux (FC 4))
Version: 5.0.7 beta max
]]> Mon, 04 Jul 2005 02:48:03 +0000 Server: Optimizer http://bugs.mysql.com/11936 #11936: Lock table failing create table ....select http://bugs.mysql.com/bug.php?id=11936 Submitted by: Disha
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Any (any)
Version: 5.0.7-beta-nt/5.0.10 BK
]]> Thu, 14 Jul 2005 12:46:07 +0000 Server: Optimizer http://bugs.mysql.com/12106 #12106: EXPLAIN shows incorrect select_type for subquery http://bugs.mysql.com/bug.php?id=12106 Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Windows (XP)
Version: 4.1.12a-nt, 5.0.9-beta-nt
]]> Fri, 22 Jul 2005 08:40:47 +0000 Server: Optimizer http://bugs.mysql.com/12605 #12605: JOIN with ON condition gets now error response http://bugs.mysql.com/bug.php?id=12605 Submitted by: Matthias Leich
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
Version: 5.0
]]> Tue, 16 Aug 2005 16:50:51 +0000 Server: Optimizer http://bugs.mysql.com/12617 #12617: CREATE TABLE ... SELECT does not respect column order http://bugs.mysql.com/bug.php?id=12617 Submitted by: Carsten Pedersen
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Any (all)
Version: 5.0.11
]]> Wed, 17 Aug 2005 08:19:17 +0000 Server: Optimizer http://bugs.mysql.com/12747 #12747: Multiple JOINs fail with 5.0.12 (column not found) http://bugs.mysql.com/bug.php?id=12747 Submitted by: Martin Karch
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Linux (Linux)
Version: 5.0.12 (all)
]]> Tue, 23 Aug 2005 06:03:32 +0000 Server: Optimizer http://bugs.mysql.com/12816 #12816: JOIN with USING clause doesn't return expected result http://bugs.mysql.com/bug.php?id=12816 Submitted by: Shuichi Tamagawa
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Linux (Linux)
Version: 5.0.13-bk
]]> Thu, 25 Aug 2005 23:58:56 +0000 Server: Optimizer http://bugs.mysql.com/12934 #12934: Select without `where` does not show row that same select with `where` returns http://bugs.mysql.com/bug.php?id=12934 Submitted by: Oleg Marchuk
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Linux (Linux, Windows)
Version: 4.1.11-standard, 4.1.14-nt
]]> Thu, 01 Sep 2005 17:42:24 +0000 Server: Optimizer http://bugs.mysql.com/12971 #12971: Inconsistent data in a view http://bugs.mysql.com/bug.php?id=12971 Submitted by: Jakub Velkoborsky
Category: Server: Optimizer
Status: Not a Bug
Severity: 2
OS: Linux (Linux, Windows)
Version: 5.0.12-beta
]]> Sat, 03 Sep 2005 20:10:17 +0000 Server: Optimizer http://bugs.mysql.com/13569 #13569: User friendly http://bugs.mysql.com/bug.php?id=13569 Submitted by: Roberto Spadim
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any (all)
Version: all
]]> Wed, 28 Sep 2005 14:09:13 +0000 Server: Optimizer http://bugs.mysql.com/13874 #13874: Incorrect subquery handling in "exists" http://bugs.mysql.com/bug.php?id=13874 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Linux (Linux, Windows, FreeBSD)
Version: 4.1.14, 5.0.13, 5.0.15-BK
]]> Sun, 09 Oct 2005 16:23:20 +0000 Server: Optimizer http://bugs.mysql.com/14006 #14006: GROUP BY doesn't work http://bugs.mysql.com/bug.php?id=14006 Submitted by: Alexey Botchkov
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Linux (Linux)
Version: 5.0
]]> Thu, 13 Oct 2005 14:46:05 +0000 Server: Optimizer http://bugs.mysql.com/14100 #14100: STRAIGHT_JOIN hint causes a eq_ref to become ref and fail to see 0/1 rowmatches http://bugs.mysql.com/bug.php?id=14100 Submitted by: Tobias Asplund
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Windows (Windows/FreeBSD)
Version: 5.0.13-rc/4.1.XX
]]> Tue, 18 Oct 2005 00:54:36 +0000 Server: Optimizer http://bugs.mysql.com/14220 #14220: Optimizer does not use index when using numeric lookup on varchar field (MyISAM) http://bugs.mysql.com/bug.php?id=14220 Submitted by: Gleb Paharenko
Category: Server: Optimizer
Status: Not a Bug
Severity: 3
OS: Any
Version: 4.0, 4.1, 5.0, 5.1
]]> Fri, 21 Oct 2005 21:00:15 +0000 Server: Optimizer http://bugs.mysql.com/14237 #14237: Distinct breaks order of results with enum fields http://bugs.mysql.com/bug.php?id=14237 Submitted by: Peter Volk
Category: Server: Optimizer
Status: Not a Bug
Severity: 1
OS: Any (ALL)
Version: ALL
]]> Sun, 23 Oct 2005 12:55:35 +0000 Server: Optimizer