max value for rev_id in the revision table

UB-Mannheim / RaiseWikibase

Knowledge graph construction: Fast inserts into a Wikibase instance

https://ub-mannheim.github.io/RaiseWikibase/

MIT License

45 stars 6 forks source link

max value for rev_id in the revision table #10

Open dmcmilla opened 3 years ago

dmcmilla commented 3 years ago

The method to get the next rev_id doesn't always match the next value that will be inserted in the revision table. The revision table uses a sequence to insert the next row. In the case where a record was deleted, max +1 would not equal the next sequence # of the rev_id. It's probably not an issue on a fresh system or one where no deletes have been performed.

shigapov commented 3 years ago

Right! The main focus was indeed on a fresh Wikibase instance, without deleted entities in mind.