Bug 122520 foreign key constraints

[Drew Jensen]

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.lewis at 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 at lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20190112/a15e693f/attachment.html>