[Koha-bugs] [Bug 34678] Concurrent changes to the holds can fail due to primary key constraints

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34678

--- Comment #6 from Kyle M Hall <kyle at bywatersolutions.com> ---
(In reply to Marcel de Rooy from comment #5)
> Should we use a MySQL extension like REPLACE ?

It appears that MERGE is the closest SQL standard keyword with the same
functionality. However, MySQL/MariaDB doesn't support it. There is also no DBIC
alternative to use as universal fix.

The alternative would be to run a delete query with the insert as a
transaction. That feels rather clunky and inefficient to simply avoid a
specific use of this keyword.

-- 
You are receiving this mail because:
You are watching all bug changes.