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

Xavier Perseguers typo3 at perseguers.ch
Tue Nov 17 20:31:00 CET 2009


FYI: Committed unit test to DBAL-trunk (rev. 26654)

Oliver Hader wrote:
> FYI: Committed to SVN Trunk (rev. 6463)
> after my +1 by reading and testing
> 
> olly
> 
> Xavier Perseguers schrieb:
>> 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
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away


More information about the TYPO3-team-core mailing list