Anonymous
2011-12-02
I installed the Red Gate SQL Test thing and enabled CLR and installed the sample database and hit the Run Tests button. Most tests are green. The first one, fails. I read the test procedure, and it seems to me it should pass. Any hints on how I can diagnose the failure?
Anonymous
2011-12-02
Oh, the test procedure would seem to fake the particle table, then add two particles, then call the function for ready, which is just returning a 1 if there is more than 1 particle. The fail message says that it expected a 1 but got a 0. It would seem like no particles were inserted into the table.
Any help reasoning about this is appreciated.
Dennis Lloyd Jr
2011-12-03
Thank you for giving SQL Test and tSQLt a try!
There is one test intended to fail, please see: http://tsqlt.org/after-running-the-examples-smss/ for details about debugging and correcting the failing test.
-Dennis