Contains one row for each available Unit Test in the database.

This table is used by test runners.

To update the list of available tests run DBTD_REFRESH_TESTSLIST framework procedure.

Column Name Data Type Description
Owner VARCHAR(128) Unit Test Owner
TestName VARCHAR(128) Unit Test stored procedure name
Suite VARCHAR(128) Unit Test Suite
HasSetup

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

Have setup procedure:
  1 - SQL Server value
  TRUE - Netezza value
  Y - Oracle value

Do not have setup procedure:
  0 - SQL Server value
  FALSE - Netezza value
  N - Oracle value

HasTeardown

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

Have teardown procedure:
  1 - SQL Server value
  TRUE - Netezza value
  Y - Oracle value

Do not have teardown procedure:
  0 - SQL Server value
  FALSE - Netezza value
  N - Oracle value

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

Test runner will ignore this test:
  1 - SQL Server value
  TRUE - Netezza value
  Y - Oracle value

Test runner will run this test:
  0 - SQL Server value
  FALSE - Netezza value
  N - Oracle value

IgnoreReason

VARCHAR(500) (Netteza and SQL Server)

VARCHAR2(500) (Oracle)

The reason why this test is ignored by framework.
UseTransaction BIT (SQL Server)
BOOLEAN (Netezza)
CHAR(1) (Oracle)

Test runner will wrap test execution in to a transaction and will rollback transaction at the end of the test execution:
  1 - SQL Server value
  TRUE - Netezza value
  Y - Oracle value

Test runner will NOT wrap test execution in to a transaction and will NOT rollback transaction at the end of the test execution:
  0 - SQL Server value
  FALSE - Netezza value
  N - Oracle value

 

In case when column value is set to NULL the Test Runner will use (or will not NOT use)  transaction base on its own discretion.

Note: This column is reserved in Netezza, because Netezza does not support transactions 

SuiteSetupName VARCHAR(128) Name of the suite setup stored procedure
SuiteTeardownName VARCHAR(128) Name of the suite teardown stored procedure
SuiteSetupRunOnce BIT (SQL Server)
BOOLEAN (Netezza)
CHAR(1) (Oracle)

Test runner will run setup stored procedure only once for the suite:
  1 - SQL Server value
  TRUE - Netezza value
  Y - Oracle value

Test runner will run setup stored before every unit test in the suite:
  0 - SQL Server value
  FALSE - Netezza value
  N - Oracle value

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

Test runner will run teardown stored procedure only once for the suite:
  1 - SQL Server value
  TRUE - Netezza value
  Y - Oracle value

Test runner will run teardown stored before every unit test in the suite:
  0 - SQL Server value
  FALSE - Netezza value
  N - Oracle value

CompatibilityLevel INT Unit tests compatibility level as identified by framework when parsing stored procedure

 

See Also