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/43 #43: Join does not use indexes in case there is no cardinarity data http://bugs.mysql.com/bug.php?id=43 Submitted by: Peter Zaitsev
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Any (all)
Version: 3.23, 4.0
]]> Mon, 27 Jan 2003 18:54:59 +0000 Server: Optimizer http://bugs.mysql.com/7516 #7516: Wrong sort order when ORDER BY includes an ENUM column http://bugs.mysql.com/bug.php?id=7516 Submitted by: Andrei Nazarenko
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Linux (Linux (SuSE 8.2))
Version: 4.0.25 and 4.1.10a
]]> Thu, 23 Dec 2004 20:26:10 +0000 Server: Optimizer http://bugs.mysql.com/8168 #8168: HELP commands processing different from regular with --ps-protocol http://bugs.mysql.com/bug.php?id=8168 Submitted by: Sergey Petrunya
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.0-bk
]]> Thu, 27 Jan 2005 18:09:43 +0000 Server: Optimizer http://bugs.mysql.com/8772 #8772: Whan using MEMORY tables with HASH indexes can't insert multiply times in to me http://bugs.mysql.com/bug.php?id=8772 Submitted by: Serge Zabigaylo
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Linux (Linux)
Version: 5.0.2-alpha
]]> Thu, 24 Feb 2005 10:31:02 +0000 Server: Optimizer http://bugs.mysql.com/8927 #8927: prepared statement with multiple left joins of same table hangs http://bugs.mysql.com/bug.php?id=8927 Submitted by: Daniel Blumenthal
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Linux (Linux RH 8.0)
Version: 4.1.10
]]> Thu, 03 Mar 2005 16:36:24 +0000 Server: Optimizer http://bugs.mysql.com/9600 #9600: row() comparions works differently for IN and = http://bugs.mysql.com/bug.php?id=9600 Submitted by: Michael Widenius
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
Version: 5.1
]]> Mon, 04 Apr 2005 09:29:53 +0000 Server: Optimizer http://bugs.mysql.com/9930 #9930: EXPLAIN for SELECT on view http://bugs.mysql.com/bug.php?id=9930 Submitted by: Ulf Wendel
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Linux (Linux linux 2.6.8-24.14-smp #1 S)
Version: 5.0.3-beta-debug
]]> Fri, 15 Apr 2005 13:53:48 +0000 Server: Optimizer http://bugs.mysql.com/10021 #10021: group by fields must on a index ? http://bugs.mysql.com/bug.php?id=10021 Submitted by: yue gong
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Windows (win2000)
Version: 5.0.4/5.0.5 BK
]]> Wed, 20 Apr 2005 02:46:53 +0000 Server: Optimizer http://bugs.mysql.com/10243 #10243: -SUM() crash http://bugs.mysql.com/bug.php?id=10243 Submitted by: Ronald Weiss
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Windows (winXP)
Version: 5.0.4/BK source
]]> Thu, 28 Apr 2005 20:36:12 +0000 Server: Optimizer http://bugs.mysql.com/10312 #10312: subquery cant be optimized correctly http://bugs.mysql.com/bug.php?id=10312 Submitted by: Corin Langosch
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Linux (linux debian)
Version: 5.0.4
]]> Mon, 02 May 2005 11:51:52 +0000 Server: Optimizer http://bugs.mysql.com/10619 #10619: GROUP_CONCAT() crashes mysqld http://bugs.mysql.com/bug.php?id=10619 Submitted by: Torsten Kasch
Category: Server: Optimizer
Status: Can't repeat
Severity: 1
OS: Solaris (Solaris 9 (SPARC)/Windows)
Version: 4.1.11/4.1.12
]]> Fri, 13 May 2005 11:18:56 +0000 Server: Optimizer http://bugs.mysql.com/10822 #10822: Server hangs or crash with DELETE FROM table WHERE EXISTS(...) http://bugs.mysql.com/bug.php?id=10822 Submitted by: Manfred Wiedemeier
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Windows (win xp sp2/Linux)
Version: 4.1.12/4.1.14 BK
]]> Tue, 24 May 2005 11:32:23 +0000 Server: Optimizer http://bugs.mysql.com/10973 #10973: Having clause fails when using a unique column http://bugs.mysql.com/bug.php?id=10973 Submitted by: Peter Gulutzan
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Linux (SUSE 9.2)
Version: 5.0.7-beta-debug
]]> Mon, 30 May 2005 20:21:30 +0000 Server: Optimizer http://bugs.mysql.com/11112 #11112: Server crashes on UPDATE with EXISTS in WHERE clause http://bugs.mysql.com/bug.php?id=11112 Submitted by: Sergey Nikitin
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Any (any)
Version: 5.0.6
]]> Mon, 06 Jun 2005 12:29:20 +0000 Server: Optimizer http://bugs.mysql.com/11162 #11162: Execution of prepared "explain select" shows different output http://bugs.mysql.com/bug.php?id=11162 Submitted by: Joerg Bruehe
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: all Unix
Version: 5.0.7
]]> Wed, 08 Jun 2005 09:55:47 +0000 Server: Optimizer http://bugs.mysql.com/11521 #11521: Negative integer keys incorrectly substituted for 0 during range analysis. http://bugs.mysql.com/bug.php?id=11521 Submitted by: Timour Katchaounov
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Any (all)
Version: 4.1 and 5.x
]]> Thu, 23 Jun 2005 06:35:48 +0000 Server: Optimizer http://bugs.mysql.com/11689 #11689: success on Create view .. IF(col1 IS NULL,...), col2 ; but SELECT fails http://bugs.mysql.com/bug.php?id=11689 Submitted by: Matthias Leich
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
Version: 5.0
]]> Fri, 01 Jul 2005 13:58:01 +0000 Server: Optimizer http://bugs.mysql.com/11906 #11906: Using a variable instead of a constant gives incorrect results in a query join http://bugs.mysql.com/bug.php?id=11906 Submitted by: Are you mortal Then prepare to die.
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: 4.1.11-dec-osf5.1b-alphaev67
Version: 4.1.11-standard-log
]]> Wed, 13 Jul 2005 09:52:47 +0000 Server: Optimizer http://bugs.mysql.com/11933 #11933: NULL parameter IS NULL OR AND wrong evaluation http://bugs.mysql.com/bug.php?id=11933 Submitted by: Berto van de Kraats
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Linux (Linux)
Version: 5.0.10-beta
]]> Thu, 14 Jul 2005 11:02:13 +0000 Server: Optimizer http://bugs.mysql.com/12693 #12693: join test failure http://bugs.mysql.com/bug.php?id=12693 Submitted by: Jim Winstead
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Linux (Linux (x86_64))
Version: 5.0-bk
]]> Fri, 19 Aug 2005 22:59:47 +0000 Server: Optimizer http://bugs.mysql.com/12962 #12962: Type of column chages if the result is ordered or not http://bugs.mysql.com/bug.php?id=12962 Submitted by: x y
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Linux (Linux & Windows)
Version: 4.1.14
]]> Sat, 03 Sep 2005 06:22:50 +0000 Server: Optimizer http://bugs.mysql.com/13646 #13646: DISTINCT returns not all expected results http://bugs.mysql.com/bug.php?id=13646 Submitted by: x y
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Windows (Windows, Linux)
Version: 4.1.14
]]> Fri, 30 Sep 2005 10:28:24 +0000 Server: Optimizer http://bugs.mysql.com/14011 #14011: SELECT DISTINCT doesn't work properly in stored procedures http://bugs.mysql.com/bug.php?id=14011 Submitted by: Scott Hadfield
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Linux (RHEL AS release 3)
Version: 5.0.13-rc
]]> Thu, 13 Oct 2005 18:01:14 +0000 Server: Optimizer http://bugs.mysql.com/14059 #14059: Test case 'show_check' might fail randomly depending on optimizer path http://bugs.mysql.com/bug.php?id=14059 Submitted by: Kent Boortz
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
Version: 5.0.15
]]> Sun, 16 Oct 2005 20:07:37 +0000 Server: Optimizer http://bugs.mysql.com/14070 #14070: MySQL hangs on "Copying to tmp table" http://bugs.mysql.com/bug.php?id=14070 Submitted by: Frank Osterberg
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Linux (Linux)
Version: 5.0.16, 5.0.15, 4.1.14, 5.1
]]> Mon, 17 Oct 2005 11:03:11 +0000 Server: Optimizer http://bugs.mysql.com/15867 #15867: Union is causing at least one varchar column to be returned as binary http://bugs.mysql.com/bug.php?id=15867 Submitted by: Paul Rony
Category: Server: Optimizer
Status: Can't repeat
Severity: 1
OS: Linux (Linux, Windows 2003)
Version: 5.0.18-BK, 5.0.16
]]> Mon, 19 Dec 2005 20:31:01 +0000 Server: Optimizer http://bugs.mysql.com/16440 #16440: views are not dumped correclty with certain mysqldump options http://bugs.mysql.com/bug.php?id=16440 Submitted by: Wolfgang Fahl
Category: Server: Optimizer
Status: Can't repeat
Severity: 1
OS: Windows (Windows XP)
Version: 5.0.18 to 5.0.22
]]> Thu, 12 Jan 2006 09:17:54 +0000 Server: Optimizer http://bugs.mysql.com/17500 #17500: Format() + GROUP BY + PHP error http://bugs.mysql.com/bug.php?id=17500 Submitted by: Ian Lord
Category: Server: Optimizer
Status: Can't repeat
Severity: 3
OS: Linux (Linux, Freebsd 6.0)
Version: 5.0.19-BK, 5.0.18-LOG
]]> Fri, 17 Feb 2006 02:28:08 +0000 Server: Optimizer http://bugs.mysql.com/17590 #17590: Different key-len and # rows reported on all platforms http://bugs.mysql.com/bug.php?id=17590 Submitted by: Joerg Bruehe
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Any (All)
Version: 5.1.7-beta
]]> Mon, 20 Feb 2006 17:44:24 +0000 Server: Optimizer http://bugs.mysql.com/17816 #17816: SELECT and CREATE TEMP TABLE results differ http://bugs.mysql.com/bug.php?id=17816 Submitted by: Stewart Smith
Category: Server: Optimizer
Status: Can't repeat
Severity: 2
OS: Linux (Linux)
Version: 5.0.11, 5.0.18
]]> Wed, 01 Mar 2006 05:52:15 +0000 Server: Optimizer