[Libreoffice-bugs] [Bug 138091] Base Index Design not saved

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Fred <FKlusmann at aol.com> ---
(In reply to Robert Großkopf from comment #1)
Thank you.
Please refer to BH40-BaseHandbook, page 41.

A test table (People) would have Person_ID (primary key, autovalue), FirstName,
Initial, LastName (all Text [VARCHAR]).

It is possible that there are several "John Q Public". Each would have his own
Primary Key (PK). 

I want to create an Index of the (3) name fields.    

Edit the Table, <Tools><Index Design> and see several ~SYS_IDX_##~
Click the leftmost icon (New Index) and see ~index1~
Select each of the name fields, then click "Close"
Verify that Unique is checked.
See the "Do you want to save the changes made to the current index?"
Click "Yes"
Read "Index not found: index1 in statement [DROP INDEX "index1" ON "People"]

Note: the names shown for the indexes are not constant.

-- 
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/20201124/e7156c4e/attachment.htm>