[Koha-bugs] [Bug 29135] OAI should not include biblionumbers from deleteditems when determining deletedbiblios

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

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

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dcook at prosentient.com.au

--- Comment #1 from David Cook <dcook at prosentient.com.au> ---
Good catch.

I think there's some additional relevant lines lower down in
Koha/OAI/Server/ListBase.pm as well when the max timestamp is fetched. 

$sql = "
    SELECT MAX(timestamp)
    FROM (
        SELECT timestamp FROM deletedbiblio_metadata WHERE biblionumber = ?
        UNION
        SELECT timestamp FROM deleteditems WHERE biblionumber = ?
    ) bis
";

I mean it should be impossible to deleted an item after the bib has been
deleted. But this SQL would return a timestamp where there is a deleted item
but not a deleted bib.

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