[TYPO3-core] RFC #11023: Table sys_refindex cannot be created with DBAL

[Susanne Moog]

Hi,

Xavier Perseguers schrieb:
 > Problem:
> 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)
> 

the explanations in the thread sound reasonable, so +1 by reading.

Regards,

Susanne

-- 
Susanne Moog
NEUSTA GmbH - www.neusta.de