originally reported as - https://bugzilla.novell.com/show_bug.cgi?id=444129
I think LO should handle tables without a primary key better (cf.
http://qa.openoffice.org/issues/show_bug.cgi?id=54168 as well) Right now, when
you open such a table, it is opened as non-editable, leaving the user to wonder
about the reason. I think the user should at least receive a warning about
this, possibly coupled with a suggestion to visit a website where more details
and possible solutions can be given (I understand there are some issues with
handling tables without primary keys and there is not one single, best answer)
Steps to reproduce:
1) Load https://bugzilla.novell.com/attachment.cgi?id=251407 into a MySQL
server of your choice
2) Create new database and connect to above database
3) optional: enable logging for your MySQL server
4) double click on table accounts which does have a primary key
5) double click on table accounts_ext which does not
Observe the difference between 4 and 5 in that cells in 4 are editable where
those from 5 are not.
FWIW, OOo/LO emits a useful warning when creating a table without a primary key: https://bugzilla.novell.com/attachment.cgi?id=251613
I have changed this bug to new. Its an enhancement, which isn't included yet. Also changed the Importance to "enhancement".
Adding self to CC if not already on
Created attachment 117443 [details]
This is the https://bugzilla.novell.com/attachment.cgi?id=251407 test case
Created attachment 117444 [details]
This is the https://bugzilla.novell.com/attachment.cgi?id=251613 screenshot
The situation in 18.104.22.168 is still as originally described
I was trying to verify this today in 4.4.5 and 22.214.171.124.alpha1+ but I did not see how to connect to MySQL directly. Only JDBC and ODBC were offered. Is this something Ubuntu-specific, some kind of extension that needs to be added or something that was dropped since 126.96.36.199?
(In reply to Rolf Leggewie from comment #6)
> I was trying to verify this today in 4.4.5 and 188.8.131.52.alpha1+ but I did not
> see how to connect to MySQL directly. Only JDBC and ODBC were offered. Is
> this something Ubuntu-specific, some kind of extension that needs to be
> added or something that was dropped since 184.108.40.206?
You need an extension:
Works here also with LO 4.4. without problems.
FWIW, I have version 1.0.2 of that extension since that is what's packaged for Ubuntu trusty. Not sure if that's where the difference comes from. I cannot activate the more recent 1.0.4_3 alongside.
Where does that particular newer version come from anyhow? LO itself still has only 1.0.2 as oneh can see from https://cgit.freedesktop.org/libreoffice/core/tree/mysqlc/source/description.xml#n23
*** Bug 81430 has been marked as a duplicate of this bug. ***