[Koha-bugs] [Bug 31740] New: Illrequests table has a foreign key constraint on status_alias

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

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

            Bug ID: 31740
           Summary: Illrequests table has a foreign  key constraint on
                    status_alias
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

I am not sure the intent of this foreign key, however it seems problematic as
we can't tie it to a single category

To test:
1 - Add an authorised value for Asort1:
    Authorised value: MONKEY
    Description: Capuchin
2 - Add an authroised value for LOC:
    Authorised value: MONKEY
    Description: Spider
3 - Put an illrequest in the DB:
    INSERT INTO illrequests (branchcode,status,status_alias) VALUES
('CPL','REQUEST_TEST','MONKEY')
4 - Delete one of the authorised values above
5 - Check the DB:
    SELECT status_alias FROM illrequests WHERE status = 'REQUEST_TEST'
6 - Note the status is nulled by deletion of unrelated authroised value

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