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).
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).