count(id) on Char(0) column does not work!
COUNT(somecolumn) ignores NULLs
COUNT(*) won't


You can see this with

SELECT count(id),count(*) FROM test WHERE id IS NULL


Coincidently, all aggregate functions ignore NULL except COUNT(*)