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.

Bug 1728 - Reduce DB object names for compatibility with alternative DBMSs
Reduce DB object names for compatibility with alternative DBMSs
Product: OJS
Classification: Unclassified
Component: General
All All
: P3 enhancement
Assigned To: PKP Support
Depends on: 2287
  Show dependency treegraph
Reported: 2005-07-16 00:31 PDT by Kevin Jamieson
Modified: 2013-05-29 14:50 PDT (History)
1 user (show)

See Also:
Version Reported In:
Also Affects:


Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Jamieson 2005-07-16 00:31:10 PDT
Worth considering:

"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.
Comment 1 Alec Smecher 2009-01-05 16:08:57 PST
This will require a considerable rewrite of SQL queries to pull table names from variables.
Comment 2 Alec Smecher 2013-05-29 14:50:37 PDT
Haven't heard of this in years -- suspect shaving bytes just isn't as popular as it used to be.