https://bugs.freedesktop.org/show_bug.cgi?id=56242
Priority: medium
Bug ID: 56242
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Libreoffice Base should handle tables without a
primary key better
Severity: normal
Classification: Unclassified
OS: All
Reporter: bugs.freedesktop....@rolf.leggewie.biz
Hardware: Other
Status: UNCONFIRMED
Version: 3.5.6.2 release
Component: Database
Product: LibreOffice
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
