Bug 8367: Make database update idempotent (across different MariaDB versions)
authorDavid Cook <dcook@prosentient.com.au>
Tue, 21 Sep 2021 05:21:42 +0000 (05:21 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Wed, 1 Nov 2023 21:01:31 +0000 (18:01 -0300)
commit015fb672c52daf28bb14ae51fd2bbb2637635c96
tree76c3a0fe7174bdd21f4478ce132c048415329f55
parentea68ea1e4c958c67b9f3d3623e2951379abaddae
Bug 8367: Make database update idempotent (across different MariaDB versions)

The previous query seemed to work on MariaDB 10.1.48 (used by koha-testing-docker),
but it didn't work on MariaDB 10.3.29 (default in Debian 10 as of this writing),
but this patched query works on both indempotently.

Signed-off-by: Emmi Takkinen <emmi.takkinen@koha-suomi.fi>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Kelly <kelly@bywatersolutions.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Kelly <kelly@bywatersolutions.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/bug_8367-add_holds_pickup_period_circrule.perl