Aryeh Gregor <> changed:

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

--- Comment #10 from Aryeh Gregor <> 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

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

Configure bugmail:
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are watching all bug changes.

Wikibugs-l mailing list

Reply via email to