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

[Xavier Perseguers]

Hi,

REMINDER #7


Xavier Perseguers wrote:
> 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