Showing all 50 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS Summary Assigned
755132015-01-15
10:20
2015-01-15
11:55
MySQL Server: InnoDB storage engineOpenS55.5.31LinuxDROP TABLE creating a stall when foreign keys in use on other tables  
746092014-10-28
18:52
2014-10-28
23:40
MySQL Server: InnoDB storage engineVerified
(1058 days)
S35.6.21/5.7LinuxUnable to update Foreign Key created as NOT NULL to table named with a Dollar $  
449182009-05-16
13:39
2013-04-14
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S45.0+AnyImprove TRUNCATE TABLE for InnoDB tables with Foreign Keys  
782552015-08-28
8:37
2015-08-28
14:35
MySQL Server: InnoDB storage engineVerified
(754 days)
S35.6.24 (and earlier, too)AnyForeign key allowed between InnoDB and MyISAM if "set foreign_key_checks=0"  
150452005-11-18
9:35
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S44.1Microsoft Windows (windows xp)can't drop and recreate foreign key in a single ALTER TABLE statement Assigned Account
289472007-06-07
14:47
2013-04-14
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S45.0.33TBDAnyOptimize foreign key checks for truncate table with empty referencing table  
799182016-01-11
16:52
2017-06-14
13:04
MySQL Server: InnoDB storage engineVerified
(602 days)
S15.7.10Any (Win7 and Ubuntu)Cannot add foreign key constraint  
246682006-11-28
19:02
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S45.0.32-BK, 5.0.27TBDLinux (Linux, Windows XPsp2)CASCADING FOREIGN KEYS do not work on same TABLE Assigned Account
97622005-04-08
14:47
2014-01-22
14:57
MySQL Server: InnoDB storage engineVerified
(1337 days)
S34.1Microsoft Windows (Win XP Pro)Can't delete records which have foreign keys to themselves  
100632005-04-21
15:15
2014-01-22
14:59
MySQL Server: InnoDB storage engineVerified
(1337 days)
S14.1.11Microsoft Windows (Windows XP)ANSI standard updating multiple rows -- foreign key constraints  
62542004-10-25
20:34
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(4046 days)
S44.1.7-debugLinux (SuSE 9.1)IGNORE: should allow transactional tables to do partial transactions Assigned Account
649222012-04-10
3:48
2012-04-17
13:28
MySQL Server: InnoDB storage engineVerified
(1989 days)
S35.1.61, 5.5.22AnyForeign Key Error on CREATE TABLE after ALTER TABLE and DROP TABLE statements.  
160392005-12-28
11:05
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S45.0.19-BKLinux (Linux)Data integrity is not validated after foreign key constraints are enabled ! Assigned Account
810972016-04-15
12:21
2016-04-18
14:00
MySQL Server: InnoDB storage engineVerified
(520 days)
S35.7.12AnyIndex disappears depending on whether it was created by adding a foreign key  
89192005-03-03
10:14
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S44.1, 5.0Any (all)Foreign keys handling Assigned Account
388822008-08-19
6:31
2015-12-23
7:23
MySQL Server: InnoDB storage engineVerified
(2687 days)
S45.0, 5.1, 6.0AnyAllow sloppy type matches in FOREIGN KEY constraints Assigned Account
716692014-02-11
12:25
2014-07-24
20:10
MySQL Server: InnoDB storage engineVerified
(1154 days)
S35.537-35.1-log, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5AnyInconsistence with RESTRICT and NO ACTION  
737572014-08-28
14:06
2014-08-29
20:29
MySQL Server: InnoDB storage engineOpenS4anyAnyRequest: make error 150 specify constraint name  
315722007-10-12
18:26
2013-04-14
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S45.0.48AnySimplify renaming a field when it has a foreign key  
837992016-11-14
5:50
2016-11-14
6:55
MySQL Server: InnoDB storage engineVerified
(310 days)
S35.6.34, 5.7.16AnyInnoDB: Assertion failure in thread x in file handler0alter.cc line 5817  
216412006-08-14
23:57
2016-09-30
20:04
MySQL Server: InnoDB storage engineVerified
(2687 days)
S44.1, 5.1, 5.5Anynonpreserving of InnoDB auto_increment values can lead to unintended inheritance Sunny Bains
139772005-10-12
20:00
2016-01-03
20:45
MySQL Server: InnoDB storage engineOpen
(2687 days)
S45.0.13Linux (Debian Sarge)InnoDB foreign keys with multiple parent rows act incorrectly Assigned Account
716162014-02-07
0:53
2014-02-07
4:12
MySQL Server: InnoDB storage engineVerified
(1321 days)
S35.6.14, 5.6.15Anyauto-naming of foreign keys seems broken when multi-operation ALTER is used  
867742017-06-21
10:26
2017-06-21
17:43
MySQL Server: InnoDB storage engineVerified
(91 days)
S25.7/8.0AnyDELETE CASCADE on record with another DELETE SET NULL results in corrrupt tables  
775912015-07-02
0:16
2017-08-05
7:20
MySQL Server: InnoDB storage engineVerified
(811 days)
S35.6.24, 5.6.27AnyALTER TABLE does not allow to change NULL/NOT NULL if foreign key exists  
814442016-05-16
22:34
2016-06-23
4:44
MySQL Server: InnoDB storage engineVerified
(491 days)
S35.7, 5.7.12, 5.6.30AnyOrphan ibd file when playing with foreign keys  
205252006-06-18
20:43
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S45.0.23-debugLinux (SUSE 10.0 / 64-bit)Can't drop primary key if there's a foreign key Assigned Account
865732017-06-03
9:20
2017-09-01
5:48
MySQL Server: InnoDB storage engineVerifiedS15.7.18Anyforeign key cascades use excessive memory  
82462005-02-01
18:52
2013-04-14
20:45
MySQL Server: InnoDB storage engineOpen
(2687 days)
S4 Ability to have a static foreign key field  
876122017-08-30
16:51
2017-09-04
17:02
MySQL Server: InnoDB storage engineVerified
(16 days)
S15.6.27Anydrop index on a foreign key column leads to missing table  
832632016-10-05
8:18
2017-02-28
14:09
MySQL Server: InnoDB storage engineVerified
(328 days)
S25.7.15AnyON DELETE constraints are not applied if multiple constraints exist  
103332005-05-03
13:29
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(4046 days)
S45.0.7Linux (Linux)Incorrect error when deleting a foreign key with incorrect constraint name Assigned Account
856052017-03-24
9:56
2017-08-30
10:31
MySQL Server: InnoDB storage engineVerified
(180 days)
S25.7, 8.0AnyCorrupted index for ON DELETE CASCADE with self-referential ON DELETE SET NULL  
717822014-02-20
16:11
2014-05-02
5:21
MySQL Server: InnoDB storage engineVerified
(1237 days)
S45.7AnyAdd table with deadlock and foreign key error information  
843312016-12-24
18:37
2016-12-24
20:01
MySQL Server: InnoDB storage engineVerified
(270 days)
S35.6/5.7/8.0AnyIncorrect LATEST FOREIGN KEY ERROR for partitioned table  
139422005-10-12
0:02
2014-08-26
13:10
MySQL Server: InnoDB storage engineVerified
(4046 days)
S35.0.13-rc-ntAny (WinXP)automatic FK names > 64 chars long, truncated in information schema Sunny Bains
626022011-10-03
3:16
2013-01-27
16:20
MySQL Server: InnoDB storage engineVerified
(1697 days)
S3anyAnyAn option to ignore foreign key checks  
610692011-05-05
11:01
2011-05-10
9:19
MySQL Server: InnoDB storage engineOpen
(2325 days)
S4AnyKey Join  
787542015-10-08
11:27
2015-10-08
12:05
MySQL Server: InnoDB storage engineVerified
(713 days)
S35.6, 5.7, 5.6.27AnyFK definitions missing from SHOW CREATE TABLE in "innodb_read_only" mode  
96792005-04-06
14:38
2016-01-03
20:45
MySQL Server: InnoDB storage engineOpen
(2687 days)
S44.*Any (any)errors in cascaded updates Assigned Account
693582013-05-30
23:42
2013-06-24
18:52
MySQL Server: InnoDB storage engineVerified
(1549 days)
S45.7AnyTable Index/Foreign Key Limit of 64 Keys - Only fixable with OS level access  
74092004-12-18
18:05
2016-01-03
20:45
MySQL Server: InnoDB storage engineOpen
(2687 days)
S4 InnoDB: function to count usage of a key as foreign key in the child tables Assigned Account
330272007-12-06
0:55
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S45.1.22Anymisleading error message for FK referencing non InnoDB table Assigned Account
49192004-08-06
1:45
2016-11-18
6:26
MySQL Server: InnoDB storage engineVerified
(2687 days)
S44.0.20 / 4.1.3Any (all)Bad Foreign Key Definition does not work nor does it produce an error Assigned Account
610582011-05-04
15:53
2013-12-09
10:18
MySQL Server: InnoDB storage engineVerified
(2331 days)
S25.1.37/5.5/5.6/5.7LinuxAutoincrement exceed expected value after INSERT INTO ... SELECT  
843612016-12-28
16:18
2016-12-29
6:56
MySQL Server: InnoDB storage engineVerified
(265 days)
S35.6, 5.6.35, 5.7.17AnyIncorrect SHOW ENGINE INNODB STATUS for partitioned table  
457362009-06-25
3:02
2013-04-14
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S45.05.6+AnyCan't create an FK without an index on the columns  
150462005-11-18
10:01
2016-01-03
20:45
MySQL Server: InnoDB storage engineOpen
(2687 days)
S44.1.15Linux (linux)constraint incorrectly enforced Assigned Account
84152005-02-10
9:46
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(1350 days)
S44.1.9Any (All)ALTER TABLE syntax limitation with foreign key constraints Assigned Account
107442005-05-19
13:45
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(2687 days)
S44.1.11, 5.0.6Linux (Gentoo Linux)Adding two constraints with the same name. Assigned Account
Showing all 50 (Edit, Save, CSV, Feed)