Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-20279

Inconsistencies in Announcement indexes Sakai 2.8.0 Oracle conversion scripts

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.8.0
    • Fix Version/s: 2.8.0
    • Component/s: Announcements
    • Labels:
      None
    • Environment:
      Oracle9i
    • Conversion Script Required:
      Yes

      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.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  savithap Savitha Prakash (Inactive)
                  Reporter:
                  seththeriault Seth Theriault
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration