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

[Xavier Perseguers]

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
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 11023.diff
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20090503/db5f0354/attachment.txt