server
server copied to clipboard
fix: support longer index and table names
Summary
If Oracle is not explicitly disabled by an app we check the table names / key names / column names for legacy Oracle length of max. 30 characters. But since Oracle 12c the limit was increased to 128 characters.
So nowadays we are limited by MySQL / Mariadb and Postgres:
- MySQL / MariaDB: 64 characters
- Postgres: 63 characters
- SQLite: unlimited
- Oracle: 128 characters
This PR adjusts the checks to only check for Oracle specific behavior but limit the name length to 63.
Checklist
- Code is properly formatted
- Sign-off message is added to all commits
- [x] Tests (unit, integration, api and/or acceptance) are included
- [x] Screenshots before/after for front-end changes
- [ ] Documentation (manuals or wiki) has been updated or is not required
- [x] Backports requested where applicable (ex: critical bugfixes)
Oracle 11 is no longer supported. So I rebased this and resolved the conflicts with recent changes of @CarlSchwan regarding support not null boolean values.