#20386Table sys_refindex cannot be created with DBAL
Description
The SQL parser (from core actually, not DBAL) is not able to parse one of the key creation for table sys_refindex:
#- 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)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.