I encountered a situation where I've renamed a column, but was unaware that my views were still referencing the column by the old name.
This broke my web app, and I pushed these changes to my production server, thus learning the importance of a test suite.
I'm new to testing, so, I'm wondering: how I can catch problems caused by this kind of scenario?