Summary: | Foreign key constraints are case insensitive so can lead to erroneous data input via the API | ||
---|---|---|---|
Product: | Koha | Reporter: | Martin Renvoize (ashimema) <martin.renvoize> |
Component: | REST API | Assignee: | Bugs List <koha-bugs> |
Status: | CONFIRMED --- | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | chloe.zermatten, nick, tomascohen |
Version: | Main | Keywords: | Academy, Hackfest |
Hardware: | All | ||
OS: | All | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: | Circulation function: |
Description
Martin Renvoize (ashimema)
2025-01-28 10:16:51 UTC
I think the only workaround is to force upper case at the API level, which is what the UI does? ```yaml attribute: type: string pattern: "^[A-Z]+$" ``` That seems like a reasonable approach to me :) |