portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mads Orehøj Sørensen (Created) (JIRA) <jetspeed-...@portals.apache.org>
Subject [jira] [Created] (JS2-1270) Creating a db2v9 database
Date Mon, 16 Jan 2012 07:53:43 GMT
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


Mime
View raw message