Contains one row for each Unit Test run by the framework. Stores latest result information for a given test.

Unlike DBTD_TBL_TESTSLIST table, which has information about currently available unit tests, DBTD_TBL_TESTRESULT table has currently available unit tests information together with old unit tests that do not exist in the database any longer or those that have failed long time ago.

Use StartTime and StopTime columns to check when test was last ran.

Column Name Data Type Description
TestName VARCHAR(128) Unit Test Name
Owner VARCHAR(128) Unit Test Owner
RunCount INT Number of times this unit test have run
StartTime DATETIME Last time when test runner have started the test
StopTime DATETIME Last time when unit test finished
IsError

BIT (SQL Server)
BOOLEAN (Netezza)
Char(1) (Oracle)

There was an error during the Unit Test run:
  1 - SQL Server value
  TRUE - Netezza value
  Y - Oracle value

Unit Test run without errors:
  0 - SQL Server value
  FALSE - Netezza value
  N - Oracle value

IsFailure

BIT (SQL Server)
BOOLEAN (Netezza)
CHAR(1) (Oracle)

Unit Test failed:
  1 - SQL Server value
  TRUE - Netezza value
  Y - Oracle value

Unit Test had no failures during last run:
  0 - SQL Server value
  FALSE - Netezza value
  N - Oracle value

Status VARCHAR(50)

STARTED - Unit Test has been started by test runner
SUCCESS - Unit Test finished successfully
ERROR - Unit Test failed with an error
IGNORED - Unit Test has bee ignored

Message NVARCHAR(MAX) - SQL Server
NVARCHAR(4000) - Netezza

NVARCHAR2(2000) - Oracle
Message, which includes stack trace where available. This column will have basic information, the detailed information can be found in the DBTD_TBL_LOG table  

 

See Also