Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 155 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

While trying to examine the distribution of question view counts on Stack Exchange sites, I came across an anomaly - there appear to be questions in the database with NULL ViewCounts. This query I ran on Stack Overflow found a small (but not insignificant) number of questions with this. They all appear to be questions asked between 12.41pm and 12.55pm on 13 January.

SELECT Id AS [Post Link], ViewCount, CreationDate FROM Posts 
WHERE PostTypeId = 1 AND ViewCount IS NULL
ORDER BY CreationDate


These are the last few questions to be imported into the Data Explorer. I'm guessing they got a ViewCount of NULL because their ViewCount is actually zero.

share|improve this question
Which has always confused me. Doesn't the initial viewing of the post on submit = 1? – jcolebrand Jan 30 '13 at 15:00

This appears to have been fixed at some point.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .