[jira] [Created] (JCR-2970) An error will rise using extremely long workspace names (longer than 500 characters)

["emiliano albiani (JIRA)" <ji...@apache.org>]

An error will rise using extremely long workspace names (longer than 500 characters)
------------------------------------------------------------------------------------

                 Key: JCR-2970
                 URL: https://issues.apache.org/jira/browse/JCR-2970
             Project: Jackrabbit Content Repository
          Issue Type: Bug
          Components: jackrabbit-core
    Affects Versions: 2.2.5
         Environment: Microsoft SQL Server
            Reporter: emiliano albiani
            Priority: Trivial


The SQL script:
create unique index ${schemaObjectPrefix}FSENTRY_IDX on ${schemaObjectPrefix}FSENTRY (FSENTRY_PATH, FSENTRY_NAME) ${tableSpace},

creates an index on FSENTRY_PATH which is a column of the table created by the script:
create table ${schemaObjectPrefix}FSENTRY (FSENTRY_PATH varchar(2048) not null, FSENTRY_NAME varchar(255) not null, FSENTRY_DATA image null, FSENTRY_LASTMOD bigint not null, FSENTRY_LENGTH bigint not null) ${tableSpace}.

The FSENTRY_PATH column size exceed the maximum size of index keys (http://msdn.microsoft.com/en-us/library/aa224343%28v=sql.80%29.aspx).


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira