Bug 1728 – Reduce DB object names for compatibility with alternative DBMSs

Bug 1728 - Reduce DB object names for compatibility with alternative DBMSs

Summary:

Reduce DB object names for compatibility with alternative DBMSs

Status:	NEW

Product:	OJS
Classification:	Unclassified
Component:	General
Version:	2.x
Platform:	All All

Importance:	P3 enhancement
Assigned To:	PKP Support

URL:

Depends on:	2287
Blocks:
	Show dependency tree / graph

Reported:	2005-07-16 00:31 PDT by Kevin Jamieson
Modified:	2009-01-05 16:08 PST (History)
CC List:	0 users

See Also:
Version Reported In:
Also Affects:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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.