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: | nick, tomascohen |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
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 :) |