Indexes: Generated Identifier Too Long

Description

MySQL allows 64 characters for an index or contraint identifier.
Orcale allows 30 characters for an index or contraint identifier. (NH-48)

These limits are quickly reached in deeper type hierarchies with long names, because the identifiers are fully qualified.

For foreign key contraints the current NHibernate-Version uses a hashcode as identifier to avoid problems with long identifiers. I thing NH should apply the same solution for indexes.

I have made a quick fix in DenormalizedTable::IndexIterator (Attachment).

Environment

None

Attachments

1

Activity

Show:

Details

Assignee

Reporter

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created March 16, 2013 at 10:05 PM
Updated March 16, 2013 at 10:05 PM
Who's Looking?