TYPO3 Core

I agree that 40 characters are too short, especially when using IRRE-relations. So i made a patch which increase it to 64 chars

Yepp, 64 chars look like this (which should be enough):
tx_mywhatever_firstbaseobjectsuperxx_secondbaseobjectsuperyy_rel

Oliver, really I had relation between another relation table and entity so relation table name looks like tx_mywhatever_firststuff_secondstaff_rel_thirdstuff_rel
however 64 should be enough ;)

Committed to SVN Trunk (rev. 4395)

This leads to a problem as reported in #20867: The index "lookup_string" of sys_refindex consists of "ref_table" and "ref_string".

Before this change, the size of the index was (40 (ref_table) + 200 (ref_string)) * 3 (because of UTF-8) = 720 bytes.
After the change, the size is (255 (ref_table) + 200 (ref_string) ) * 3 (UTF-8) = 1365 bytes.

However, indexes must not exceed 1000 bytes, so this one is now too long, and the table can't be created any more.

Solutions to the problem:
1. Restrict index length. Works, and was used until rev. 5694. However, it does not work with DBAL apparantly. So if we come back to this solution, DBAL must be fixed in some way to cope with this.
2. Shrink the field size again. The maximum af 255 was just a wild guess I would say. The maximum which is possible without modiying the index is 133 (because (133+200)*3 = 999 bytes). Is this length also acceptable for table names?
3. Remove the index completely. Wise idea?
4. Revert this change.

For now I won't apply any changes but if nobody fixes this, I would probably choose option 4.

- michael

Solution leads to new problems.

the solution for the follow-up problem of this bug is in #0011694
(index too long on utf-8 databases)
The problem with the too short table names in branches 4_2 and 4_1 still needs to be fixed and the indizes must be changed accordingly.

committed #0011694 to trunk.
So the problem is fixed in trunk since rev 6166

I keep this bug open because the fix is still missing in the older branches