Bug 26997: CAST AS CHAR to prevent the error
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 19 Feb 2021 09:52:45 +0000 (10:52 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Thu, 25 Feb 2021 09:23:37 +0000 (10:23 +0100)
commit9327130853613d5518326fddcabb1ef153daacbd
tree9df84620adc40df33343f4d3840facff8897f485
parente6aeb00c1059736c535a45d1a551eaa22c20b01f
Bug 26997: CAST AS CHAR to prevent the error

To prevent the DBMS to fail on 0000-00-00 we can cast it as a char and
compare.
This patch also moves to a subroutine, in case we need to adjust (or
reuse) it later.

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 0a40b4bb509c306794930ef734513a982e418af5)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/updatedatabase.pl