• Hi Alex,

    When it comes to testing, I prefer to apply mathematical proof methodologies over Occam. One anecdote about a logic test goes something like this:

    Given: The pencil can move from the chair to the floor. Start by holding the pencil over the floor. How do you get the pencil to the floor?

    The answer is "Place the pencil on the chair." We all know if we drop the pencil it will fall to the floor, but this isn't about what we all know; it's about proving what we all know.

    So no, I respectfully disagree. I understand the tediousness of the code and appreciate that it will not appeal to everyone who reads this article. And I'm fine with you and others dsagreeing, but I maintain this is a viable and useful means to approach test-driven database development.

    :{>

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics