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/6980 #6980: Error 1093 - You can't specify target table for update in FROM http://bugs.mysql.com/bug.php?id=6980 Submitted by: Sanvido Federico
Category: Server: DML
Status: Verified
Severity: 2
OS: Windows (Windows 2000)
Version: 4.1.7
]]> Fri, 03 Dec 2004 10:20:16 +0000 Server: DML http://bugs.mysql.com/7742 #7742: You can't reinvoke the same Temporary Table more than once. http://bugs.mysql.com/bug.php?id=7742 Submitted by: Carlos Uldérico Cirello Filho
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (Linux Red Hat 9)
Version: 4.1 +
]]> Sat, 08 Jan 2005 11:06:34 +0000 Server: DML http://bugs.mysql.com/8463 #8463: SQRT: Should return an error when argument is negative http://bugs.mysql.com/bug.php?id=8463 Submitted by: Trudy Pelzer
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (SuSE 9.1)
Version: 5.0.3-alpha-debug
]]> Fri, 11 Feb 2005 23:30:14 +0000 Server: DML http://bugs.mysql.com/10573 #10573: BOM(of UTF-8) is not correctly handled by LOAD DATA http://bugs.mysql.com/bug.php?id=10573 Submitted by: Hartmut Holzgraefe
Category: Server: DML
Status: Verified
Severity: 2
OS: Linux (Linux)
Version: 4.1.11/5.6
]]> Thu, 12 May 2005 08:08:24 +0000 Server: DML http://bugs.mysql.com/18913 #18913: Physical order of rows in table alters update behavior of unique index http://bugs.mysql.com/bug.php?id=18913 Submitted by: John Miller
Category: Server: DML
Status: Verified
Severity: 2
OS: Any
Version: 5.0.21-BK, 5.0.19,5.7.4
]]> Sun, 09 Apr 2006 02:01:51 +0000 Server: DML http://bugs.mysql.com/21326 #21326: Can SELECT from table being updated in a stored function, but can't in subquery http://bugs.mysql.com/bug.php?id=21326 Submitted by: Tomash Brechko
Category: Server: DML
Status: Verified
Severity: 3
OS: Any (any)
Version: 5.0.25-BK, 5.0.22/5.1BK
]]> Fri, 28 Jul 2006 09:26:55 +0000 Server: DML http://bugs.mysql.com/21431 #21431: Incomplete support of temporary tables http://bugs.mysql.com/bug.php?id=21431 Submitted by: Tomash Brechko
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 4.1.22-BK, 5.0-BK
]]> Thu, 03 Aug 2006 16:17:38 +0000 Server: DML http://bugs.mysql.com/22106 #22106: can't output to error log file when INNODB happened ERROR1205 http://bugs.mysql.com/bug.php?id=22106 Submitted by: Kanako Nakai
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.26-BK
]]> Fri, 08 Sep 2006 06:46:19 +0000 Server: DML http://bugs.mysql.com/27299 #27299: Multi-table UPDATE does not work properly (IMHO) http://bugs.mysql.com/bug.php?id=27299 Submitted by: James Goatcher
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (Linux 2.6.9-34.ELsmp)
Version: 5.0.40-BK, 5.0.19
]]> Tue, 20 Mar 2007 18:20:11 +0000 Server: DML http://bugs.mysql.com/29757 #29757: STRING FUNCTIONS WITH LIMITS http://bugs.mysql.com/bug.php?id=29757 Submitted by: Roberto Spadim
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.5
]]> Thu, 12 Jul 2007 13:56:46 +0000 Server: DML http://bugs.mysql.com/30159 #30159: Different results with SELECT FOR UPDATE versus plain SELECT http://bugs.mysql.com/bug.php?id=30159 Submitted by: Peter Gulutzan
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (SUSE 10 64-bit)
Version: 5.1.21-beta-debug
]]> Tue, 31 Jul 2007 21:46:16 +0000 Server: DML http://bugs.mysql.com/30402 #30402: SELECT count(distinct) from mytable return 0 http://bugs.mysql.com/bug.php?id=30402 Submitted by: Bordas David
Category: Server: DML
Status: Verified
Severity: 2
OS: Linux (RedHat 9.0)
Version: 5.0.37 Community
]]> Tue, 14 Aug 2007 08:35:13 +0000 Server: DML http://bugs.mysql.com/30454 #30454: 'default_week_format' has no effect on YEARWEEK() as it has on WEEK() http://bugs.mysql.com/bug.php?id=30454 Submitted by: Marcel Brouillet
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (Gentoo kernel 2.6.18-gentoo-r6-nopatch-xxxx-ipv4-32)
Version: 5.0.26-log/5.1
]]> Thu, 16 Aug 2007 13:49:26 +0000 Server: DML http://bugs.mysql.com/31732 #31732: row count(*) overflows after 32-bit integer precision in spite of being bigint http://bugs.mysql.com/bug.php?id=31732 Submitted by: Cengiz Gunay
Category: Server: DML
Status: Verified
Severity: 2
OS: Linux (SuSE 10.3 x86_64)
Version: 5.0.45
]]> Sun, 21 Oct 2007 01:14:00 +0000 Server: DML http://bugs.mysql.com/31776 #31776: CAST AS CHAR with SELECT DISTINCT http://bugs.mysql.com/bug.php?id=31776 Submitted by: david beau
Category: Server: DML
Status: Verified
Severity: 3
OS: Any (Linux, Microsoft Windows XP SP2)
Version: 5.0.45, 4.1, 5.0, 5.1, 5.2 BK
]]> Tue, 23 Oct 2007 08:19:15 +0000 Server: DML http://bugs.mysql.com/33169 #33169: mysqld --help : lowercase_table-name bad advice http://bugs.mysql.com/bug.php?id=33169 Submitted by: Carsten Pedersen
Category: Server: DML
Status: Verified
Severity: 3
OS: Windows
Version: 5.1.22
]]> Wed, 12 Dec 2007 15:40:11 +0000 Server: DML http://bugs.mysql.com/35002 #35002: Wrong results returned when using derived table and group by http://bugs.mysql.com/bug.php?id=35002 Submitted by: Laurent Monnoye
Category: Server: DML
Status: Verified
Severity: 2
OS: Linux (2.6.22.9-61.fc6)
Version: 5.1.23-rc/5.1BK/5.0/6.0
]]> Mon, 03 Mar 2008 14:17:54 +0000 Server: DML http://bugs.mysql.com/35766 #35766: LOAD OPTIONALLY ENCLOSED BY prematurly terminates http://bugs.mysql.com/bug.php?id=35766 Submitted by: Lars Johansson
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (Mandriva 2008 )
Version: 5.1.22, 4.1, 5.0, 5.1, 6.0 BK
]]> Wed, 02 Apr 2008 10:05:51 +0000 Server: DML http://bugs.mysql.com/36698 #36698: ROW_COUNT() is reset inconsistently http://bugs.mysql.com/bug.php?id=36698 Submitted by: Scott Noyes
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.0.60/5.1BK
]]> Tue, 13 May 2008 19:57:15 +0000 Server: DML http://bugs.mysql.com/39079 #39079: Truncating incorrect DECIMAL value at the wrong place http://bugs.mysql.com/bug.php?id=39079 Submitted by: Nicklas Westerlund
Category: Server: DML
Status: Verified
Severity: 3
OS: Any (Mac OSX, Linux)
Version: 5.x, 6.x
]]> Wed, 27 Aug 2008 19:13:48 +0000 Server: DML http://bugs.mysql.com/39201 #39201: INTO OUTFILE Statement http://bugs.mysql.com/bug.php?id=39201 Submitted by: Arthur Mendonça Meskelis
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (2.6.24.5-smp)
Version: 5.1.26-rc, 4.1, 5.0, 5.1, 6.0 bzr
]]> Tue, 02 Sep 2008 21:22:28 +0000 Server: DML http://bugs.mysql.com/39247 #39247: LOAD DATA INFILE skips too many rows http://bugs.mysql.com/bug.php?id=39247 Submitted by: d di
Category: Server: DML
Status: Verified
Severity: 3
OS: Any (MS Windows 5.0.2195, Linux)
Version: 5.0.67, 5.0, 5.1, 6.0 bzr
]]> Thu, 04 Sep 2008 15:05:57 +0000 Server: DML http://bugs.mysql.com/40052 #40052: SQL_NO_STRICT: per-query way to disable strict mode http://bugs.mysql.com/bug.php?id=40052 Submitted by: Olaf van der Spek
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
]]> Wed, 15 Oct 2008 14:46:47 +0000 Server: DML http://bugs.mysql.com/41477 #41477: InnoDB foreign keys: wrong result if ON DELETE CASCADE, and correlated subquery http://bugs.mysql.com/bug.php?id=41477 Submitted by: Konstantin Osipov
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 4.1, 5.0, 5,1, 6.0 bzr
]]> Mon, 15 Dec 2008 15:33:57 +0000 Server: DML http://bugs.mysql.com/41487 #41487: select into outfile not enclosing integer columns where this would disambiguate http://bugs.mysql.com/bug.php?id=41487 Submitted by: Stewart Smith
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 6.0.9, 5.0, 5.1, 6.0 bzr
]]> Tue, 16 Dec 2008 05:27:35 +0000 Server: DML http://bugs.mysql.com/41489 #41489: LOAD DATA INFILE doesn't work with multibyte ENCLOSED BY (although SELECT INTO O http://bugs.mysql.com/bug.php?id=41489 Submitted by: Stewart Smith
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 6.0.9
]]> Tue, 16 Dec 2008 06:32:46 +0000 Server: DML http://bugs.mysql.com/44060 #44060: First option of PROCEDURE ANALYSE() does not work, second needs some work http://bugs.mysql.com/bug.php?id=44060 Submitted by: Roel Van de Paar
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 4.1, 5.0, 5.1, 6.0 bzr
]]> Fri, 03 Apr 2009 03:07:13 +0000 Server: DML http://bugs.mysql.com/47434 #47434: Ambigous field name in group by clause does not cause an error http://bugs.mysql.com/bug.php?id=47434 Submitted by: Jordi Salvat i Alabart
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux
Version: 5.0.51a-24+lenny1-log, 5.1.38
]]> Fri, 18 Sep 2009 10:18:14 +0000 Server: DML http://bugs.mysql.com/47713 #47713: SELECT WITH ROLLUP returned wrong data when using CONCAT http://bugs.mysql.com/bug.php?id=47713 Submitted by: Richard Teubel
Category: Server: DML
Status: Verified
Severity: 1
OS: Any
Version: 5.0.83, 5.1.39
]]> Tue, 29 Sep 2009 12:51:27 +0000 Server: DML http://bugs.mysql.com/50627 #50627: how to insert a TIMESTAMP of the last hour of daylight savings http://bugs.mysql.com/bug.php?id=50627 Submitted by: Marc Herbert
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.5.1-m2
]]> Tue, 26 Jan 2010 15:21:20 +0000 Server: DML