Issue Bug Closed

#80763New hash version in ReferenceIndex can cause non-unique keys

Morton Jonuschat 04/08/17, 22:32 updated 10/02/18, 11:00

Description

The new hash version in ReferenceIndex ignores the sorting field. The updater in the install tool fails when the reference index currently has two distinct hashes for the same field which only differ in the sorting column. With the new hash calculation this will result in an identical hash, leading to unique constraint failures as the hash field is the primary key of the sys_refindex table.

These duplicate keys can be identified programmatically and should be cleaned up prior to modifying the hash values.

Reviews 1