1 Sep
2020
1 Sep
'20
2:55 a.m.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26328 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #1 from David Cook <dcook@prosentient.com.au> --- That's an interesting one. Your suggestion returns a value of 9223372036854775807. I would say that is an undesirable outcome as well. It's probably better to use something like this: SELECT MAX(ABS(barcode)) FROM items WHERE barcode REGEXP '^[0-9]+$'; -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.