]> git.koha-community.org Git - koha.git/commit
Bug 29138: (QA follow-up) Changes to UPDATE
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Fri, 8 Oct 2021 06:30:13 +0000 (06:30 +0000)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 12 Oct 2021 08:52:44 +0000 (10:52 +0200)
commitbfb403dfb4454f7ae5a17738c0a3e0000ae853b2
treeb0985461cc7d51dbf684ca911495621412f565a5
parent701bce97f5791b837a386e16deb7c685171cdb87
Bug 29138: (QA follow-up) Changes to UPDATE

Move the condition to the WHERE clause, using COALESCE to
prevent mysqlism (IFNULL) and strings for strict SQL.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Tested on NULL, 0, 1, 2, no, yes. (2 and yes become 0 too. Fine.)
Tested strict sql mode: no truncated incorrect DOUBLE value-error anymore.

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
installer/data/mysql/atomicupdate/Bug_29138.pl