https://bugs.documentfoundation.org/show_bug.cgi?id=114337
--- Comment #7 from [email protected] ---
(In reply to robert from comment #6)
> A test-document would be something like an empty internal Database (with or
> without table) and a spreadsheet-file.
>
> Content of your spreadsheet-file couldn't be added to a table without
> special description:
> Where is the primarykey? Could only be field 2, because field 1 has all the
> same content. Or is it created automatically by another (unnamed) field?
> What should be changed for second input? Must be all the content of field 2,
> if this field contents the primarykey. Must be only one field, if primarykey
> is created automatically. Only one field to have a look if content of
> clipboard will be recognized or not.
why should there be a primary key?
I add all my data to an IBM Power i DB2 Database connected via ODBC, and there
is no need for a primary key in the initial dataset in the classical way, IBM's
DB2 handles this internally by assigning each incoming record a record number
rrn(). So i could just add 1 billion lines containing just a 1 as the only
field and it would be fine.
But when i change this 1 (in calc) to let's say a 2, it is not fine if
LibreOffice base keeps adding ones after i copied the new data content.
All this worked fine with release 5.3, the problem appeared with version 5.4
and it's a highly critical killer bug for us.
Thanks for your efforts going into the details here but i will first try to
validate roberts input and check out if this bug was already fixed with 5.4.4
--
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
