[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 #7 from Dan Lewis <elderdanlewis at gmail.com> ---
(In reply to Lionel Elie Mamane from comment #6)
> I can't understand the workbench screenshot.
> 
> I'm unsure if
>  - you create the tables and "primary-foreign key pair" with the LibreOffice
> UI, and the problem you report is that LibreOffice creates a relationship
> *additionally*, which then also shows in workbench and an SQL dump of the
> database.
>  - you create the tables and "primary-foreign key pair" with another tool,
> but LibreOffice merely *shows* (not creates) a relationship that doesn't
> exist.
> 
> In both cases, can you please give exact instructions to create the tables?
> (Click by click if done with the LibreOffice UI, and SQL script if done by
> another tool).

The tables were created in 2012 by the latest LibreOffice. A database document
file was created to connect Base (the front end) and MySQL (the back end). The
tables were originally part of embedded database files. Calc was opened
followed by the Data Source window. Each table was copied to its individual
empty spreadsheet. Then using the Table Copy Dialogue, the tables were copied
into the MySQL database file. the primary-foreign key pairs were then created
in Tools > Relations including the use of the Relations dialogue. Since then I
have also installed MySQL Workbench. Using this, I have made backups of the
data through the years as well as later made adjustments to the tables in the
MySQL file.

-- 
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/47b80f3a/attachment.html>