safe-global / safe-decoder-service / 26812265656

91%

push

github

Replace 4-byte MD5 abi_hash with PostgreSQL SHA-256 generated column (#266)

The old get_md5_abi_hash truncated MD5 to 4 bytes, giving ~50% collision probability at 65k rows. The new abi_hash column is GENERATED ALWAYS AS (sha256(abi_json::jsonb::text::bytea)) STORED so PostgreSQL owns both the computation and the uniqueness guarantee. JSONB normalisation makes the hash stable regardless of key insertion order.

Python no longer computes or stores the hash; get_or_create_abi uses the IntegrityError try/catch pattern for concurrent-safe upserts, and get_abi uses a JSONB equality query for key-order-independent lookup.

Fixes PLA-1301

20 of 22 new or added lines in 2 files covered. (90.91%)

1321 of 1444 relevant lines covered (91.48%)

0.91 hits per line