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.
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:
- Open the routine test configuration.
- On the Compare Results page of the
test configuration, select Compare results of test configuration
runs.
- 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.
- Modify the routine and deploy it on the database.
- 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.