Skip to main content

Test suite (DWH)

The Yres data-plane database (IRIS_DWH) ships with a regression test suite that exercises the complete SQL framework: every in-scope object (stored procedures, functions, views and triggers) has exactly one test procedure. Since v1.56 that single procedure exercises multiple scenarios: per object type it walks a fixed matrix — alongside the happy path also empty input, NULL, edge cases, invalid input, missing dependencies and multiple rows at once. In total that amounts to roughly 1655 checks across 195 objects (indicative — the suite grows with each release).

From v1.56 the suite belongs to the database itself: it sits in the DACPAC as the [Test] schema and is therefore installed with every Yres version. There is nothing to install — any environment on the current version already holds every Test.* object. Nothing runs automatically either: the suite only acts when you call one of its procedures yourself.

This page describes how to use the suite.

Certified users only