[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 #10 from Dan Lewis <elderdanlewis at gmail.com> ---
(In reply to Xisco Faulí from comment #9)
> Hello Dan Lewis,
> A new major release of LibreOffice is available since this bug was reported.
> Could you please try to reproduce it with the latest version of LibreOffice
> from https://www.libreoffice.org/download/libreoffice-fresh/ ?
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' if the bug is still present in the latest version.

I tested this problem using LO 6.2.5.2 and 6.3.0. For this,  MySQL Client,
Connector/J, and Server are all now updated to 8.0.17 which was recently
updated.
   1) First using LO 6.2.5.2: I can create a table with its primary key
containing a capital letter along with a second table with both primary and
foreign key containing a capital letter. Then I created a relationship using
Tools > Relationships for these tables (sample1 and sample2), saved, and then
closed this dialog. When I had the problem, reopening this dialog is what
produced the problem. But this time, reopening the Relationships dialog did not
make any changes: the relationship was exactly what it should be. Problem
solved. Important point: I deleted the primary-foreign key relationship first
and then the tables themselves before opening LO 6.3.0.
   2) Now using LO 6.3.0 (prelease): following the same steps to create two
related tables in which both primary and foreign keys contain a capital letter.
It is impossible to go any farther. When I opened Tool > Relationships dialog,
I got a display of all of the presently defined relationships. To create a
relationship, I clicked the Add Table button. What I got was a list of some
schema and some actual tables. But there were not any way of selecting a
specific table from a given given schema! Thus, there is no way to define the
relationship between two tables using the Add Table button. So, in essence,
Tools > Relationships has a very serious problem. This is likely a new bug: the
Add Tables list does not contain any dropdown lists.
    3) Before I made the deletions mentioned in 1) above, I connected to MySQL
using LO 6.3.0 which means I had access to the related tables. So when I opened
Tools > Relationships, there was the two tables sample1 and sample2 shown with
the proper relationship 1:n just as it should. Conclusion: As long as a person
is using LO 6.2.5.2 (possibly earlier), using a capital letter in either of the
primary or foreign key will not cause a problem. (I have not tried 6.2.5.1
yet.)

-- 
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/20190731/03b0887b/attachment-0001.html>