[Koha-bugs] [Bug 26328] barcode.pl: ValueBuilder::incremental should cast barcode to unsigned integer

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26328

--- Comment #2 from Pablo AB <pablo.bianchi at gmail.com> ---
You are right. On my tests:

SELECT barcode FROM items ORDER BY ABS(CAST(barcode AS UNSIGNED)) DESC LIMIT 5;
  770101E1 → 770101 (CAST on SELECT)

SELECT barcode FROM items ORDER BY ABS(barcode) DESC LIMIT 5;
  85350E65 → 8.535e69 (ABS on SELECT)

Your proposal seems the way to go.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.