Two Duplicate Rows in 48 Hours: My Unique Index Treats NULL as a New Value

I shipped a nightly enrichment job with a unique index on (tenant_id, source_hash) and called it...