https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29138 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #125923|0 |1 is obsolete| | --- Comment #14 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Created attachment 125924 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=125924&action=edit Bug 29138: (QA follow-up) Changes to UPDATE Move the condition to the WHERE clause. 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.) Replaced IFNULL by COALESCE. -- You are receiving this mail because: You are watching all bug changes.