Bug 122520 foreign key constraints
drewjensen.inbox at gmail.com
Sat Jan 12 18:37:09 UTC 2019
Noticed that Tamas Bunth checked in two patchs today regarding MySQL
foreign keys, it is marked as fixing issues in
I wonder if it might also address the problem here.
I would give it a try with the latest 6.3 daily build in a day or two and
see if that does it.
On Sat, Jan 12, 2019 at 1:24 PM Dan Lewis <grandpadan.lewis at gmail.com>
> 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.
> LibreOffice mailing list
> LibreOffice at lists.freedesktop.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the LibreOffice