Bug #11232 | Return a warning if creating a FOREIGN KEY on storage engines w/out support | ||
---|---|---|---|
Submitted: | 10 Jun 2005 9:56 | Modified: | 10 Jun 2005 13:49 |
Reporter: | Tobias Asplund | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S4 (Feature request) |
Version: | * | OS: | Any (*) |
Assigned to: | CPU Architecture: | Any |
[10 Jun 2005 9:56]
Tobias Asplund
[18 Jul 2006 20:12]
Tobias Asplund
could probably be a good idea to give a hard error if the sql_mode no_engine_substitution is active instead of warning.
[15 Feb 2009 18:55]
Peter Gulutzan
For WL#148 (Foreign keys: all storage engines) the decision was: We will store foreign-key information, even for storage engines like BLACKHOLE. This doesn't mean we'll always use them.