[ http://issues.apache.org/jira/browse/JCR-278?page=all ] Stefan Guggisberg closed JCR-278: ---------------------------------
Fix Version: 1.0 Resolution: Fixed now that's what i call a fast coding-testing cycle :) thanks roy, fixed as suggested (r348455). > 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 > Fix For: 1.0 > > 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