On 8/10/09 9:28 AM, Aaron L Halfaker wrote:
I'm using data from a snapshot of the English
Wikipedia and would like
to run a query similar to the following:
SELECT * FROM revision
WHERE rev_id> some_rev_id;
Can I be confident that all revisions returned were saved after some_rev_id?
Yes, in the sense that they were added to the database afterwards.
No, in the sense that rev_timestamp may not always show a later date for
a later rev_id:
* Page histories imported from pre-conversion UseModWiki archives
* Anything imported via Special:Import
* Anything undeleted before ar_rev_id column was added
* Anything saved on a server that had a mis-configured clock
-- brion