PKP Bugzilla – Bug 1728
Reduce DB object names for compatibility with alternative DBMSs
Last modified: 2013-05-29 14:50:37 PDT
We are moving to Git Issues for bug tracking in future releases. During transition, content will be in both tools. If you'd like to file a new bug, please create an issue.
"The main stumbling block I'm coming across is Oracle's object name length
limit. MySQL's is 64 characters (I think), while Oracle's is 30. This includes
column, table, sequence, index and trigger names."
This would probably also require some modifications to the upgrade framework to
support DBMS-independent RENAMEs via ADOdb's data dictionary.
This will require a considerable rewrite of SQL queries to pull table names from variables.
Haven't heard of this in years -- suspect shaving bytes just isn't as popular as it used to be.