Hola Dan, Noticed that Tamas Bunth checked in two patchs today regarding MySQL foreign keys, it is marked as fixing issues in https://bugs.documentfoundation.org/show_bug.cgi?id=122437 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.le...@gmail.com> 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@lists.freedesktop.org > https://lists.freedesktop.org/mailman/listinfo/libreoffice >
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice
