Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 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 do some stats for the 'critical mass' question I ran into some logic errors in the data dump that made generating the statistics impossible. I'm not sure if the errors are on my end or not, so simply telling me whether or not you get the same results would be helpful.

The following are the errors I found (which may or may not actually exist):

View count is an attribute of Questions, not answers - 5 Results.

FROM posts 
WHERE ViewCount !=0
AND PostTypeId =2

Post was edited before it was created - 4 results.

FROM posts
WHERE LastEditDate < CreationDate
AND LastEditDate !=0
AND CreationDate !=0

An answer contains tags - 1 result

FROM posts
WHERE Tags != ""
AND PostTypeId =2

Answer was created before its question - 93 results

FROM posts v1
JOIN posts v2 ON ( v1.ParentId = v2.Id ) 
WHERE v1.CreationDate < v2.CreationDate

Comments created before before a post - 47 results

FROM comments
LEFT JOIN posts ON ( comments.PostId = posts.Id ) 
WHERE comments.CreationDate < posts.CreationDate

Additionally, simply for completion, OwnerId="" when users have been deleted. This issue has already been resolved and will be removed from subsequent dumps.

The error that actually stemmed this post was

FROM votes
LEFT JOIN posts ON ( votes.PostId = posts.Id ) 
WHERE votes.CreationDate < posts.CreationDate

but I have since remembered that the original vote table has dates rounded down to the nearest day.

share|improve this question
I get nada on StatOverflow. You nuke it? I wanted to see who was psychic. I mean, there are obvious candidates, but it piqued my interest. – Eric Jul 29 '09 at 2:27
I'm migrating the server but I don't want to carry over all the errors if they're on my end since it's a considerable amount of IO. – Ian Elliott Jul 29 '09 at 2:31

You must log in to answer this question.

Browse other questions tagged .