https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29138
Marcel de Rooy <m.de.r...@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #125925|0 |1 is obsolete| | --- Comment #17 from Marcel de Rooy <m.de.r...@rijksmuseum.nl> --- Created attachment 125992 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=125992&action=edit 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.r...@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. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/