TYPO3 Core

The SQL parser (from core actually, not DBAL) is not able to parse one of the key creation for table sys_refindex:

1. Table structure for table 'sys_refindex' #
   CREATE TABLE sys_refindex (
   ...
   KEY lookup_string (ref_table(133),ref_string)
   );

The syntax to specify only a given number of characters to be taken for the index is MySQL-specific and furthermore is not supported by t3lib_db parser making it impossible to create this table for, e.g., Oracle from the Install Tool.

Solution: make an index with all 255 characters to be DBMS-agnostic:

KEY lookup_string (ref_table,ref_string)

(issue imported from #M11023)