Bug 122520 foreign key constraints

Dan Lewis grandpadan.lewis at gmail.com
Sat Jan 12 18:24:24 UTC 2019

When upgrading MySQL 8.0.13 from 5.7, a problem occurs if any of the 
foreign key restraints contains a primary key with one or more capital 
letters in it. MySQL converts any capital letters to lower case in the 
foreign key restraint while still recognizing the primary key with its 

For example: the primary key is Primary_id and its foreign key is 
foreign_id. In practice, the restraint links these two fields: 
primary_id and foreign_id respectively. Since primary_id contains no 
data, the related tables can not be used in a query.

A warning of some type should be made stating that primary keys are not 
to have any capital letters in it.


More information about the LibreOffice mailing list