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

David Cook <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #2 from David Cook <[email protected]> ---
It's an interesting idea, but I think that it is incompatible with Bug 26328. 

Explicitly casting to an integer is needed in Bug 26328 because barcode may not
be an integer even in a database with autoBarcode set to "incremental", which
can cause lots of problems.

Hmm one way to solve both Bug 26328 and Bug 27426 could be to use the following
SQL:

SELECT barcode FROM items WHERE CAST(barcode AS unsigned) ORDER BY CAST(barcode
AS unsigned) DESC LIMIT 1;

It's an ugly bit of SQL but it should work.

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to