| Metadata | Value |
|---|---|
| Status | Active |
| Version | 1.0.0 |
| Last Updated | 2026-09-10 |
| Author | Sangeetha Grantha Team |
| Document Type | Evidence record |
[!NOTE] Historical evidence: results, counts, commands, and observations below belong to the original work described here. The editorial update date is not a new test or corpus verification. For present behavior, use current feature map.
Two targeted improvements to the unified extraction engine (TRACK-064):
EntityResolutionCacheRepository: Replaced racy select-then-update pattern with insert-first-catch-unique-violation (PostgreSQL 23505), using updateReturning for the conflict path. Eliminates race conditions under concurrent extraction workers.
SourceEvidenceTab: Replaced client-side field comparison computation with server-driven useFieldComparison hook. Adds proper loading/error states, simplifying the component and delegating comparison logic to the API.
| File | Change |
|---|---|
EntityResolutionCacheRepository.kt |
Insert-first with ExposedSQLException catch for unique constraint; updateReturning on conflict; new isTypeAndNameUniqueViolation() helper |
SourceEvidenceTab.tsx |
Replaced inline field comparison arrays with useFieldComparison hook; added loading/error/empty states |
Ref: application_documentation/10-implementations/track-064-code-improvements-entity-resolution-field-comparison.md