jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Roy Russo (JIRA)" <j...@apache.org>
Subject [jira] Created: (JCR-278) DBFileSystem MySQL DDL not compatible with pre-5.0 versions
Date Wed, 23 Nov 2005 14:33:36 GMT
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


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


Mime
View raw message