[Koha-bugs] [Bug 26328] incremental barcode generation fails when incorrectly converting strings to numbers

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26328 --- Comment #6 from Pablo AB <pablo.bianchi@gmail.com> --- (In reply to David Cook from comment #4)

I actually ran into this problem again today, and at the moment the query I like best is actually the following:

SELECT max(cast(barcode as unsigned)) from items;

Why you like the most this one (except for the ABS identical to my first suggestion), instead of your alternative con comment 1? I remember that at the time your suggestion seems better. -- You are receiving this mail because: You are watching all bug changes.