]> git.koha-community.org Git - koha.git/commit
Bug 28854: (QA follow-up) Fix DB revision for AV's above 10
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 11 Jul 2022 15:18:25 +0000 (16:18 +0100)
committerTomas Cohen Arazi <tomascohen@theke.io>
Wed, 13 Jul 2022 13:36:15 +0000 (10:36 -0300)
commitdb48209356ed2118c1b18b09cf237500da5bd234
treed0a9242c17e5a1726afe0f3c6d1708392ef2862f
parentf22a40b8bab3f6896ab73100802f2bf42efbd09d
Bug 28854: (QA follow-up) Fix DB revision for AV's above 10

The authorised_value field is a varchar and so 'MAX' will sort '9' above
'10' and cause issues if you have more than 9 AV values already for LOST
or NOT_LOAN.

This patch adds a 'CAST' to the field so we can use MAX correctly.

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/bug_28854.pl