Comparing results when running routines with test configurations

Comparing routine output can help validate changes made to routines. When you run a routine with a test configuration, you can compare routine output with the output of a previous run.

Before you begin

Deploy your routine to the database and create a routine test configuration.

About this task

You can specify output from a routine as a baseline or run the routine with a test configuration to create a baseline. After you change a routine and deploy it on the database, you can run the routine with the test configuration. The workbench compares the baseline result output that you specify with the output generated when you run the routine with the test configuration. You can select a baseline result from output in the SQL Results view.

Procedure

To compare result output when running a routine with a test configuration:

  1. Open the routine test configuration.
  2. On the Compare Results page of the test configuration, select Compare results of test configuration runs.
  3. Specify the baseline result for the routine.
    • Click Choose to select a result output from the results that are saved in SQL Results view.
    • Click Clear Baseline Result to remove the listed baseline result. Then run the routine with the test configuration to create a baseline result. When you open the test configuration again, the result output is listed as the baseline result.
    The result output is saved as the baseline result output.
  4. Modify the routine and deploy it on the database.
  5. Run the routine with the test configuration.

    The results of comparing the baseline and test output appears in the SQL Results view.

What to do next

If the output does not match, right-click the output in the Compare Results page and click Compare to compare the output in the Compare editor.

Feedback