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

[Xavier Perseguers]

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