Bug 33584: Fix failures for Commenter.t on MySQL8
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Fri, 21 Apr 2023 17:09:08 +0000 (17:09 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Mon, 24 Apr 2023 15:08:00 +0000 (12:08 -0300)
commit726004a8c14e7e511201eb871e718d21b3a4c35e
tree7d50d57ba52d3b2b5860f7ceaf9614d374b01604
parent7e55cadc04851e885ac4ce692a2b018691f854b4
Bug 33584: Fix failures for Commenter.t on MySQL8

The column names from information_schema are uppercase now in MySQL8.
In the arrayref with sliced hashes, we expected lowercase.

See e.g. https://stackoverflow.com/questions/54538448/what-are-the-changes-in-mysql-8-result-rowset-case

Test plan:
Run t/db_dependent/Koha/Database/Commenter.t
Do it again if possible with a MySQL 8 db server.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Koha/Database/Commenter.pm
t/db_dependent/Koha/Database/Commenter.t