Issue Bug Closed

#20386Table sys_refindex cannot be created with DBAL

Xavier Perseguers 05/03/09, 08:37 updated 08/06/10, 13:28

Description

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.