https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38983 Bug ID: 38983 Summary: Foreign key constraints are case insensitive so can lead to erroneous data input via the API Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: REST API Assignee: koha-bugs@lists.koha-community.org Reporter: martin.renvoize@ptfs-europe.com QA Contact: testopia@bugs.koha-community.org CC: tomascohen@gmail.com This one is fun... You can input randomly cases branchcodes via the API for patrons without receiving an error. This appears to be because sql's foreign key constraints aren't being triggered. This is fine in the database, but as soon as we start returning the data via API javascript is case sensitive in the UI and can crash To replicate, try adding a library with the code `CAPITALS` and then add a user via the API with a library_id of `Capitals`. If you then search for that user, the patron search table will fail to load and you'll get errors in the console. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.