Bug 23289: Quote new 'rows' MariaDB reserved word
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Sun, 1 Sep 2019 19:26:02 +0000 (15:26 -0400)
committerFridolin Somers <fridolin.somers@biblibre.com>
Mon, 9 Sep 2019 08:23:26 +0000 (10:23 +0200)
commit9fb3f8d32bfd065fa2e55f1c6a7a94036b84590b
tree688876eb07fad100e30abbce9fe93b6918c00ece
parent6e013cf383f1f23b34e9878a86ea0b945833132f
Bug 23289: Quote new 'rows' MariaDB reserved word

Since MariaDB 10.2.4 rows is a reserved word:
https://mariadb.com/kb/en/library/mariadb-1024-release-notes/

"""
New reserved word: ROWS. This can no longer be used as an identifier
without being quoted.
"""

Test plan:
With MariaDB >= 10.2.4, create a new label template.
Also, prove t/db_dependent/Labels/t_Template.t

Without this patch you will get the following SQL error: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows, creator, template_code, page_height,

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit aede6896dd6ebc660894bcde117ccd213e2c3de6)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
C4/Creators/Template.pm