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/6555 #6555: Dumping a table with a FOREIGN KEY ignores --lower_case_table_names=0 http://bugs.mysql.com/bug.php?id=6555 Submitted by: Federico Chiesa
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Windows (Windows (XP))
Version: 6.1,4.021
]]> Wed, 10 Nov 2004 17:43:04 +0000 Server: DDL http://bugs.mysql.com/8565 #8565: ALTER TABLE MODIFY adds duplicate keys which slow down SELECTs http://bugs.mysql.com/bug.php?id=8565 Submitted by: anzenews asdf
Category: Server: DDL
Status: Duplicate
Severity: 2
OS: Any (*)
Version: 5.0.30
]]> Thu, 17 Feb 2005 11:50:14 +0000 Server: DDL http://bugs.mysql.com/12347 #12347: InnoDB: DROP TABLE ignores locks http://bugs.mysql.com/bug.php?id=12347 Submitted by: Peter Gulutzan
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Linux (SUSE 9.2)
Version: 5.0.11-beta-debug
]]> Wed, 03 Aug 2005 14:42:22 +0000 Server: DDL http://bugs.mysql.com/15491 #15491: ALTER TABLE violates REPEATABLE READ http://bugs.mysql.com/bug.php?id=15491 Submitted by: Kolbe Kegel
Category: Server: DDL
Status: Duplicate
Severity: 2
OS: Linux (Linux)
Version: 5.0.16
]]> Mon, 05 Dec 2005 15:22:49 +0000 Server: DDL http://bugs.mysql.com/23993 #23993: Warning with unknown error on table creation with comments larger than 60 chars. http://bugs.mysql.com/bug.php?id=23993 Submitted by: Gökhan Demir
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Linux (linux)
Version: 5.0.27/5.1BK
]]> Mon, 06 Nov 2006 00:10:36 +0000 Server: DDL http://bugs.mysql.com/24443 #24443: second timestamp column has an invalid default value http://bugs.mysql.com/bug.php?id=24443 Submitted by: Brian Duggan
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Linux (linux)
Version: 5.0.54, 5.0.32-BK, 5.0.26
]]> Mon, 20 Nov 2006 18:07:38 +0000 Server: DDL http://bugs.mysql.com/26305 #26305: Foreign Keys: Incorrect error reporting when dropping index tied by an FK http://bugs.mysql.com/bug.php?id=26305 Submitted by: Alex Rytov
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1.15, 5.0 BK, 4.1 BK
]]> Tue, 13 Feb 2007 00:25:34 +0000 Server: DDL http://bugs.mysql.com/27935 #27935: TRUNCATE fires DELETE trigger if InnoDB table is referenced by a foreign key http://bugs.mysql.com/bug.php?id=27935 Submitted by: Guilhem Bichot
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Linux
Version: 5.1-bk/5.0bk
]]> Wed, 18 Apr 2007 20:22:21 +0000 Server: DDL http://bugs.mysql.com/29618 #29618: ERROR 1112 - Table x uses an extension that doesn't exist in this MySQL Version http://bugs.mysql.com/bug.php?id=29618 Submitted by: Shane Bester
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0.42, 5.1.21
]]> Sat, 07 Jul 2007 19:26:00 +0000 Server: DDL http://bugs.mysql.com/32945 #32945: killing create table .. like .. causes a server to crash http://bugs.mysql.com/bug.php?id=32945 Submitted by: Shane Bester
Category: Server: DDL
Status: Duplicate
Severity: 1
OS: Any
Version: 5.0.52
]]> Mon, 03 Dec 2007 19:53:33 +0000 Server: DDL http://bugs.mysql.com/33124 #33124: Error 1067 adding column to table with 2 not null TIMESTAMPs when NO_ZERO_DATE http://bugs.mysql.com/bug.php?id=33124 Submitted by: Gordon Shannon
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Linux
Version: 5.0.27-log
]]> Mon, 10 Dec 2007 21:12:06 +0000 Server: DDL http://bugs.mysql.com/33186 #33186: Crash in CREATE TABLE LIKE during unlocking of table http://bugs.mysql.com/bug.php?id=33186 Submitted by: Harrison Fisk
Category: Server: DDL
Status: Duplicate
Severity: 2
OS: Linux (x86_64 (RHEL 5))
Version: 5.0.50
]]> Wed, 12 Dec 2007 22:09:14 +0000 Server: DDL http://bugs.mysql.com/37422 #37422: CREATE TABLE fails for VARCHAR(21845) UTF8 http://bugs.mysql.com/bug.php?id=37422 Submitted by: Jan Kneschke
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0, 5.1
]]> Mon, 16 Jun 2008 07:35:40 +0000 Server: DDL http://bugs.mysql.com/43151 #43151: default values doesn't mention implicit default for columns in pkey http://bugs.mysql.com/bug.php?id=43151 Submitted by: Stewart Smith
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0, 5.1.31
]]> Tue, 24 Feb 2009 15:05:37 +0000 Server: DDL http://bugs.mysql.com/44260 #44260: DROP TABLESPACE is inconsistent http://bugs.mysql.com/bug.php?id=44260 Submitted by: Hakan Küçükyılmaz
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
]]> Tue, 14 Apr 2009 12:10:07 +0000 Server: DDL http://bugs.mysql.com/44836 #44836: DDL locking is not consistent http://bugs.mysql.com/bug.php?id=44836 Submitted by: Hakan Küçükyılmaz
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: mysql-6.0-falcon
]]> Tue, 12 May 2009 21:38:26 +0000 Server: DDL http://bugs.mysql.com/46153 #46153: CREATE TABLE IF NOT EXISTS with SELECT http://bugs.mysql.com/bug.php?id=46153 Submitted by: Ruvim Pinka
Category: Server: DDL
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1
]]> Mon, 13 Jul 2009 18:01:48 +0000 Server: DDL http://bugs.mysql.com/46766 #46766: ALTER TABLE corrupts table on combined drop and add index http://bugs.mysql.com/bug.php?id=46766 Submitted by: Holger Kunst
Category: Server: DDL
Status: Duplicate
Severity: 2
OS: Windows (XP Pro - SP3)
Version: 5.1.37-community
]]> Mon, 17 Aug 2009 19:26:34 +0000 Server: DDL http://bugs.mysql.com/46949 #46949: memory leak with failed alter table to create partitions based on extract() http://bugs.mysql.com/bug.php?id=46949 Submitted by: Shane Bester
Category: Server: DDL
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1.39, 5.1, next bzr
]]> Thu, 27 Aug 2009 08:05:30 +0000 Server: DDL http://bugs.mysql.com/47381 #47381: Wrong warning about crashed table, CREATE TABLE IF NOT EXISTS AS SELECT http://bugs.mysql.com/bug.php?id=47381 Submitted by: Matthias Leich
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1,5.4
]]> Wed, 16 Sep 2009 16:00:45 +0000 Server: DDL http://bugs.mysql.com/47417 #47417: Foriegn Key constraints are not respected on self referencing tables http://bugs.mysql.com/bug.php?id=47417 Submitted by: Mysql User
Category: Server: DDL
Status: Duplicate
Severity: 2
OS: Any
Version: All
]]> Thu, 17 Sep 2009 14:39:53 +0000 Server: DDL http://bugs.mysql.com/48801 #48801: CREATE TABLE IF NOT EXISTS t does not fail if t is a view http://bugs.mysql.com/bug.php?id=48801 Submitted by: Sven Sandberg
Category: Server: DDL
Status: Duplicate
Severity: 2
OS: Any
Version: 5.0+
]]> Mon, 16 Nov 2009 11:30:28 +0000 Server: DDL http://bugs.mysql.com/49194 #49194: Dropping a database linked to a TEMPORARY table does not drop the table. http://bugs.mysql.com/bug.php?id=49194 Submitted by: Roel Van de Paar
Category: Server: DDL
Status: Duplicate
Severity: 2
OS: Any
Version: 5.0.23+, 5.1.40, 5.1.41
]]> Mon, 30 Nov 2009 05:33:09 +0000 Server: DDL http://bugs.mysql.com/49989 #49989: Show create table for a view with empty column generates incorrect script http://bugs.mysql.com/bug.php?id=49989 Submitted by: Alon Lubin
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0.89, 5.1.41, 5.1.43
]]> Wed, 30 Dec 2009 09:38:44 +0000 Server: DDL http://bugs.mysql.com/50384 #50384: InnoDB should check whether a foreign key exists before attempting to drop it http://bugs.mysql.com/bug.php?id=50384 Submitted by: Ben Krug
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 5.0.90-bzr, 5.1.43-bzr
]]> Fri, 15 Jan 2010 21:59:00 +0000 Server: DDL http://bugs.mysql.com/51451 #51451: ALTER TABLE DROP INDEX, ADD INDEX executed in opposite order http://bugs.mysql.com/bug.php?id=51451 Submitted by: Marko Mäkelä
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1
]]> Wed, 24 Feb 2010 09:57:16 +0000 Server: DDL http://bugs.mysql.com/51680 #51680: "ALTER TABLE ... DELAY_KEY_WRITE=1" causes a full table copy http://bugs.mysql.com/bug.php?id=51680 Submitted by: Max Sheehan
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: IBM AIX
Version: 5.1.43
]]> Wed, 03 Mar 2010 08:36:50 +0000 Server: DDL http://bugs.mysql.com/51910 #51910: CREATE TABLE adds implicit DEFAULT value for primary key when not defined inline http://bugs.mysql.com/bug.php?id=51910 Submitted by: Tobias Asplund
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: MacOS
Version: 5.1.32, 5.1.45
]]> Wed, 10 Mar 2010 13:06:35 +0000 Server: DDL http://bugs.mysql.com/52064 #52064: MySQL doing a table copy when creating index http://bugs.mysql.com/bug.php?id=52064 Submitted by: Marko Mäkelä
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1.43-bzr
]]> Mon, 15 Mar 2010 12:40:48 +0000 Server: DDL http://bugs.mysql.com/54830 #54830: mysql_upgrade moves all databases into database with period in name http://bugs.mysql.com/bug.php?id=54830 Submitted by: Sean Jenkins
Category: Server: DDL
Status: Duplicate
Severity: 3
OS: Linux
Version: 5.1.47
]]> Sat, 26 Jun 2010 21:36:18 +0000 Server: DDL