Ticket #1052 (closed defect: invalid)
db.create_table generates index name too long for mysql
|Reported by:||fexcoffi@…||Owned by:||andrew|
Issue does not exist on 0.5:
CREATE INDEX management_system_named_system_group_systems_namedsystemgroup_i ON management_system_named_system_group_systems (namedsystemgroup_id)
_mysql_exceptions.OperationalError?: (1059, "Identifier name 'management_system_named_system_group_systems_groupsysteminstance_id' is too long")
django ran into similar issue in the past https://code.djangoproject.com/ticket/1820
I ran into that issue converting script from 0.5 with M2M:
when generating index name, it concatenates all the names - resulting in a name too long for mysql to handle.
I did a syncdb to see what django (1.1.4) did and it did not even bother generating an index, so no help there. As we are talking about index names here, I don't think we really care on the name as long as it is unique.... so maybe the hash suggestion in the django ticket might sufice.