[TYPO3-dam-devel] FYI72 #17583: ALTER TABLE fails during update of tx_dam

[Dan Osipov]

Makes sense to me. I think it was limited size for performance reasons, 
since the paths can get long.

On 2/23/11 7:19 PM, Lorenz Ulrich wrote:
> Hi folks,
>
> this is an SVN patch request.
>
> Type: Bugfix, no-brainer
>
> Bugtracker reference: http://bugs.typo3.org/view.php?id=17583
>
> Branches: trunk
>
> Problem:
> The table setup for DAM contains a key for file_name with a limited lenght:
>
> KEY file_name (file_name(32))
>
> This was introduced in <http://bugs.typo3.org/view.php?id=14434> because
> this field had type TEXT in ancient times and if a TEXT type field is
> used in key a lenght needs to be specified.
>
> For DBAL compatibility the field was changed to VARCHAR in
> <http://bugs.typo3.org/view.php?id=12525>.
>
> Now that they're VARCHAR (and so there's no need to limit key lenght)
> and DBAL is unable to handle keys with limited lenght (according to
> Xavier Perseguers):
>
> Solution:
> Remove key lenght.
>
>
>
> Report and patch is from Tobias Schaefer. I will commit this as a
> no-brainer if there are no objections within 72 hours.
>
>
>
> Best regards,
>
>
> Lorenz

-- 
Dan Osipov
http://danosipov.com/blog