If you view the history of a closed question you'll see a notice saying:
Post closed as "[close reason]" by [moderator name or user names of the voters].
- We know moderators can close any question immediately.
- We know a question remains open until it has 5 close votes.
- A close vote is saved in the
How does the revisions page distinguish between:
- A question closed by a mod, that may have only one
close voterow in the
- A question that has 3 or 4
close voteentries, but is yet to be closed
- A question that has 5
close voteentries and is already closed
postHistory table (in the data-dump), which is used in the revisions page, does not tell us if a post has been closed. It simply lists revisions, including those of type 10, or close votes.
So a post may or may not be closed. We don't know by just looking at the postHistory table.
How, then, does the revisions page determine whether to display the
post closed as ... notice when looping over revisions?