https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15877
Bug ID: 15877
Summary: C4::Barcodes does not correctly calculate db_max for
'annual' barcodes
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
The SQL query to find the database max value for annual barcodes is:
42 my $query = "SELECT max(substring_index(barcode,'-',-1)) AS
chunk,barcode FROM items WHERE barcode LIKE ? GROUP BY barcode";
43 # FIXME: unreasonably expensive query on large datasets
The 'max' in the first column creates confusion and disrupts the normal pairing
of the db.
To recreate:
1 - Add two 'annual' type barcodes to the system (2016-0003, 2016-0006)
2 - Run the query:
SELECT max(substring_index(barcode,'-',-1)) AS chunk,barcode FROM items WHERE
barcode LIKE '2016-%' GROUP BY barcode
3 - Note that returned values may not pair up, in my case I got things like:
chunk | barcode
0006 | 2016-0003
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://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/
