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

Xavier Perseguers typo3 at perseguers.ch
Sun Jun 14 00:20:59 CEST 2009


Hi,

Nothing more than REMINDER #4

Regards


Xavier Perseguers wrote:
> Hi,
> 
> REMINDER #3
> 
> 
> Xavier Perseguers wrote:
>> Hi,
>>
>> This is a SVN patch request.
>>
>> Type: Bugfix
>>
>> Branches: trunk
>>
>> BT reference: http://bugs.typo3.org/view.php?id=11023
>>
>> 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)
>>
> 
> 


-- 
Xavier Perseguers
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away


More information about the TYPO3-team-core mailing list