Hola Dan,
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.
Best wishes,
Drew
On Sat, Jan 12, 2019 at 1:24 PM Dan Lewis <grandpadan.lewis@xxxxxxxxx> wrote:
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
capital.
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.
Dan
_______________________________________________
LibreOffice mailing list
LibreOffice@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice
_______________________________________________ LibreOffice mailing list LibreOffice@xxxxxxxxxxxxxxxxxxxxx https://lists.freedesktop.org/mailman/listinfo/libreoffice
