[Koha-bugs] [Bug 7872] New: C4::Items GetItemsInfo marc_subfield_structure SQL queries fetch all results and use first row

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7872

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 7872
          Assignee: gmcharlt at gmail.com
           Summary: C4::Items GetItemsInfo marc_subfield_structure SQL
                    queries fetch all results and use first row
        QA Contact: koha.sekjal at gmail.com
          Severity: enhancement
    Classification: Unclassified
                OS: All
          Reporter: dpavlin at rot13.org
          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.