KB-5FCB

Clone SQL B — Scanner Read Path (sha256 4792e3e4…)

2 min read Revision 1
one-roofnonprod-clonesqlscanner-read

-- STEP B — SCANNER READ PATH (CLONE ONLY, READ-ONLY) -- sha256: 4792e3e459615a42c2825a3f7e8030b299d1e60b230239e0bc1a5dbecec73836 -- Proves 100% coverage after Step-A seed. No writes. \pset pager off SELECT count() AS governed_objects FROM v_governance_object_inventory; -- 35 SELECT count() AS containment_edges FROM v_governance_object_containment; -- 35 SELECT object_ref, scope, owner_gov_code, is_inherited_anchor FROM governance_object_ownership WHERE created_by='CLONE_TEST_F6_SEED' ORDER BY object_ref, scope; -- 30 SELECT resolution, count() FROM v_object_effective_owner WHERE owner_kind='accountable' GROUP BY resolution ORDER BY resolution; -- direct 30, inherited 210 WITH cells AS (SELECT (SELECT count() FROM v_governance_object_inventory)(SELECT count() FROM governance_responsibility_scope WHERE status='active') AS total_cells), gap AS (SELECT count() AS gap_cells FROM v_object_owner_gap) SELECT total_cells, gap_cells, (total_cells-gap_cells) AS covered_cells, round(100.0(total_cells-gap_cells)/total_cells,2) AS coverage_pct FROM cells, gap; -- 210/0/210/100.00 SELECT s.scope_code, (SELECT count() FROM v_governance_object_inventory) AS objects, (SELECT count() FROM v_object_owner_gap g WHERE g.scope=s.scope_code) AS gap_in_scope FROM governance_responsibility_scope s WHERE s.status='active' ORDER BY s.scope_code; -- all 0 gap SELECT count(*) AS conflicts FROM v_object_owner_conflict; -- 0 SELECT object_ref, scope, owner_gov_code, resolution, depth, source_anchor_type, source_anchor_ref FROM v_object_effective_owner WHERE owner_kind='accountable' ORDER BY object_ref, scope LIMIT 10; -- RESULT: coverage 100.00%, 30 direct + 210 inherited, conflicts 0 (PASS)

Back to Knowledge Hub knowledge/dev/reports/architecture/one-roof-nonprod-clone-full-coverage-pipeline-2026-06-02/sql/B_scanner_read_path_clone.sql