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