[Libreoffice-bugs] [Bug 122520] primary key in a primary-foreign key relationship can not contain a capital letter

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122520

--- Comment #8 from Dan Lewis <elderdanlewis at gmail.com> ---
   There is a solution to this, but it requires Workbench or the command line
in MySQL itself.

1) Open the table with the foreign key in edit mode. Under Foreign keys,
uncheck the box that links the primary and foreign keys.
2) Delete the foreign key.
3) Click the Apply button.
4) OK the sql required to do this.
5) Open the other table in edit mode.
6) Double click the primary key permit you to change the spelling.
7) Change all CAPITALS to lower case.
8) Click the Apply button.
9) OK the sql required to do this.
10) Create the foreign key restraint.
11) Click the Apply button, and then OK the sql required to do this. Close
Workbench.
12) Close the database in Base and reopen. (This should correct the situation.
   Comment: Perhaps somewhere in documentation either help and/or user guides
something should be written to emphasize the fact that capital letters should
not be used in the name of primary keys used in foreign key restraints.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190112/98dc7491/attachment.html>