What would cause a discrepancy in Unique ID numbers during searches?

DMG · February 27, 2023, 6:50pm

Hello. I am using LibreOffice 7.5 (64k) on a Windows 10 desktop.
.
When using the Ctrl+F “Search” to find a text phrase in the name field, LO does find the record. As you can see in the picture below, this search result is Record ID #713 in the table. However, the Ctrl+F Search dialog window displays Record ID #693 instead.
.

.
.
I have noticed this mismatch in record numbers repeatedly.
.
Is my database corrupted? (I don’t want to spend a lot of time rebuilding this database if it is already corrupted).

Villeroy · February 27, 2023, 7:07pm

After deleting records you don’t want to change all subsequent IDs including all the foreign keys in other tables referencing this ID.

DMG · February 27, 2023, 7:14pm

But I didn’t change Record ID numbers…

I have only tried to delete one record in this database (while viewing it in a form) using the Delete function on the navigation toolbar. It displayed a confirmation to delete the record, and I pressed Yes… but the record would not delete. I tried to delete it several times… it would not delete. After that, I noticed the mismatch in record numbers.

RobertG · February 27, 2023, 8:16pm

The record with ID 713 is could be found in row 693. It isn’t the ID, which is shown there.

Have a look at the ID’s of your screenshot: ID 714, ID 716 and ID 718 aren’t there. And also there would be other values of ID < 713, which aren’t there.

The row number depends also on sorting and filtering. ID has nothing to do with the row number except you start a table with ID 1 and add always a value ‘1’ to this ID for every new row, never delete a record and never sort or filter the table.

Villeroy · February 27, 2023, 8:30pm

You actually did delete those records.

DMG · February 27, 2023, 8:39pm

OK… I got it. Record #693 merely means the 693rd record in the database… NOT Record ID #.

Wanderer · February 27, 2023, 7:05pm

What you’ve found is no sign of corruption. It is the difference between an ID wich usually is not changed and a line number.
.
Assume a library. Books with Ids 1 to 1000 (small library). Now book 345 is stolen and deleted from the library. Would you re-number all books from 346 to 1000 and change also all lists like DMG has book 402 (now 401) until March 1st. Usually you don’t. So there are holes in numbering. There is only one important property on an id: it must be unique.

PS: However: Your database may be corrupted. Explaining this item will prove nothing on this topic… But it is usually not likely.

DMG · February 27, 2023, 7:16pm

But I didn’t try to change the Record ID numbers.

I did TRY to delete a record through the form-view previously, but the record would not delete (see above).