In Data Explorer, looking through some SO data, I noticed that some comments have 0 for Score, while others are null. Why is this? Is there a difference between 0 and null comment scores?

  • 4
    I guess the null ones were never upvoted, and the 0 ones were upvoted then the votes retreated... Mar 2, 2014 at 23:17
  • @MeNoTalk Ohh, maybe. That makes sense.
    – Jason C
    Mar 2, 2014 at 23:18
  • 4
    Not a duplicate of meta.stackexchange.com/q/210595/223030 - that question talks about comment counts on posts, this one's about scores of individual comments. Mar 3, 2014 at 1:03
  • 1
    You must know that one of the new task Twilight was given after becoming a princess was to manage the stack servers dbs. As you may expect she is very diligent and always marks comments with zero votes as "0" - after all mathematic isn't an opinion, isn't it?. Problems started to arise when that lazy pegasi friend of her started helping in the weekend. With the official explanation that "Now the data are 20% cooler" she started to leave null valued field to be faster...
    – SPArcheon
    Oct 1, 2014 at 14:25
  • 1
    Null is just a very low value of zero, it makes sense to me.
    – user50049
    Oct 1, 2014 at 14:38

1 Answer 1


Similar to the answer given here by Catija, Comments that received an upvote that was later retracted have a Score of 0, whereas Comments that never received any upvotes are inserted into the table with a Score of NULL.

Also similar to favorites (even less useful, I'd argue), not much can be read into this information, as someone could've upvoted by accident and then simply removed it right after, or changed their mind about the upvote for any reason.

Especially considering that the timeframe you have to remove upvotes is small.


You must log in to answer this question.

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