Add regression tests for tenant provisioner system-settings seeding
Table of Contents
This page is a capture in the next bucket of the product backlog — a pre-sprint idea, not yet pulled into a sprint as a story.
What
Add a pgTAP (or equivalent) test that provisions a tenant via
iam_tenant_provisioner_create.sql and asserts every current
system.%-prefixed setting from the system tenant (except
system.bootstrap_mode) lands on the new tenant with the same value,
plus a direct test of
ores_variability_seed_tenant_system_settings_fn in isolation
(covering the party-scoping filter added in PR #1496 review).
Why
There is currently no automated coverage for tenant provisioning at
all in projects/ores.sql/test/, and this is precisely the bug class
being fixed here — a setting silently missing per-tenant. A
regression test would catch a future accidental exclusion
automatically instead of relying on manual "verified live" checks
each time.