Bug 1728 - Reduce DB object names for compatibility with alternative DBMSs
Reduce DB object names for compatibility with alternative DBMSs
Status: RESOLVED WONTFIX
Product: OJS
Classification: Unclassified
Component: General
2.x
All All
: P3 enhancement
Assigned To: PKP Support
Depends on: 2287
Blocks:
  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:


Attachments

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.