Regression Testing

Regression testing protects against introducing bugs when refactoring code. In SQL, we refactor queries, either because the calling application code is changed and the query must change too, or because we’re hitting problems in production and a new optimized version of the query is being checked in to replace the previous erroneous version.

Regression testing registers the expected results from our queries and then checks actual results against the expected results. ...