[TYPO3-core] RFC #4466: Index on tx_realurl_uniqalias breaks with DBAL

[Xavier Perseguers]

Hi,

This is a SVN patch request with unit test.

Type: Gremlin bugfix

Branches: trunk

BT reference: http://bugs.typo3.org/view.php?id=4466

Problem:
SQL parser is not able to parse length restriction on indexes (KEY) of 
CREATE TABLE statements.

Typically, this cannot be parsed by Core SQL parser:

KEY bk_realurl02 (tablename,field_alias,field_id,value_alias(230),expire)

Solution:
As proposed in the bugtracker, drop this statement when using DBAL.

Patch 4466_core.diff has to be applied to Core, 4466_dbal-unittest.diff 
contains a unit test (to be committed from DBAL directory if you want to 
test it). I propose to keep DBAL-related unit tests within DBAL as there 
is already many tests available and they are used by DBAL.

-- 
Xavier Perseguers
DBAL Leader

http://forge.typo3.org/projects/show/extension-dbal
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 4466_dbal-unittest.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20091117/2b974e6e/attachment.asc>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 4466_core.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20091117/2b974e6e/attachment.txt>