[ http://issues.apache.org/jira/browse/JCR-278?page=all ]
Stefan Guggisberg reassigned JCR-278:
-------------------------------------
Assign To: Stefan Guggisberg
> DBFileSystem MySQL DDL not compatible with pre-5.0 versions
> -----------------------------------------------------------
>
> Key: JCR-278
> URL: http://issues.apache.org/jira/browse/JCR-278
> Project: Jackrabbit
> Type: Bug
> Components: core
> Versions: 1.0
> Reporter: Roy Russo
> Assignee: Stefan Guggisberg
>
> The packaged ddl for mysql index sizes is too large for 4.x versions of
> MySQL. As the sum-total of the index sizes may only reach 500.
> So,
> create unique index ${schemaObjectPrefix}FSENTRY_IDX on
> ${schemaObjectPrefix}FSENTRY (FSENTRY_PATH(745), FSENTRY_NAME)
> will not work. I would suggest shortening the FSENTRY_PATH index value to
> 245, as FSENTRY_NAME is already set to 255.
> create unique index ${schemaObjectPrefix}FSENTRY_IDX on
> ${schemaObjectPrefix}FSENTRY (FSENTRY_PATH(245), FSENTRY_NAME)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
