Missing announcement ALTER TABLE and CREATE INDEX scripts in the 2.8.0 Oracle conversion scripts.
GENERAL
TESTING
GENERAL
TESTING
Description
A liquibase comparison of a virgin 2.8.0-b04 db vs a converted 2.7.1->2.8.0 db revealed a missing announcements column (MESSAGE_ORDER) as well as missing indexes in the converted database associated with work. I added the following scripts to the 2.8.0 MySQL conversion scripts as part of my test/fix work:
– alter table ANNOUNCEMENT_MESSAGE add column MESSAGE_ORDER int(11) default null;
drop index IE_ANNC_MSG_ATTRIB on ANNOUNCEMENT_MESSAGE; create index IE_ANNC_MSG_ATTRIB on ANNOUNCEMENT_MESSAGE (DRAFT, PUBVIEW, OWNER, MESSAGE_ORDER);
drop index ANNOUNCEMENT_MESSAGE_CDD on ANNOUNCEMENT_MESSAGE; create index ANNOUNCEMENT_MESSAGE_CDD on ANNOUNCEMENT_MESSAGE (CHANNEL_ID, MESSAGE_DATE, MESSAGE_ORDER, DRAFT);
We need the parallel scripts written in the Oracle dialect added to the 2.8.0 Oracle conversion scripts.
The Oracle conversion SQL for trunk and 2.8 has been committed (thanks, Beth). We still need to check the hbms to ensure consistency between new and upgraded installations.
Seth Theriault February 17, 2011 at 8:05 AM
Edited
The Oracle DDL scripts from look fine to me.
However, in a virgin 2.8 (beta5), the IE_ANNC_MSG_ATTRIB index doesn't include the MESSAGE_ORDER column. Can you double-check the hbms?
Savitha Prakash February 17, 2011 at 7:08 AM
Edited
Both 2.8.0 mysql and oracle scripts have been added into the announcement project for SAK-8005. r88513
Refer for details. Please update the oracle conversion scripts in Reference.
A liquibase comparison of a virgin 2.8.0-b04 db vs a converted 2.7.1->2.8.0 db revealed a missing announcements column (MESSAGE_ORDER) as well as missing indexes in the converted database associated with work. I added the following scripts to the 2.8.0 MySQL conversion scripts as part of my test/fix work:
–
alter table ANNOUNCEMENT_MESSAGE add column MESSAGE_ORDER int(11) default null;
drop index IE_ANNC_MSG_ATTRIB on ANNOUNCEMENT_MESSAGE;
create index IE_ANNC_MSG_ATTRIB on ANNOUNCEMENT_MESSAGE (DRAFT, PUBVIEW, OWNER, MESSAGE_ORDER);
drop index ANNOUNCEMENT_MESSAGE_CDD on ANNOUNCEMENT_MESSAGE;
create index ANNOUNCEMENT_MESSAGE_CDD on ANNOUNCEMENT_MESSAGE (CHANNEL_ID, MESSAGE_DATE, MESSAGE_ORDER, DRAFT);
We need the parallel scripts written in the Oracle dialect added to the 2.8.0 Oracle conversion scripts.