Bug 34684: Prevent 220600007.pl to fail if run twice
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 31 Aug 2023 15:05:57 +0000 (17:05 +0200)
committerTomas Cohen Arazi <tomascohen@theke.io>
Wed, 6 Sep 2023 18:05:20 +0000 (15:05 -0300)
commit027e1e18620e3c790e85ea49b3870f9ee7785871
tree97198d55bc45b3d3588d195755c5c5ced6ca6a8f
parent9bb23b7d5e3606dad6e9b3976c3a1fad1cc2087a
Bug 34684: Prevent 220600007.pl to fail if run twice

The error is
  ERROR 1292 (22007): Truncated incorrect DECIMAL value: 'no'

Happens on MariaDB 10.5.22, not MySQL 8

Test plan:
update systempreferences set value="0" where variable="DisplayClearScreenButton";
play installer/data/mysql/db_revs/220600007.pl
select value from systempreferences where variable="DisplayClearScreenButton";
=> "no"

update systempreferences set value="1" where variable="DisplayClearScreenButton";
play installer/data/mysql/db_revs/220600007.pl
select value from systempreferences where variable="DisplayClearScreenButton";
=> "issueslip"

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/db_revs/220600007.pl