http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7872
Priority: P5 - low
Change sponsored?: ---
Bug ID: 7872
Assignee: [email protected]
Summary: C4::Items GetItemsInfo marc_subfield_structure SQL
queries fetch all results and use first row
QA Contact: [email protected]
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: NEW
Version: master
Component: MARC Authority data support
Product: Koha
There are two queries without any WHERE which return more than one row, but use
just first one (since they don't have order which one will be returned is
database dependent).
SELECT authorised_value
FROM marc_subfield_structure
WHERE kohafield="items.notforloan"
SELECT authorised_value
FROM marc_subfield_structure
WHERE kohafield="items.restricted"
--
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/
