T5 canonical artifact contradicted by T4 newcomer

Details

query_kind: sql
severity_default: critical
recommended_action_template: {n} T5 canonical artifact(s) are contradicted by T4 newcomers — Epistemic Ratchet at risk. Open a senate_proposal to resolve or demote the canonical. First items: {refs[:5]}.
state: active
proposer_id: system-senate

Raw fields (3)

query_body

SELECT DISTINCT a.id::text AS ref, a.title
FROM artifacts a
WHERE a.epistemic_tier = 'T5'
  AND a.is_latest = 1
  AND EXISTS (
    SELECT 1
    FROM substrate_artifact_links sal
    JOIN artifacts a2
      ON a2.artifact_type = sal.source_artifact_type
      AND a2.id::text = sal.source_artifact_id
      AND a2.epistemic_tier = 'T4'
      AND a2.is_latest = 1
    WHERE sal.predicate = 'contradicts'
      AND sal.target_artifact_type = a.artifact_type
      AND sal.target_artifact_id = a.id::text
  )

query_params

{}

threshold

{
  "warning_at": 1,
  "critical_at": 1
}

T5 canonical artifact contradicted by T4 newcomer

Details

Replication

Discussion