tSQLt_Example.AcceleratorTests 1 fails

Anonymous
2011-12-02
2013-04-29

  • 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
    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