server icon indicating copy to clipboard operation
server copied to clipboard

fix: support longer index and table names

Open susnux opened this issue 9 months ago • 1 comments

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

susnux avatar Mar 19 '25 22:03 susnux

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.

susnux avatar Nov 27 '25 17:11 susnux