Why are missing values not ignored by default?

yes, we agree on that.

I think it got a little lost in the long thread, but I still currently stand by this one: