<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - primary key in a primary-foreign key relationship can not contain a capital letter" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122520#c10">Comment # 10</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - primary key in a primary-foreign key relationship can not contain a capital letter" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122520">bug 122520</a> from <a class="email" href="mailto:elderdanlewis@gmail.com" title="Dan Lewis <elderdanlewis@gmail.com>"> Dan Lewis</a> <pre>(In reply to Xisco Faulí from <a href="show_bug.cgi?id=122520#c9">comment #9</a>) > 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 <a href="https://www.libreoffice.org/download/libreoffice-fresh/">https://www.libreoffice.org/download/libreoffice-fresh/</a> ? > 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.)</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>