Google Cloud's outage wasn't a testing failure but a design flaw
ebellani.github.io
ebellani.github.io
Formal verification is a relatively unexplored idea in the industry, but it's something that seems to be used to verify protocols or algorithms rather than implementation code. If anyone is using formal verification in their systems, I would love to hear some experiences.
In this case in particular, having a 'not null' directive on the table at hand would have suffice. And that is something everyone can do.
You are assuming tech is business governed by rational decision makers.
And yes, it is that easy.