| Showing all 46 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 44918 | 2009-05-16 13:39 | 2013-04-14 20:45 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 5.0+ | Any | Any | Improve TRUNCATE TABLE for InnoDB tables with Foreign Keys |
| 78255 | 2015-08-28 8:37 | 2015-08-28 14:35 | MySQL Server: InnoDB storage engine | Verified (3386 days) | S3 | 5.6.24 (and earlier, too) | Any | Any | Foreign key allowed between InnoDB and MyISAM if "set foreign_key_checks=0" |
| 15045 | 2005-11-18 9:35 | 2018-06-14 16:56 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 4.1 | Windows (windows xp) | Any | can't drop and recreate foreign key in a single ALTER TABLE statement |
| 24668 | 2006-11-28 19:02 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 5.0.32-BK, 5.0.27 | Linux (Linux, Windows XPsp2) | Any | CASCADING FOREIGN KEYS do not work on same TABLE |
| 28947 | 2007-06-07 14:47 | 2013-04-14 20:45 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 5.0.33 | Any | Any | Optimize foreign key checks for truncate table with empty referencing table |
| 115457 | 2024-06-28 14:42 | 2024-07-03 14:34 | MySQL Server: InnoDB storage engine | Verified (159 days) | S3 | 8.0 | Any | Any | rename of a column in multi-column foreign key returns ERROR 1146 (42S02) |
| 107532 | 2022-06-09 20:21 | 2024-03-11 11:06 | MySQL Server: InnoDB storage engine | Verified (904 days) | S2 | 8.0 | Ubuntu (debian docker) | Any | running parallel TRUNCATE causing foreign key constraint fails on INSERT |
| 81097 | 2016-04-15 12:21 | 2019-08-20 8:10 | MySQL Server: InnoDB storage engine | Verified (3152 days) | S3 | 5.7.12 | Any | Any | Index disappears depending on whether it was created by adding a foreign key |
| 71669 | 2014-02-11 12:25 | 2014-07-24 20:10 | MySQL Server: InnoDB storage engine | Verified (3786 days) | S3 | 5.537-35.1-log, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5 | Any | Any | Inconsistence with RESTRICT and NO ACTION |
| 38882 | 2008-08-19 6:31 | 2018-07-17 16:33 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 5.0, 5.1, 6.0 | Any | Any | Allow sloppy type matches in FOREIGN KEY constraints |
| 10063 | 2005-04-21 15:15 | 2017-11-13 0:25 | MySQL Server: InnoDB storage engine | Verified (3969 days) | S1 | 4.1.11 | Windows (Windows XP) | Any | ANSI standard updating multiple rows -- foreign key constraints |
| 9762 | 2005-04-08 14:47 | 2017-11-13 0:21 | MySQL Server: InnoDB storage engine | Verified (3969 days) | S3 | 4.1 | Windows (Win XP Pro) | Any | Can't delete records which have foreign keys to themselves |
| 8919 | 2005-03-03 10:14 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 4.1, 5.0 | Any (all) | Any | Foreign keys handling |
| 6254 | 2004-10-25 20:34 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Verified (6678 days) | S4 | 4.1.7-debug | Linux (SuSE 9.1) | Any | IGNORE: should allow transactional tables to do partial transactions |
| 16039 | 2005-12-28 11:05 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 5.0.19-BK | Linux (Linux) | Any | Data integrity is not validated after foreign key constraints are enabled ! |
| 83799 | 2016-11-14 5:50 | 2020-08-23 14:39 | MySQL Server: InnoDB storage engine | Verified (2942 days) | S3 | 5.6.34, 5.7.16 | Any | Any | InnoDB: Assertion failure in thread x in file handler0alter.cc line 5817 |
| 107311 | 2022-05-17 2:50 | 2023-05-24 7:49 | MySQL Server: InnoDB storage engine | Verified (932 days) | S2 | 5.7.38 | Any | Any | InnoDB: Load table xx failed; Table xx doesn't exist |
| 86774 | 2017-06-21 10:26 | 2017-06-21 17:43 | MySQL Server: InnoDB storage engine | Verified (2723 days) | S2 | 5.7/8.0 | Any | Any | DELETE CASCADE on record with another DELETE SET NULL results in corrrupt tables |
| 73757 | 2014-08-28 14:06 | 2014-08-29 20:29 | MySQL Server: InnoDB storage engine | Open | S4 | any | Any | Any | Request: make error 150 specify constraint name |
| 31572 | 2007-10-12 18:26 | 2019-10-08 1:18 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 5.0.48 | Any | Any | Simplify renaming a field when it has a foreign key |
| 21641 | 2006-08-14 23:57 | 2022-04-10 20:45 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 4.1, 5.1, 5.5 | Any | Any | nonpreserving of InnoDB auto_increment values can lead to unintended inheritance |
| 13977 | 2005-10-12 20:00 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Open (5319 days) | S4 | 5.0.13 | Linux (Debian Sarge) | Any | InnoDB foreign keys with multiple parent rows act incorrectly |
| 111965 | 2023-08-04 2:43 | 2023-08-07 12:33 | MySQL Server: InnoDB storage engine | Verified (488 days) | S2 | 8.0.34, 5.7.43 | Any | Any | default NULL column leads to foreign key constraint failure |
| 8246 | 2005-02-01 18:52 | 2013-04-14 20:45 | MySQL Server: InnoDB storage engine | Open (5319 days) | S4 | Any | Ability to have a static foreign key field | ||
| 95895 | 2019-06-20 10:40 | 2019-08-13 15:35 | MySQL Server: InnoDB storage engine | Verified (1989 days) | S3 | 5.7, 5.7.26, 5.7.27, 8.0.17 | Any | Any | Shutdown takes long time when table uses AUTOINC and FOREIGN KEY constraints |
| 85605 | 2017-03-24 9:56 | 2019-06-25 15:28 | MySQL Server: InnoDB storage engine | Verified (2812 days) | S2 | 5.7, 8.0 | Any | Any | Corrupted index for ON DELETE CASCADE with self-referential ON DELETE SET NULL |
| 83263 | 2016-10-05 8:18 | 2021-06-30 7:40 | MySQL Server: InnoDB storage engine | Verified (2960 days) | S2 | 5.7.15 | Any | Any | ON DELETE constraints are not applied if multiple constraints exist |
| 77591 | 2015-07-02 0:16 | 2018-06-14 5:06 | MySQL Server: InnoDB storage engine | Verified (3443 days) | S3 | 5.6.24, 5.6.27 | Any | Any | ALTER TABLE does not allow to change NULL/NOT NULL if foreign key exists |
| 71782 | 2014-02-20 16:11 | 2014-05-02 5:21 | MySQL Server: InnoDB storage engine | Verified (3869 days) | S4 | 5.7 | Any | Any | Add table with deadlock and foreign key error information |
| 62602 | 2011-10-03 3:16 | 2013-01-27 16:20 | MySQL Server: InnoDB storage engine | Verified (4329 days) | S3 | any | Any | Any | An option to ignore foreign key checks |
| 61069 | 2011-05-05 11:01 | 2011-05-10 9:19 | MySQL Server: InnoDB storage engine | Open (4957 days) | S4 | Any | Any | Key Join | |
| 20525 | 2006-06-18 20:43 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 5.0.23-debug | Linux (SUSE 10.0 / 64-bit) | Any | Can't drop primary key if there's a foreign key |
| 10333 | 2005-05-03 13:29 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Verified (6678 days) | S4 | 5.0.7 | Linux (Linux) | Any | Incorrect error when deleting a foreign key with incorrect constraint name |
| 9679 | 2005-04-06 14:38 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Open (5319 days) | S4 | 4.* | Any (any) | Any | errors in cascaded updates |
| 7409 | 2004-12-18 18:05 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Open (5319 days) | S4 | Any | InnoDB: function to count usage of a key as foreign key in the child tables | ||
| 69358 | 2013-05-30 23:42 | 2013-06-24 18:52 | MySQL Server: InnoDB storage engine | Verified (4181 days) | S4 | 5.7 | Any | Any | Table Index/Foreign Key Limit of 64 Keys - Only fixable with OS level access |
| 114838 | 2024-05-01 13:48 | 2024-08-19 12:10 | MySQL Server: InnoDB storage engine | Verified (107 days) | S1 | 8.4.0 | Ubuntu | Any | 8.4.0 requires unique constraint for FK |
| 106012 | 2021-12-30 18:26 | 2022-04-06 11:48 | MySQL Server: InnoDB storage engine | Verified (974 days) | S3 | 8.0, 5.7 | Any | Any | Table stats in P_S not updated on rows updated via FK constraint |
| 104608 | 2021-08-12 22:31 | 2021-11-10 13:24 | MySQL Server: InnoDB storage engine | Verified (1120 days) | S4 | 5.7.35, 8.0.26 | Any | Any | Improve error message for ALTER failing because concurrent Duplicate entry. |
| 92887 | 2018-10-22 19:22 | 2018-10-31 14:16 | MySQL Server: InnoDB storage engine | Verified (2226 days) | S4 | Any | Any | innodb_print_all_fk_errors server variable missing | |
| 84361 | 2016-12-28 16:18 | 2016-12-29 6:56 | MySQL Server: InnoDB storage engine | Verified (2897 days) | S3 | 5.6, 5.6.35, 5.7.17 | Any | Any | Incorrect SHOW ENGINE INNODB STATUS for partitioned table |
| 61058 | 2011-05-04 15:53 | 2013-12-09 10:18 | MySQL Server: InnoDB storage engine | Verified (4963 days) | S2 | 5.1.37/5.5/5.6/5.7 | Linux | Any | Autoincrement exceed expected value after INSERT INTO ... SELECT |
| 45736 | 2009-06-25 3:02 | 2013-04-14 20:45 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 5.0 | Any | Any | Can't create an FK without an index on the columns |
| 15046 | 2005-11-18 10:01 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Open (5319 days) | S4 | 4.1.15 | Linux (linux) | Any | constraint incorrectly enforced |
| 10744 | 2005-05-19 13:45 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Verified (5319 days) | S4 | 4.1.11, 5.0.6 | Linux (Gentoo Linux) | Any | Adding two constraints with the same name. |
| 8415 | 2005-02-10 9:46 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Verified (3982 days) | S4 | 4.1.9 | Any (All) | Any | ALTER TABLE syntax limitation with foreign key constraints |
| Showing all 46 (Edit, Save, CSV, Feed) |
