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

Xavier Perseguers typo3 at perseguers.ch
Sun Jun 21 08:50:26 CEST 2009


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