-
Improvement
-
Resolution: Unresolved
-
Normal
-
None
-
None
-
None
-
None
Every time we update an entity that just uses the Role::InsertUpdateDelete 'update' method, we update every column we pass to it. At the very least attribute edits (such as entity types) pass all form values to this update, whether they have changed or not, so that a change of, say, only description will result on an update call like:
UPDATE release_group_secondary_type SET parent = ?, child_order = ?, name = ?, description = ? WHERE id = ?
This is probably the simplest option, but it's causing issues in SIR (e.g. SEARCH-669), because the smart triggers in https://github.com/metabrainz/sir/blob/master/sql/CreateTriggers.sql which do "AFTER UPDATE OF gid, name" get triggered anyway by us updating the unchanged name every time.
- has related issue
-
SEARCH-609 SIR triggers do not work as intended when running a MusicBrainz Slave instance
- Closed
-
SEARCH-669 Indexer hanging on type description update
- Closed