projects / koha.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 701bce9) | patch
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
treeb0985461cc7d51dbf684ca911495621412f565a5tree | snapshot
parent701bce97f5791b837a386e16deb7c685171cdb87commit | diff
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 diff | blob | history
Main Koha release repository