Showing all 46 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
449182009-05-16
13:39
2013-04-14
20:45
MySQL Server: InnoDB storage engineVerified
(5258 days)
S45.0+AnyAnyImprove TRUNCATE TABLE for InnoDB tables with Foreign Keys
782552015-08-28
8:37
2015-08-28
14:35
MySQL Server: InnoDB storage engineVerified
(3325 days)
S35.6.24 (and earlier, too)AnyAnyForeign key allowed between InnoDB and MyISAM if "set foreign_key_checks=0"
150452005-11-18
9:35
2018-06-14
16:56
MySQL Server: InnoDB storage engineVerified
(5258 days)
S44.1Windows (windows xp)Anycan't drop and recreate foreign key in a single ALTER TABLE statement
246682006-11-28
19:02
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(5258 days)
S45.0.32-BK, 5.0.27Linux (Linux, Windows XPsp2)AnyCASCADING FOREIGN KEYS do not work on same TABLE
289472007-06-07
14:47
2013-04-14
20:45
MySQL Server: InnoDB storage engineVerified
(5258 days)
S45.0.33AnyAnyOptimize foreign key checks for truncate table with empty referencing table
1154572024-06-28
14:42
2024-07-03
14:34
MySQL Server: InnoDB storage engineVerified
(98 days)
S38.0AnyAnyrename of a column in multi-column foreign key returns ERROR 1146 (42S02)
1075322022-06-09
20:21
2024-03-11
11:06
MySQL Server: InnoDB storage engineVerified
(843 days)
S28.0Ubuntu (debian docker)Anyrunning parallel TRUNCATE causing foreign key constraint fails on INSERT
810972016-04-15
12:21
2019-08-20
8:10
MySQL Server: InnoDB storage engineVerified
(3091 days)
S35.7.12AnyAnyIndex disappears depending on whether it was created by adding a foreign key
716692014-02-11
12:25
2014-07-24
20:10
MySQL Server: InnoDB storage engineVerified
(3725 days)
S35.537-35.1-log, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5AnyAnyInconsistence with RESTRICT and NO ACTION
388822008-08-19
6:31
2018-07-17
16:33
MySQL Server: InnoDB storage engineVerified
(5258 days)
S45.0, 5.1, 6.0AnyAnyAllow sloppy type matches in FOREIGN KEY constraints
100632005-04-21
15:15
2017-11-13
0:25
MySQL Server: InnoDB storage engineVerified
(3908 days)
S14.1.11Windows (Windows XP)AnyANSI standard updating multiple rows -- foreign key constraints
97622005-04-08
14:47
2017-11-13
0:21
MySQL Server: InnoDB storage engineVerified
(3908 days)
S34.1Windows (Win XP Pro)AnyCan't delete records which have foreign keys to themselves
89192005-03-03
10:14
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(5258 days)
S44.1, 5.0Any (all)AnyForeign keys handling
62542004-10-25
20:34
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(6617 days)
S44.1.7-debugLinux (SuSE 9.1)AnyIGNORE: should allow transactional tables to do partial transactions
160392005-12-28
11:05
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(5258 days)
S45.0.19-BKLinux (Linux)AnyData integrity is not validated after foreign key constraints are enabled !
837992016-11-14
5:50
2020-08-23
14:39
MySQL Server: InnoDB storage engineVerified
(2881 days)
S35.6.34, 5.7.16AnyAnyInnoDB: Assertion failure in thread x in file handler0alter.cc line 5817
1073112022-05-17
2:50
2023-05-24
7:49
MySQL Server: InnoDB storage engineVerified
(871 days)
S25.7.38AnyAnyInnoDB: Load table xx failed; Table xx doesn't exist
867742017-06-21
10:26
2017-06-21
17:43
MySQL Server: InnoDB storage engineVerified
(2662 days)
S25.7/8.0AnyAnyDELETE CASCADE on record with another DELETE SET NULL results in corrrupt tables
737572014-08-28
14:06
2014-08-29
20:29
MySQL Server: InnoDB storage engineOpenS4anyAnyAnyRequest: make error 150 specify constraint name
315722007-10-12
18:26
2019-10-08
1:18
MySQL Server: InnoDB storage engineVerified
(5258 days)
S45.0.48AnyAnySimplify renaming a field when it has a foreign key
216412006-08-14
23:57
2022-04-10
20:45
MySQL Server: InnoDB storage engineVerified
(5258 days)
S44.1, 5.1, 5.5AnyAnynonpreserving of InnoDB auto_increment values can lead to unintended inheritance
139772005-10-12
20:00
2016-01-03
20:45
MySQL Server: InnoDB storage engineOpen
(5258 days)
S45.0.13Linux (Debian Sarge)AnyInnoDB foreign keys with multiple parent rows act incorrectly
1119652023-08-04
2:43
2023-08-07
12:33
MySQL Server: InnoDB storage engineVerified
(427 days)
S28.0.34, 5.7.43AnyAnydefault NULL column leads to foreign key constraint failure
82462005-02-01
18:52
2013-04-14
20:45
MySQL Server: InnoDB storage engineOpen
(5258 days)
S4 AnyAbility to have a static foreign key field
958952019-06-20
10:40
2019-08-13
15:35
MySQL Server: InnoDB storage engineVerified
(1928 days)
S35.7, 5.7.26, 5.7.27, 8.0.17AnyAnyShutdown takes long time when table uses AUTOINC and FOREIGN KEY constraints
856052017-03-24
9:56
2019-06-25
15:28
MySQL Server: InnoDB storage engineVerified
(2751 days)
S25.7, 8.0AnyAnyCorrupted index for ON DELETE CASCADE with self-referential ON DELETE SET NULL
832632016-10-05
8:18
2021-06-30
7:40
MySQL Server: InnoDB storage engineVerified
(2899 days)
S25.7.15AnyAnyON DELETE constraints are not applied if multiple constraints exist
775912015-07-02
0:16
2018-06-14
5:06
MySQL Server: InnoDB storage engineVerified
(3382 days)
S35.6.24, 5.6.27AnyAnyALTER TABLE does not allow to change NULL/NOT NULL if foreign key exists
717822014-02-20
16:11
2014-05-02
5:21
MySQL Server: InnoDB storage engineVerified
(3808 days)
S45.7AnyAnyAdd table with deadlock and foreign key error information
626022011-10-03
3:16
2013-01-27
16:20
MySQL Server: InnoDB storage engineVerified
(4268 days)
S3anyAnyAnyAn option to ignore foreign key checks
610692011-05-05
11:01
2011-05-10
9:19
MySQL Server: InnoDB storage engineOpen
(4896 days)
S4AnyAnyKey Join
205252006-06-18
20:43
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(5258 days)
S45.0.23-debugLinux (SUSE 10.0 / 64-bit)AnyCan't drop primary key if there's a foreign key
103332005-05-03
13:29
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(6617 days)
S45.0.7Linux (Linux)AnyIncorrect error when deleting a foreign key with incorrect constraint name
96792005-04-06
14:38
2016-01-03
20:45
MySQL Server: InnoDB storage engineOpen
(5258 days)
S44.*Any (any)Anyerrors in cascaded updates
74092004-12-18
18:05
2016-01-03
20:45
MySQL Server: InnoDB storage engineOpen
(5258 days)
S4 AnyInnoDB: function to count usage of a key as foreign key in the child tables
693582013-05-30
23:42
2013-06-24
18:52
MySQL Server: InnoDB storage engineVerified
(4120 days)
S45.7AnyAnyTable Index/Foreign Key Limit of 64 Keys - Only fixable with OS level access
1148382024-05-01
13:48
2024-08-19
12:10
MySQL Server: InnoDB storage engineVerified
(46 days)
S18.4.0UbuntuAny8.4.0 requires unique constraint for FK
1060122021-12-30
18:26
2022-04-06
11:48
MySQL Server: InnoDB storage engineVerified
(913 days)
S38.0, 5.7AnyAnyTable stats in P_S not updated on rows updated via FK constraint
1046082021-08-12
22:31
2021-11-10
13:24
MySQL Server: InnoDB storage engineVerified
(1059 days)
S45.7.35, 8.0.26AnyAnyImprove error message for ALTER failing because concurrent Duplicate entry.
928872018-10-22
19:22
2018-10-31
14:16
MySQL Server: InnoDB storage engineVerified
(2165 days)
S4AnyAnyinnodb_print_all_fk_errors server variable missing
843612016-12-28
16:18
2016-12-29
6:56
MySQL Server: InnoDB storage engineVerified
(2836 days)
S35.6, 5.6.35, 5.7.17AnyAnyIncorrect SHOW ENGINE INNODB STATUS for partitioned table
610582011-05-04
15:53
2013-12-09
10:18
MySQL Server: InnoDB storage engineVerified
(4902 days)
S25.1.37/5.5/5.6/5.7LinuxAnyAutoincrement exceed expected value after INSERT INTO ... SELECT
457362009-06-25
3:02
2013-04-14
20:45
MySQL Server: InnoDB storage engineVerified
(5258 days)
S45.0AnyAnyCan'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
(5258 days)
S44.1.15Linux (linux)Anyconstraint incorrectly enforced
107442005-05-19
13:45
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(5258 days)
S44.1.11, 5.0.6Linux (Gentoo Linux)AnyAdding two constraints with the same name.
84152005-02-10
9:46
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(3921 days)
S44.1.9Any (All)AnyALTER TABLE syntax limitation with foreign key constraints
Showing all 46 (Edit, Save, CSV, Feed)