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
• Status: Can't repeat
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 8.0.12
• OS: MacOS
• 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] MySQL Verification Team

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.