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)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 23 Feb 2021 12:07:49 +0000 (13:07 +0100)
commit0a40b4bb509c306794930ef734513a982e418af5
tree54f685366336519a25f2806f176fce931c93e1dc
parent0e0700a691621b2ef1de46fa0ea18ee771daadaf
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>
installer/data/mysql/updatedatabase.pl