[Libreoffice-bugs] [Bug 117148] FIREBIRD allows no edit for table with unique index, but no primary key, contrary to message

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117148

robert at familiegrosskopf.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #3 from robert at familiegrosskopf.de ---
Seems to be a problem of the GUI-message.

HSQLDB and Firebird could work with tables without primarykey. Only the GUI
doesn't allow it. You could input data in a table without primarykey using
Tools → SQL.

Create a table "tblName" with only one field "Name". Ignore the warning when
saving without PK/Index. Go to Tools → SQL.
Write down
INSERT INTO "tabName" ("Name") VALUES ('BigBoss')
'BigBoss' will inserted in the table, which doesn't has a primarykey and
doesn't has a index. Works in HSQLDB and Firebird.

The message is wrong. 
The GUI doesn't support unique index for input of data later.
And: Declaring an index is impossible before saving the table with tableeditor.

I will set this one to NEW.

-- 
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/20180422/4dbf359a/attachment.html>