You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "Mads Orehøj Sørensen (Created JIRA)" <je...@portals.apache.org> on 2012/01/16 08:53:43 UTC
[jira] [Created] (JS2-1270) Creating a db2v9 database
Creating a db2v9 database
-------------------------
Key: JS2-1270
URL: https://issues.apache.org/jira/browse/JS2-1270
Project: Jetspeed 2
Issue Type: Bug
Components: Other
Affects Versions: 2.2.2
Reporter: Mads Orehøj Sørensen
Priority: Minor
When bootstraping a db2v9 (9.7) there are two bugs in the create-schema.sql (db2v8) Two indexs with the same name are created this gives an error from db2, and the create-schema is aborted:
l222: CREATE INDEX IX_FOLDER_TADATA_1 ON FOLDER_METADATA (FOLDER_ID);
l324: CREATE INDEX IX_FOLDER_TADATA_1 ON FOLDER_MENU_METADATA (MENU_ID);
Another bug of the same type
l224: CREATE UNIQUE INDEX UN_FOLDER_TADATA_1 ON FOLDER_METADATA (FOLDER_ID, NAME, LOCALE, VALUE);
l326: CREATE UNIQUE INDEX UN_FOLDER_TADATA_1 ON FOLDER_MENU_METADATA (MENU_ID, NAME, LOCALE, VALUE);
Fix: Rename the indexes
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org