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/1560 #1560: EXPLAIN shows wrong access type for the table http://bugs.mysql.com/bug.php?id=1560 Submitted by: Konstantin Osipov
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any (all)
Version: 5.1
]]> Wed, 15 Oct 2003 06:56:47 +0000 Server: Optimizer http://bugs.mysql.com/4981 #4981: 4.x and 5.x produce non-optimal execution path, 3.23 regression test failure http://bugs.mysql.com/bug.php?id=4981 Submitted by: Matthew Lord
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any (all)
Version: 4.x/5.x
]]> Tue, 10 Aug 2004 19:28:08 +0000 Server: Optimizer http://bugs.mysql.com/5500 #5500: EXPLAIN for a view differs from EXPLAIN for a base table http://bugs.mysql.com/bug.php?id=5500 Submitted by: Peter Gulutzan
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Linux (SuSE 8.2)
Version: 5.0.2-alpha
]]> Fri, 10 Sep 2004 02:00:33 +0000 Server: Optimizer http://bugs.mysql.com/6558 #6558: Views: CREATE VIEW fails with JOIN ... USING http://bugs.mysql.com/bug.php?id=6558 Submitted by: Trudy Pelzer
Category: Server: Optimizer
Status: Closed
Severity: 3
Version: 5.0.0-alpha-max-debug
]]> Wed, 10 Nov 2004 17:59:26 +0000 Server: Optimizer http://bugs.mysql.com/7549 #7549: Missing error message for invalid view selection with subquery http://bugs.mysql.com/bug.php?id=7549 Submitted by: Peter Gulutzan
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Linux (SUSE 9.2)
Version: 5.0.3-alpha-debug
]]> Mon, 27 Dec 2004 21:28:49 +0000 Server: Optimizer http://bugs.mysql.com/8441 #8441: ROR code has key len 4, should be 5 http://bugs.mysql.com/bug.php?id=8441 Submitted by: Fantin Vincent
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: NT, Linux/x86
Version: 5.0.7
]]> Fri, 11 Feb 2005 15:28:07 +0000 Server: Optimizer http://bugs.mysql.com/8532 #8532: SELECT DISTINCT a, a causes server to crash http://bugs.mysql.com/bug.php?id=8532 Submitted by:
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Linux (Linux)
Version: MySQL-server-5.0.3 built on Feb 14
]]> Wed, 16 Feb 2005 05:16:23 +0000 Server: Optimizer http://bugs.mysql.com/8614 #8614: distinct sometimes ignored with group by "CONST" http://bugs.mysql.com/bug.php?id=8614 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any (*)
Version: 4.1.10
]]> Sat, 19 Feb 2005 00:53:02 +0000 Server: Optimizer http://bugs.mysql.com/8658 #8658: UNION, IF control flow function, truncated line http://bugs.mysql.com/bug.php?id=8658 Submitted by: Matthias Leich
Category: Server: Optimizer
Status: Closed
Severity: 2
Version: 5.0
]]> Mon, 21 Feb 2005 19:20:07 +0000 Server: Optimizer http://bugs.mysql.com/8669 #8669: AES_DECRYPT fails on null values http://bugs.mysql.com/bug.php?id=8669 Submitted by: Ralf Hauser
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any (*)
Version: mysqld Ver 4.0.21-log for pc-linux-gnu
]]> Tue, 22 Feb 2005 05:56:10 +0000 Server: Optimizer http://bugs.mysql.com/8711 #8711: <=> fails in WHERE clause, works in HAVING http://bugs.mysql.com/bug.php?id=8711 Submitted by: Rene Churchill
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: MacOS (Mac OSX 10.3.6)
Version: 4.0.21
]]> Tue, 22 Feb 2005 21:19:03 +0000 Server: Optimizer http://bugs.mysql.com/8726 #8726: dissappering query, hanging mysql client,other oddities with MAX_JOIN_SIZE http://bugs.mysql.com/bug.php?id=8726 Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any (*)
Version: 4.1.10
]]> Wed, 23 Feb 2005 12:19:17 +0000 Server: Optimizer http://bugs.mysql.com/8804 #8804: wrong result for [null_expr] IN (SELECT ...) http://bugs.mysql.com/bug.php?id=8804 Submitted by: Sven Hagemann
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Linux (Linux)
Version: Server version: 4.1.9-Max/4.1.15 BK source
]]> Fri, 25 Feb 2005 10:47:34 +0000 Server: Optimizer http://bugs.mysql.com/8877 #8877: simple 'ref'-type join reads through all NULL values when looking for = http://bugs.mysql.com/bug.php?id=8877 Submitted by: Timothy Smith
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any (any)
Version: any
]]> Wed, 02 Mar 2005 00:26:16 +0000 Server: Optimizer http://bugs.mysql.com/8893 #8893: Using "SELECT MAX(ID)" with Multiple-Column Indexes http://bugs.mysql.com/bug.php?id=8893 Submitted by: Ralph Runge
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any (all)
Version: 4.1.10
]]> Wed, 02 Mar 2005 14:51:28 +0000 Server: Optimizer http://bugs.mysql.com/9017 #9017: Rows are omitted from result set when using JOIN, XOR and ISNULL http://bugs.mysql.com/bug.php?id=9017 Submitted by: Petr Tomenendal
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Windows (WinXP SP2, Linux 2.4.22)
Version: 4.1.10
]]> Mon, 07 Mar 2005 11:02:38 +0000 Server: Optimizer http://bugs.mysql.com/9021 #9021: Query with subquery does not use index in outer query http://bugs.mysql.com/bug.php?id=9021 Submitted by: Pete French
Category: Server: Optimizer
Status: Closed
Severity: 1
OS: FreeBSD (FreeBSD)
Version: 4.1.7, 5.6.4
]]> Mon, 07 Mar 2005 13:23:38 +0000 Server: Optimizer http://bugs.mysql.com/9067 #9067: USING cannot match columns on second JOIN http://bugs.mysql.com/bug.php?id=9067 Submitted by: Emanuele Dolis
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Windows (Windows XP SP2)
Version: 4.1.9
]]> Wed, 09 Mar 2005 07:31:16 +0000 Server: Optimizer http://bugs.mysql.com/9090 #9090: Optimization Problem with a subquery in an IN Operation http://bugs.mysql.com/bug.php?id=9090 Submitted by: Andre Justus
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Any
Version: 4.1.x, 5.x
]]> Thu, 10 Mar 2005 10:30:34 +0000 Server: Optimizer http://bugs.mysql.com/9103 #9103: Erroneous data truncation warnings on multi-table updates http://bugs.mysql.com/bug.php?id=9103 Submitted by: Dean Ellis
Category: Server: Optimizer
Status: Closed
Severity: 2
Version: 4.1.11
]]> Thu, 10 Mar 2005 20:00:09 +0000 Server: Optimizer http://bugs.mysql.com/9210 #9210: Server crash with a simple query with GROUP BY http://bugs.mysql.com/bug.php?id=9210 Submitted by: Konstantin Osipov
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Linux (SuSE Linux 9.1)
Version: 5.0
]]> Tue, 15 Mar 2005 22:14:22 +0000 Server: Optimizer http://bugs.mysql.com/9213 #9213: GROUP BY query on utf-8 key returns wrong results (empty set) http://bugs.mysql.com/bug.php?id=9213 Submitted by: Timothy Smith
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any (any)
Version: 4.1.11
]]> Wed, 16 Mar 2005 02:34:29 +0000 Server: Optimizer http://bugs.mysql.com/9298 #9298: Wrong handling of int4 unsigned columns in GROUP functions http://bugs.mysql.com/bug.php?id=9298 Submitted by: Nicolas Moldavsky
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Linux (RHEL 3)
Version: 4.1.10a
]]> Sat, 19 Mar 2005 18:24:09 +0000 Server: Optimizer http://bugs.mysql.com/9338 #9338: left join wrong result http://bugs.mysql.com/bug.php?id=9338 Submitted by: Berto van de Kraats
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Windows (windows and linux)
Version: 5.0.2 (also 5.0.3)
]]> Tue, 22 Mar 2005 14:14:42 +0000 Server: Optimizer http://bugs.mysql.com/9360 #9360: MAX and UNION on NOT NULL column returns error http://bugs.mysql.com/bug.php?id=9360 Submitted by: Alexandre Avrane
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Linux (Linux)
Version: 4.1
]]> Wed, 23 Mar 2005 14:20:53 +0000 Server: Optimizer http://bugs.mysql.com/9439 #9439: Reporting wrong datatype for sub_part on show index. http://bugs.mysql.com/bug.php?id=9439 Submitted by: Henrik Johnson
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Windows (Windows & Linux)
Version: 4.1.7
]]> Tue, 29 Mar 2005 00:54:57 +0000 Server: Optimizer http://bugs.mysql.com/9501 #9501: Arbitrary precision math done incorretly (numeric math in fp maybe?) http://bugs.mysql.com/bug.php?id=9501 Submitted by: Scott Marlowe
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Linux (Fedora Core 2)
Version: 5.0.3
]]> Wed, 30 Mar 2005 22:08:53 +0000 Server: Optimizer http://bugs.mysql.com/9516 #9516: left join exists is null http://bugs.mysql.com/bug.php?id=9516 Submitted by: Berto van de Kraats
Category: Server: Optimizer
Status: Closed
Severity: 3
OS: Windows (windows and linux)
Version: 5.0.3-beta-nt
]]> Thu, 31 Mar 2005 09:08:09 +0000 Server: Optimizer http://bugs.mysql.com/9577 #9577: UNION ALL with + INTERVAL N DAY crashes server http://bugs.mysql.com/bug.php?id=9577 Submitted by: Rob LoPresti
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Any (any)
Version: 5.0.3
]]> Sat, 02 Apr 2005 05:22:33 +0000 Server: Optimizer http://bugs.mysql.com/9593 #9593: The combination of COUNT, DISTINCT and CONCAT seems to lock the server http://bugs.mysql.com/bug.php?id=9593 Submitted by: Tim Graves
Category: Server: Optimizer
Status: Closed
Severity: 2
OS: Windows (Windows XP)
Version: 5.0.3/5.0.4 BK
]]> Sun, 03 Apr 2005 16:15:27 +0000 Server: Optimizer