https://bugs.documentfoundation.org/show_bug.cgi?id=100167
--- Comment #12 from [email protected] ---
(In reply to donotspam from comment #9)
> Although I agree that the lack of a PK causes certain problems when
> querying/updating/deleting, a PK should not be a requirement and the db
> should still work - at least to the extent that one record can be
> distinguished from others... or at least give an error message if it is to
> be "required".
If you create a table you will be asked for a primary-key. If you won't chose a
primary key there should appear a hint you couldn't input data into this table.
The internal HSQLDB wouldn't work without a primary key in a table. Have tested
this with your example-database: There appears
"No Primary Key
A unique index or primary key ....
You could only enter data ...
Should a primary key be created now?"
This dialog appears. Could be, you have ignored it?
>
> ...works in MariaDB (and Access) where issue_cat has no PK.
I don't know anything about Access, but MariaDB won't need a primary key.
For the internal HSQLDB you have to define the relations with Tools >
Relations. This would only work with relational databases - and MariaDB isn't a
relational database for all table-formats, which are provided by MariaDB.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
