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

[Oliver Hader]

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.
-- 
Oliver Hader
TYPO3 Release Manager 4.3