https://bugzilla.wikimedia.org/show_bug.cgi?id=18104

Aryeh Gregor <simetrical+wikib...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |simetrical+wikib...@gmail.c
                   |                            |om

--- Comment #10 from Aryeh Gregor <simetrical+wikib...@gmail.com> 2010-02-06 
23:55:27 UTC ---
(In reply to comment #7)
> (The
> explanation for the other 185 k isn't clear. Delete/restore activity on old
> revisions??) 

AUTOINCREMENT columns aren't guaranteed to be allocated sequentially; values
can be skipped.  In particular, if a transaction inserts a row, then gets
rolled back rather than committed, there will be a gap, since the id is
assigned at insert time and not at commit time.  Autoincrementing is visible
immediately, even across transaction boundaries -- which would be a violation
of transactional semantics if id's were guaranteed to be sequential, but they
aren't.

(This probably doesn't account for *that* many missing revisions, though.)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are watching all bug changes.

_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to