Bug #92788 ERROR 3664 (HY000): Failed to set SDI When Attempting to Create a Foreign Key
Submitted: 16 Oct 2018 3:12 Modified: 16 Oct 2018 7:59
Reporter: Philip VIllanueva Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:8.0.12 OS:Mac OS X
Assigned to: CPU Architecture:Any

[16 Oct 2018 3:12] Philip VIllanueva
Description:
Unable to set a foreign key on workbench 6.3 or via MySQL client.  I tried as using my super user account and as root.  In each case i get the following error:

ERROR 3664 (HY000): Failed to set SDI 'ProductTracker.tblProducts' in tablespace 'producttracker/tblproducts'.

How to repeat:
create 3 tables tblCustomers, tblProducts and tblProductRequests.

tblCustomers:
CID PK INT NN AI
FirstName Varchar(40) NN
LastName Varchar(40) NN

tblProducts:
PID PK INT NN AI
ProductName

tblProductRequests:
PRID PK INT NN AI
CID INT NN
PID INT NN
QTY INT NN

Create Foreign Keys in tblProductRequests:
fk_req_cid  Reference tblCustomers - CID
fk_req_pid Reference tblProducts - PID

The foreign key for Customers worked.  However, when I attempt to add the foreign key for Proudcts, that is when I get the SDI error.

Suggested fix:
Either provide a work around, a solution or a fix to this issue.  I never had this issue with MySQL 5.1.
[16 Oct 2018 7:59] Miguel Solorzano
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.