[Bug] Editing an object and changing the id field results in a new item being created

[GitBytes]

Pacifica Metadata Management version

v0.2.0

Platform Details

Google Chrome 76.0.3809.100 (Official Build) (64-bit)

Scenario:

Trying to correct a mistyped id in the instruments table but this also occurs on other tables like users for example.

Steps to Reproduce:

Create a new entry, save new entry, open entry just created, alter id, save, validate old id no longer exists but the new one does.

Expected Result:

It should alter the id and replace the old entry with the new entry.

Actual Result:

A new item is created, old item is left in place unchanged.

Granted this may have some additional implications to cascading changes if the entry was created in the past and is now being edited with other relationships in place. It is also possible based on this comment it may be working as intended and just needs to be a documented behavior. I am up for some discussion here. Thanks,