Youre correct, at least in 3e only 0 con kills you outright. All the others just make you comatose or some other state in which you lose control of your character.

But in 5e all 0 attribute states mean you die.