| 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: | Initiative type: | --- | |
| Sponsorship status: | --- | Crowdfunding goal: | 0 |
| 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 :) |