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

Xavier Perseguers typo3 at perseguers.ch
Sun Jun 28 11:35:16 CEST 2009


Hi,

REMINDER #6



Xavier Perseguers wrote:
> Hi,
> 
> REMINDER #5
> 
> Regards
> 
> Xavier Perseguers wrote:
>> 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