Removing leading zeros collapsed distinct identities
A 2019 migration rehearsal reduced 1,240 text identifiers to 1,192 unique numeric keys. Forty-eight pairs, affecting 96 identifiers, collided. We stopped before production cutover, retained the original identifiers and spent ₹36 lakh on rework, delaying the programme by six weeks.
