Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Inconsistencies in Announcement indexes Sakai 2.8.0 Oracle conversion scripts

Description

When comparing a fresh auto-ddl'd 2.8 rc02 database against an upgraded 2.7.1 database, the following index inconsistencies were found:

– IE_ANNC_MSG_ATTRIB
2.8.0 auto.ddl: IE_ANNC_MSG_ATTRIB unique on ANNOUNCEMENT_MESSAGE(DRAFT, PUBVIEW, OWNER)
2.7.1 converted: IE_ANNC_MSG_ATTRIB on ANNOUNCEMENT_MESSAGE (DRAFT, PUBVIEW, OWNER, MESSAGE_ORDER);

I am not sure if this can be handled int he hbm files or via the hbm_indexes script.

Activity

Show:

Hudson CI Server March 16, 2011 at 10:09 PM

Integrated in sakai trunk #466 (See http://builds.sakaiproject.org:8080/job/sakai%20trunk/466/)
SAK-20279: Inconsistencies in the Announcement Indexes

Savitha Prakash March 16, 2011 at 8:05 AM

2.8.x r89881

Savitha Prakash March 16, 2011 at 8:00 AM

trunk r89880

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Conversion Script Required

Yes

Environment

Oracle9i
Created March 15, 2011 at 2:12 PM
Updated March 25, 2011 at 3:47 AM
Resolved March 16, 2011 at 8:05 AM

Flag notifications